Home Forums SQL Server 2005 Administering Changed SQL Services Acct - "Cannot Generate SSPI Context" RE: Changed SQL Services Acct - "Cannot Generate SSPI Context"

  • You need to manually delete the SPN fo MSSQLSvc in AD linked to the old account.

    Run this in a command prompt to verify that there is a MSSQLSvc SPN registered on the old account:

    setspn -L <old account name>

    If you see a MSSQLSvc/srvname you have to delete it with setspn -D