I have gotten this error multiple times and finally found the fix. I always get it when I have a new server up on the network and try to connect back to it from SSMS on another machine. I can't tell you exactly what causes it, since I don't get it consistently across machines. The quick answer is: Change the account that SQL Server itself runs under to LocalSystem.
The complete answer (including how to fix the domain account that the service runs under) can be found here.
Subscribe to:
Post Comments (Atom)
5 comments:
can you post the articale as ur link is pointing to the site.
I found that the incorrect date and time on a client which differs from a domain controller can also cause "Cannot Generate SSPI Context" failures.
Thank you a lot Josh, I have suffered due to this error multiple times as well and as you, I did not know the solution till now.
I think you may also try the way of fix sql server
Thanks!
Couldnt figure it out as i was able to connect on ip.
Post a Comment