Connecting SQL server in Windows authentication mode

• Subair

  SSC Enthusiast

  Points: 106

  More actions

  January 3, 2006 at 6:09 am

  #111129

  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.

• Subair

  SSC Enthusiast

  Points: 106

  More actions

  January 3, 2006 at 6:50 am

  #612379

  Seems posted in wrong section. I'm posting this in SQL server/Administration section. So please ignore this thread.