October 3, 2007 at 7:20 am
Hai,
I'm having Windows XP SP2 version and I have installed SQL server 2005. Whenever I'm opening SQL server management studio in Windows Authentication Mode I get a pop message indicating that "SSPI context error message". What may be the problem and how to sort it out?
October 3, 2007 at 2:26 pm
It seems you have problems connecting to the domain: SQL server Service is unable to get the security credentials of the logged NT user. Are U logged locally or you are using a domain account?
October 3, 2007 at 2:34 pm
There are a variety of reasons for this error. Can you explain more about your setup (workstation / SQL Server on the same domain, Kerberos configured, etc.)?
K. Brian Kelley
@kbriankelley
October 3, 2007 at 9:06 pm
Make sure your server has an SPN in Active Directory. Be sure the times between the SQL Server the DCs are not off.
October 4, 2007 at 5:48 am
I'm using default windows account to log in to SQL Server 2005
October 4, 2007 at 5:52 am
Where the active directory is there and what is meant by DC's. Can you just elucidate it further more.
October 4, 2007 at 5:53 am
Where the active directory is there and what is meant by DC's. Can you just elucidate it further more.
October 4, 2007 at 6:08 am
Active Directory = Windows domain (which are serviced by domain controllers)
SPN = Service Principal Name
Starting with Windows 2000, the default security mechanism is called Kerberos. Kerberos allows a client system to verify that the server it's talking to really is what it says it is. That's where SPNs come into play. SPNs are stored in Active Directory If the SPN is wrong, you could get that error.
K. Brian Kelley
@kbriankelley
October 5, 2007 at 6:32 am
here is a good link on how to resolve this issue.
this guy made it real comprehensive.
i'm sure there is something in there that will help you out.
i've used it in the past and it works great.
_________________________
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply