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