Sunday, January 8, 2012

Error : The specified @server_name does not exist

When we rename the machine name by  default it will just rename the machine name ,where as the sql server still holds the reference to old machine name.When you try to add monitoring jobs or any thing else which needs to take the machine name in to consideration then it will try to look for the old machine name which is unable to access. This error is thrown at that instance.

Fix :

select @@servername , if it is different from machine name
then drop the old & add the new one.


sp_dropserver 'old machine name'
sp_addserver 'new machine name', local
restart the sql server

2 comments: