I am facing problem in connecting to a particular SQL server intance from my machine, using query analyzer. I have access to the databse and i'm able to connect to the server from other machines. Also i'm able to connect using sql server authentication.
The problem is that when i am trying to connect to the server with windows authentication(i have logined to windows with my network id eg DOMAIN\userid1) , the query analyzer is trying to connect with different user name other than mine(eg DOMAIN\userid2). Does any body know where the system is picking up the user id from, when connecting in windows authentication or how to resolve this issue.
Suprisingly I am able to connect to other SQL server instances successfully from my machine itself.
Please let me know in case you need any more inputs.