Monday, May 25, 2015

Rename Windows Server name from “WIN-QITD52CONSC” to “VMWDB02”


PS C:\> sqlcmd -S VMWDB02\PROD1 –W


1> select @@servername
2> GO

-
WIN-QITD52CONSC\PROD1

(1 rows affected)


1> select serverproperty('servername')
2> GO

-
VMWDB02\PROD1

(1 rows affected)


1> sp_dropserver 'WIN-QITD52CONSC\PROD1'
2> GO


1> sp_addserver 'VMWDB02\PROD1',local
2> go


1> exit

 

Followed by a restart of SQL Service

https://msdn.microsoft.com/en-us/library/ms345235.aspx