How to change SqlServer name when Windows names have changed.

When you change a windows system name on a machine that have SQL Server already installed you have to change server name in database too for thing’s to work properly. You need to run those two T-SQL commands: sp_dropserver and sp_addserver.

Leave a Reply

Back to Top