I am receiving "cannot generate sspi" error when I try to connect a sql instance remotely. I suspected the issue might be with spn and verified that spn was registered properly on the service account(confirmed the same with AD team as well). Also tried to get the server removed from domain and rejoined. The issue still persists and issue started occurring all of sudden and there were no changes on the server (patching, reboot). Would appreciate if anyone can provide some lead to resolve this issue?
Sql-server – cannot generate sspi – None of Solution worked!
kerberosspnsql server
Related Question
- SQL Server Error – Cannot Generate SSPI Context Solutions
- Sql-server – SQL Server and SSPI handshake failed error
- SQL Server – Resolving ‘Cannot Generate SSPI Context’ Error
- SQL Server – Access Cannot Generate SSPI Context
- Sql-server – Mirroring issue with mirror server
- Sql-server – Old ODBC app throws “cannot generate sspi context” on Windows 10
- Sql-server – Kerberos Issue – Anonymous Login
- Sql-server – Linked Server connection started failing with “Cannot generate SSPI context … SQL Server Network Interfaces: The logon attempt failed” error
Best Answer
Having no SPN does not cause this error. Having an invalid SPN does. It's not enough to make sure an SPN exists, you have to make sure it is owned by the SQL Server service account and that it is configured correctly.
Follow the advice I blogged here: http://sqlsoldier.net/wp/sqlserver/advanced-troubleshooting-week-at-sql-university-lesson-1