SQL DBA : Troubleshooting Host Name Change

Scenario :

When the machine name is changed where we have installed SQL Server . All the instance services are started but replication , jobs , Alerts and Maintenance plans causes errors .

Solution :

We have to rename the instance .

Steps :

1. Check the old server name as follows

          Select @@Servername

2. Drop the server and add the new server name

          sp_dropserver <Old Server Name>

          sp_addserver <New Server Name > ,local

3. Restart the instance

4. Check the server name again

          Select @@Servername