question

Bill Goetschius avatar image
Bill Goetschius asked

How can I change the Instance Name of a SQL Server

I have 4 SQL Servers installed on 1 machine. How do I change the Instance Name of 1 of the servers? Thanks, bill
instance
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MAXKA avatar image MAXKA commented ·
what version of sql servers? are they all same or diff? and what is the reason you want to change?
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Am I right in understanding that you want to change from SERVERNAME\Foo to SERVERNAME\bar
0 Likes 0 ·

1 Answer

·
Tim avatar image
Tim answered
Very simple, you have to drop the old instance name and then add the new instance name. I have done this dozens of times. sp_dropserver ; GO sp_addserver , local; GO Once complete you can run @@servername and it give you the new name, after a service restart. You can find all this documented [HERE]( https://msdn.microsoft.com/en-us/library/ms143799.aspx)
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image Tim commented ·
Did this get you what you need?
0 Likes 0 ·
Tim avatar image Tim commented ·
Have you been able to rename your instance? If my answer helped you please mark it as the answer so others who find this will know the solution will work for them as well. Thanks.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.