I am trying to connect remote SQL Server 2008 from sql server management studio (2008) . I am able to connect by windows id but through sql login it is denied. 18456 error. 'Password did not match 'error keep coming. The management studio and remote
server are in citrix environment and same domain. I am able to do all activities using sql login on the Locally on DB Server,From the query analyser, i am able to run any transaction using "Execute as" with sql login. Only authentication part, it is recognizing
the sql password.
View Complete Post