Renaming SQL servers and SPN issues

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?  
jpletcher1Asked:
Who is Participating?
 
Aaron ShiloChief Database ArchitectCommented:
i belive that all the line enries are just exampels it looks like your coverd
0
 
Aaron ShiloChief Database ArchitectCommented:
Here's an article with more info than you ever wanted to know about SQL and
SPN's.:
 http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
 but there are links to getting setspn in there.
 
0
 
jpletcher1Author Commented:
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?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
jpletcher1Author Commented:
So the host entries are necessary?
0
 
Aaron ShiloChief Database ArchitectCommented:
yes they are.

so yes you should ad them
0
 
jpletcher1Author Commented:
Thanks for the help.
0
 
jpletcher1Author Commented:
On last follow-up question.  Is the service account that needs to be registered the SQL service account or the SQL Agent service account?  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.