January 3, 2006 at 6:09 am
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.
January 3, 2006 at 6:50 am
Seems posted in wrong section. I'm posting this in SQL server/Administration section. So please ignore this thread.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply