SQL Server 2005 Connection Problem

Question

Hello,

I run SQLServer 2005 locally on my machine. For some reason I can't connect using Windows Authentication anymore, I get the "Cannot generate SSPI context" message. I've tried to start in in single user mode, but it didn't work either.

Right now it's just possible to log in using SQL Server Authentication. The only user that works is however a general user, that lacks system admin rights. The login for the sa user is set to disabled.

The result is, I no longer have system permissions or access to my own db-server.
Would appreciate your help/ideas.

 

Thanks,

LANGE

Answer 1

Here are some links to start with : http://support.microsoft.com/kb/811889/, http://support.microsoft.com/kb/269541/

---

This posting is provided "AS IS" with no warranties, and confers no rights