When SQL server is renamed

We sometimes face a situation where the SQL server has been renamed but the SQL instance is still pointing to the old name.

To resolve this issue, start SQL management studio and do the following:
1. Start Query
2. Confirm which server name SQL is registered to, Type
3. The result would show the old server name
4. Type
sp_dropserver "name of the old server"
5. Type
sp_addserver “name of the new server”, local
6. Restart SQL services

  • Share this
Find Your Design Solution in the CATI Store.
Browse Products