Change Old Computer to new in SQL Server

Dear All,

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

  1. Open New query windows


    This command will show output as below in which it will show the old computer name which it is referring



  1. To change the old computer name to correct (new) computer name first we will need to delete the old computer’s information




  1. After successful removal of old computer name we will have to add the Corrected (new ) computer name as







Prashant Deshpande



  1. Oh my goodness! Impressive article dude! Many thanks, However
    I am experiencing troubles with your RSS. I don’t understand the reason why I cannot subscribe to it.
    Is there anyone else having identical RSS problems?
    Anyone who knows the solution will you kindly respond?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s