The Multifunctioning DBA:

SSPI

1

July 12, 2011  9:02 PM

SSPI Context Errors



Posted by: Colin Smith
SQL Server, SSPI

I recently changed a SQL server from running as Local System to running as a domain account. When I did this I started to get the dreaded "Unable to Generate SSPI Context" error. I tried all that I could think of and had discussion with some people on Twitter as to what the issue may be. Eventually...

June 25, 2010  7:00 PM

SSPI errors with SQL Server 2005



Posted by: Colin Smith
SPN, SSPI, Troubleshooting

I recently had an issue with a site that was getting some users connected to a few new SQL Server 2005 instances just fine, via ODBC connections, while other users were getting SSPI errors. SSPI usually is indicative of a problem with SPN's and Kerberous Authentication. What was even more strange...


1