MSSQL Server Error: "Cannot generate SSPI context"

I got following alert on tow of my servers eg Tuitionaffordable11, Tuitionaffordable23: "Cannot generate SSPI context". This error emerged when i try to connect these servers just like everyday work from other server.

Some changes caused the connection broken for Tuitionaffordable11, Tuitionaffordable23.

In 90% cases the issue is with spn settings. Let's go ahead and find the spn settings.


Use following command to list all the spns setting:

C:\>setspn -L TuteUTL12
Registered ServicePrincipalNames for CN=TuteUTL12,OU=General,OU=Terminal Servers,DC=tute,DC=net:
        MSSQLSvc/Tuitionaffordable11.prod.tute.net:1433
        MSSQLSvc/Tuitionaffordable23.prod.tute.net:1433

You can use following query to list all the spn settings for a particular account.

setspn.exe -A MSSQLSvc/Tuitionaffordable11.PROD.tute.net:1433 MSSQLSvc/Tuitionaffordable11

MSSQLSvc/Tuitionaffordable12.prod.tute.net:1433
MSSQLSvc/Tuitionaffordable23.prod.tute.net

Resolution: Let's go ahead and delete unnecessary spn settings to resolve this problem. The problem arises when there are some unnecessary settings for some server. Just delete them. There should be only one spn setting per server.

setspn.exe -D MSSQLSvc/Tuitionaffordable11.prod.tute.net Tuitionaffordable11


Along with technical learning I would like to share some great articles for anyone interested in the betterment of his/her family life

Comments

Popular posts from this blog

MSSQL Interview Question Clustering- Part2

Error 1067: The cluster service is stopped on passive node of my two node sql cluster. It throws following error when I try to start this:

Handle Sexual Harassment