Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ReEstablish SQL Server after Physical Server Name Change

Recovery

ReEstablish SQL Server after Physical Server Name Change

by  JayKusch  Posted    (Edited  )
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...

Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top