When the machine name is changed where we have installed SQL Server, all the instances services are started but replication, Jobs, Alerts, Maintenance plans causes errors. Hence we have to rename the instance.
To rename instance we can use the following SP
1. Check the old server name as follows
2. Drop the server and add the new server name
SP_ADDSERVER <newName>, local
3. Restart the instance
4. Check the server name againSELECT @@servername