Cannot Generate SSPI Context when connecting to the remote Computer I am connecting to Windows Server 2008 R2 which has SQL server 2005 installed via ODBC from a client machine. Recently I started getting this error


  Cannot generate SSPI Context.


I have gone through similar questions but have not got any helpful answer.
There is a problem with the SPN of the SQL Server. Look at the Microsoft Kerberos Configuration Manager tool.
https://www.microsoft.com/en-us/download/details.aspx?id=39046

This will look at the SQL Server and tell you what the SPN issue is with the machine and provide you a script to resolve. The script will need to be run by someone with Domain Admin permissions. This tool essentially automates the manual steps found in this article.
https://support.microsoft.com/en-us/help/811889/how-to-troubleshoot-the-cannot-generate-sspi-context-error-message