Verse Of The Day:
Restore to me the joy of your salvation and grant me a willing spirit, to sustain me. — Psalm 51:12 (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
1 visitors online now
0 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.