How to change SQL Server Instance Name

How to change SQL Server Instance Name ?

First collect the output of the current instance configuration

sp_helpserver
select @@servername
Execute the below query to change the instance name

sp_dropserver ‘old_name’
go
sp_addserver ‘new_name’,‘local’
go

Verify sql server instance configuration by running below queries

sp_helpserver
select @@servername

Let me know if you have any further question. Khan sqldba – MCTS.

Advertisements

5 thoughts on “How to change SQL Server Instance Name

  1. Jordan 01/10/2015 at 06:43 Reply

    I sеveгelʏ enjoy your posts. Thanks

    Like

  2. Ruben 01/22/2015 at 02:29 Reply

    Very good article! We will be linking to this great post on our website.
    Keep up the good writing.

    Like

  3. Alisha 02/04/2015 at 23:46 Reply

    Great article, totally what I was looking for.

    Like

  4. Noreen 03/10/2015 at 13:51 Reply

    Hi there, after reading this remarkable post i am as well glad to share my knowledge here
    with friends.

    Like

  5. Debra 03/14/2015 at 16:35 Reply

    I am genuinely thankful to the holder of this web site who has shared
    this great article at here.

    Like

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

%d bloggers like this: