Fix: Cannot Generate SSPI Context - Microsoft DSN

Fix: Cannot Generate SSPI Context - Microsoft DSN

While trying to create a Microsoft DSN in Microsoft SQL, you receive the following error.

 

Connection failed:

SQLSate: ‘HY000’

SQL Server Error: 0





[Microsoft][ODBC SQL Server Driver][Cannot generate SSPI context

 

This error is general and relates to Kerberos/NTLM errors. You must solve any incorrect SPN’s configured in your Windows profile. In addition, make sure your password in IIS for your AppPool account hasn’t changed.

Finally, you can follow this Microsoft KB article for troubleshooting this error in more detail.

* Please use the comment form below. Comments are moderated.*



Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Thursday, 28 March 2024