Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
russell
Pyro-ma-ni-yak
5072 Posts |
 Posted - 2010-08-31 : 13:24:50
|
I am going to rename a clustered instance (default).1. Change SQL Network Name2. Take offline3. Bring online4. Flush DNS, Cache5. Test failover6. Rebuild replication publications/subscriptions  Am I missing anything?What about SPN...does that need to be re-registered? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-08-31 : 13:33:15
|
| If you are using Windows 2008, then yes you'll need to handle the SPN. Have the SPN prepped ahead of time in the AD.We recently renamed our virtual server on one of our Windows 2008 clusters. We had the AD team add the SPN ahead of time. We ran "setspn -L domain\user" before our work to ensure it was setup properly. Then when we were ready for the switcheroo, we followed the procedure you have listed, which is the same as what BOL shows.Our SQL service account does not have access in the AD to add/drop SPNs, hence the reason why our AD team does it for us.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-31 : 13:47:35
|
Thanks Tara. Same with us, always have Network/AD team set our SPNs -- not going to allow SQL Service to be domain admin  . Since I never renamed a virtual server, thought I'd best run it out here in case of any "gotchas" Thank you |
|
|
|
Jim Beam
Posting Yak Master
137 Posts |
Posted - 2011-01-01 : 20:31:51
|
| SPN ?? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-01 : 23:48:31
|
| By the way, this went almost flawlessly. DTC (on a different server) failed after the rename. I had forgotten and failed to notice that we enlist the DTC from a web app -- meaning that the web server and SQL server participate -- yeah, bad idea, and it turns out, unnecessary in this case, but is something to be on the lookout for if anyone runs into this. |
|
|
|
|
|
|
|
|
Rename Virtual Server