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 SELECT @@SERVERNAME AS 'Server Name'
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