From the Beginning while working on one of our Production Database server we are usually getting and error as below , this error was coming because when the server was Installed the computer name was ‘QASISDB1‘ and after installing SQL Server it was renamed to ‘OASISDB1‘.
But in SQL server even after changing the Computer name it always refers old computer name and because of which following type of error use to appear on screen .
To resolve the error following steps can be used
Open New query windows
This command will show output as below in which it will show the old computer name which it is referring
- To change the old computer name to correct (new) computer name first we will need to delete the old computer’s information
- After successful removal of old computer name we will have to add the Corrected (new ) computer name as