Renaming SQL servers and SPN issues

Posted on 2011-10-22
Medium Priority
Last Modified: 2012-05-12
We have a SQL server, SQLA.  We then setup a new server to replace it, but named it SQLB for a few weeks while we set it up.  When SQLB was ready for production, we renamed SQLA to SQLX, then renamed SQLB to become the new SQLA.  Things didn't come back up very well, and I believe it has to do with SPNs.  After the renames, the SQL agent accounts were not associated with the right server name anymore.  

Can someone tell me if this sounds correct?  I created two SPNs as listed below, and then things started working.

setspn -a MSSQLSvc/SQLA:1433 se\sqlsvcaccount
setspn -a MSSQLSvc/SQL.domain.com:1433 se\sqlsvcaccount

Are there more SPNs I need to add?  Like for the host?  
Question by:jpletcher1
  • 4
  • 3
LVL 15

Expert Comment

by:Aaron Shilo
ID: 37016474
Here's an article with more info than you ever wanted to know about SQL and
 but there are links to getting setspn in there.

Author Comment

ID: 37017794
This article:  http://pcurd.co.uk/?p=113

Claims that you need to create host entries as well.  I don't see this elsewhere.  It claims you need to do the below spn entries:

SetSPN -a mssqlsrv/SQLB.example.com:1433 example\sqlservice
 SetSPN -a mssqlsrv/SQLB.example.com example\sqlservice
 SetSPN -a host/SQLB.example.com
 SetSPN -a host/SQLB

Do the host entries need to be done?
LVL 15

Accepted Solution

Aaron Shilo earned 2000 total points
ID: 37017889
i belive that all the line enries are just exampels it looks like your coverd
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.


Author Comment

ID: 37018041
So the host entries are necessary?
LVL 15

Expert Comment

by:Aaron Shilo
ID: 37018080
yes they are.

so yes you should ad them

Author Closing Comment

ID: 37085128
Thanks for the help.

Author Comment

ID: 37087061
On last follow-up question.  Is the service account that needs to be registered the SQL service account or the SQL Agent service account?  

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question