Re-naming a SQL Server machine
Posted by decipherinfosys on April 4, 2007
If you rename your SQL Server machine and reboot, SQL Server will automatically detect that you have made a change to the server name and will fix the registry enteries but you do have to correct the server name by using these commands:
sp_dropserver ‘old_server_name’
go
sp_addserver ‘new_server_name’
go
Once you do that, the right server name will get registered.
Posted in SQL Server | No Comments »
