I have migrated a SQL server from another server box that was decommissioned. They have the same name and also same IP address. However, when I connect to the server from an application using trusted connection, I get the "SSPI context not generated" error.

What I have done:

  • I have used the setspn -X to confirm there is no duplicate SPN.

  • I have changed the order of protocol to follow the order:

    Shared Memory,
    Named Pipes,

  • I have verified that when I restart SQL server, the service registers and deregisters. This was found in the SQL server log.

  • I have checked that on the SQL configuration the TCP/IP network protocol has the right IP and is active and enabled on both 32bit and 64bit.

I am running out of ideas and I am still getting the same error. I can't find any log that point to Kerberos.

  • Is the sysserver name changed .. sp_addservername ?
    – Kin Shah
    Mar 21, 2016 at 23:21
  • Was the name correct before you installed SQL or did you change it after? Mar 21, 2016 at 23:32
  • Yes the server was changed after and the sysserver was changed as well.
    – damola
    Mar 22, 2016 at 17:01
  • Make certain that the clock on both the servers is correct
    – Spörri
    Feb 6, 2021 at 21:33

1 Answer 1


Try using Microsoft Kerberos Configuration Manager for SQL Server to automatically detect and fix such SPN Issues:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.