March 22, 2006 at 1:08 pm
I am using SQL 2K. I am trying to connect to a SQL server from Query Analyzer using Windows Authentication from a client computer. It logs me in as the wrong user. Why would it authenticate me to another user and how do I change it back to authenticate at the user I'm logged into the client machine as.
March 22, 2006 at 1:30 pm
Right Click on the short-cut to QA and choose Ran AS then pick or enter your username.
Tim S
March 22, 2006 at 2:56 pm
It is set to Run As the account I want. it still connects as the other user.
March 22, 2006 at 6:11 pm
If you run the below command does it report the correct user?
SELECT SYSTEM_USER;
Tim S
March 22, 2006 at 6:24 pm
Thanks for the replies. I figured out how to fix the problem. Basically the computer had passwords saved to it. When I went to Control Panel->User Accounts->Advanced Tab there is a button for managing passwords with a list of servers. I selected the server I was trying to connect to and removed it from the list.
I guess the computer was using that saved Username/password to authenticate against. Must have been some other time when someone used the computer and saved a password.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply