SSPI Context Error!! |
|
The dreaded SSPI context error. It's a real pain-the-ass to troubleshoot. It can be caused by a lot of different issues. In my case, it was due to SQL not being able to register the SPNs. We tried everything documented by MS. So in a last ditch effort we deleted the SPNs by running
Setspn –d <spn name> computername
We found that in order to delete the SPN you must add the computername who is the owner of the SPN. We then bounced SQL and it worked.
So there is not a lot of good stuff out there on this issue. I talked with Sean(MidnightDBA) and he had a blog post on it. Its the best article I have found on the issue.
http://www.midnightdba.com/DBARant/cannot-generate-sspi-context/
Another option to resolve this error is using DBATools.
dbatools.io/commands/#SPN
Setspn –d <spn name> computername
We found that in order to delete the SPN you must add the computername who is the owner of the SPN. We then bounced SQL and it worked.
So there is not a lot of good stuff out there on this issue. I talked with Sean(MidnightDBA) and he had a blog post on it. Its the best article I have found on the issue.
http://www.midnightdba.com/DBARant/cannot-generate-sspi-context/
Another option to resolve this error is using DBATools.
dbatools.io/commands/#SPN