Categories: SQL ServerWindows

Change SQL Server Name

If you’ve changed your Operating System hostname, you should reflect that change in SQL Server by updating the name in the Master database. SQL Server doesn’t support updating the name when involved in database mirroring, replication, or clustered environments. You’ll have to remove the feature, update the name, then re-add the feature.


SELECT * FROM [master].[sys].[servers]
 --Look for server_id=0 name is pointing to Server A
 --Server_id=0 is local server
 SELECT @@SERVERNAME --Returns(Server A)
 EXEC sp_dropserver 'ServerA'
 EXEC sp_addserver 'ServerB',local
 --Important step
 --Restart the local sql server service and the sql server agent service
 SELECT @@SERVERNAME --Returns(Server B)
 SELECT * FROM [master].[sys].[servers]
 --Look for server_id=0 name is pointing to Server B
 --Server_id=0 is local server

Read more about updating the name by Jugal Shah.

Disqus Comments Loading...

Recent Posts

FreeNAS Error Creating Pool

command '('gpart', 'create', '-s', 'gpt', '/dev/da8')' returned non-zero exit status 1. If you get this error while trying to create… Read More

June 7, 2019 3:44 pm 15:44

Change Grub Default Boot Entry on Linux Mint

I'm dual booting Windows and Linux Mint on my laptop. The grub default is to boot into Linux Mint, however… Read More

April 23, 2019 7:45 pm 19:45

How to Reset Secure Channel On Active Directory Domain Controller

When you're a little too careless about virtualizing your domain controllers, cloning, migrating, backing up and restoring, returning from vacation… Read More

April 21, 2019 8:14 am 08:14

Run Systemd Script Before System Shutdown

I tried to retain the NGINX FastCGI cache and have it persist across system reboots instead of being ephemeral by… Read More

April 20, 2019 10:14 am 10:14

Learn Systemctl Usage to Manage Systemd Service in Linux

Systemd is new service manager for Linux. It's a replacement for all previous init systems (SysV/SysVinit & Ubuntu's Upstart) and… Read More

April 20, 2019 7:55 am 07:55

Force Delete Windows Server DHCP Failover Relationship

If you've found yourself here then chances are you messed up one of your domain controllers or at least one… Read More

April 20, 2019 5:54 am 05:54