If you have, or need to change the physical name of a server after SQL Server has been installed, here are the steps to re-establish SQL Server on the newly named server.
1. Put the SQL CD in the drive and run setup program ... (this does NOT re-install SQL Server ) so don't worry. It will ask if you wish to upgrade - Answer YES. It will then simply fix the registry entries for SQL Server.
2. using QA execute the following ...
exec master..sp_dropserver 'OldServerName'
go
exec master..sp_addserver 'NewServerName', local
go
3. Stop and Re-Start the MSSQL Services and you will be good to go...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.