Categories: SQL Server Windows

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.

Share
Disqus Comments Loading...

Recent Posts

VMWare vSphere 6.7 ESXTOP Output Garbled

If your VMWare vSphere 6.x environment command output of esxtop looks like a bunch of garbled gibberish (it's actually CSV… Read More

February 28, 2019 7:39 pm 19:39

How To Run RoboCopy Backup in Parallel

From time to time Windows Admins will surprise you with band-aid and bubble gum scripts, that's entirely expected I think.… Read More

February 28, 2019 12:20 pm 12:20

Windows 10 GodMode - The Ultimate Administrator Shortcut

Have you ever wondered what life might be like if the Windows 10 OS somehow had a single folder that… Read More

February 28, 2019 7:58 am 07:58

Samsung Galaxy S9 G960/G965 Stock ROM Firmware Download

There could be any number of reasons for needing to flash manufacturer stock OEM firmware on a Samsung Galaxy S9… Read More

January 24, 2019 7:42 am 07:42

Output IP Address with ipconfig Findstr Ethernet Adapter

How many times have you entered  ipconfig /all at the command line to return a single IP address, then have to strain… Read More

January 20, 2019 12:39 am 00:39

AWS SES Assistance in Enterprise Market - A Must Read

Designing e-mail solutions on a large scale can be a complex and costly challenge for a business: you need to… Read More

December 25, 2018 4:01 pm 16:01