6. September 2011 04:19
Renaming a computer that has SQL Server installed can be a little bit tricky and might cause some subtle bugs in software that relies on the name of the SQL Server instance it is connect to. This blog post shows how to change the SQL Server name after a rename of the computer that SQL Server is running on.
Figure 1: Major clean-up after renaming your computer
There are basically just a few commands that clean up the mess:
Here are the commands as screenshot:
Figure 2: Clean up commands in action
Here are the commands as text:
EXEC sp_dropserver @server = 'EMINLLNLLNS'
EXEC sp_addserver @server = 'WNDSNLLNLLZW', @local = 'local'
That's it for this short blog post.