Systems Engineering and RDBMS

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.

Sorry, the comment form is closed at this time.

 
%d bloggers like this: