Thursday, March 22, 2012

Cannot generate SSPI context. (.Net SqlClient Data Provider)

Cannot generate SSPI context. (.Net SqlClient Data Provider)

The reason for this error in my case was somehow related to SPN.

The easiest first step to troubleshoot “Cannot Generate SSPI Context” is to run SQL server under Local System account and gracefully shut it down. You can then change your service account to whatever you want. SPN will not be registered and clients will fallback to use NTLM.

“Cannot Generate SSPI Context” error message, more comments for SQL Server