Verse Of The Day:
But after he had considered this, an angel of the Lord appeared to him in a dream and said, “Joseph son of David, do not be afraid to take Mary home as your wife, because what is conceived in her is from the Holy Spirit. She will give birth to a son, and you are to give him the name Jesus, because he will save his people from their sins.” — Matthew 1:20-21 (NIV)

PostHeaderIcon SQL SPNs and Authentication

Our SQL DBA was in the process of setting up a new SQL server and was having problem authenticating using his domain account.  He was able to login using the SA account though.  Everything he saw was pointing towards it being a problem with the SPNs for the new server.  We looked at the other 3 servers we had and noticed that there were two extra SPN entries for the new server.  We used the following commands to remove the SPN entries and then AD authentication worked.

setspn -D MSSQLSvc/SQLServer-FQDN domain\SQLServer
setspn -D MSSQLSvc/SQLServer-FQDN:1433domain\SQLServer

PDF pageEmail pagePrint page

Leave a Reply

Who's Online
2 visitors online now
1 guests, 1 bots, 0 members
Donate with PayPal
Did you find this site helpful? Please consider helping keep it running with a donation.

All trademarks mentioned are the property of their respective owners.