Recently I was asked for a DOS batch script, that a tech person could run, to give a stand-alone instance of SQL Server the new hostname of its server.\u00a0 This batch file would be run once the server name was changed.<\/p>\n
This batch file removed the old hostname from SQL Server, and pulled the new computer name from the operating system\u2019s environmental variables.\u00a0 Then it stops & restarts SQL Server service.\u00a0 The net start & net stop should reflect the current name of the SQL Server service, and may need to also restart the SQL Agent service.<\/p>\n
Note: Normally I am asked to do this in PowerShell, but these are older servers that do not have PoweShell installed.\u00a0 Therefore the script had to be done as a DOS batch script.\u00a0 The script assumes local administrator privileges & that sqlcmd is in the executable search path.<\/p>\n
DOS Batch Script:<\/p>\n
:what SQL thinks the old server hostname is\r\nsqlcmd -E -Q \"select @@servername as 'Old Hostname';\"\r\n\r\n:SQL drops the old server name\r\nsqlcmd -E -Q \"exec sp_dropserver @@servername\"\r\n\r\n:Get the New Computer Name\r\nSET newcomputername = %COMPUTERNAME%\r\n\r\nECHO **** The New Computer Name is : %newcomputername %\r\n\r\n:SQL adds the new servername\r\nsqlcmd -E -v new=%newcomputername %\u00a0 -Q \"exec sp_addserver\u00a0 '$(new)','local'\"\r\n\r\n:Stop & Restart SQL Server\r\nnet stop mssqlserver\r\n\r\nnet start mssqlserver\r\n\r\n:SQL Server displays new servername\r\nsqlcmd -E -Q \"select @@servername;\"\r\n\r\n:pause to check for errors before exiting\r\npause<\/pre>\n","protected":false},"excerpt":{"rendered":"