Introduction

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

TSQL commands

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:

use master

select @@ServerName

EXEC sp_dropserver @server = 'EMINLLNLLNS'

EXEC sp_addserver @server = 'WNDSNLLNLLZW', @local = 'local'

That's it for this short blog post.