I need your help!
In WinXP, I am having a problem using Windows Authentication to connect to a particular server (SQL2000). I normally use Windows Authentication. In this case, however, when I try to connect I get the following:
"Login failed for user "xxxxx\root". The only problem is I'm logged in as another domain userid (I've replaced my domain name with xxxxx to protect the guilty).
This only happens from my pc and my account to this one server. When I log on as another user, no problem. When I go to another pc, no problem with my domain userid.
There is something on my pc that is causing an unwanted impersonation!
Any ideas? (this is making me and my security guy crazy).