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

    SELECT
    @@SERVERNAME

    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

sp_dropserver
‘QASISDB1’

GO

 

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

 

sp_addserver
‘OASISDB1’,‘local’

GO

 

 

Thanks

Prashant Deshpande

Advertisements

2 Comments

Filed under Uncategorized

2 responses to “Change Old Computer to new in SQL Server

  1. Pingback: MSSQL: Rename ServerName | Tano's Blog

  2. 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?
    Thanks!!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s