I am receiving the following message when connecting via query analzyer to SQL server using windows authentication.(error 18452). I have a login created with the sys admin server role on the server. When I connect using SQL authentication it works.
I added myself to the local admin group on the server, this allows it to work. The same situation is seen with another user.
I am using windows 2000 sp4 server and SQL 2000 SP3, connecting from NT4. I get the same issue if I use TCP or named pipes. We have been using SQL security but are moving to windows authentication - but this issue is stopping us.
I have checked and upgraded my version of MDAC to match the server version 2.7 (sp1)
Any help would be much appreciated.
View Complete Post