Rename instance name in SQL Server 2008 R2

Question

Post reply

Rename instance name in SQL Server 2008 R2

Viewing 6 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

yoftee47 SSC Rookie Points: 35 More actions · Answer 1

yoftee47

SSC Rookie

Points: 35

May 15, 2016 at 1:59 pm

#1879153

Thank you a lot. keep it up.:-D

sqlguy80 SSCrazy Points: 2765 More actions · Answer 2

Hi,

If you have a default instance , you can rename it to whatever following the steps above. ( Default instance means the instance name = hostname of the server ).

BUT, if you have a named instance (i.e ) while setting your server up you add a new name like say testinstance , then when SQL Server is installed the instance name will be
hostname\testinstance. In this case you CANNOT change the instance name and would need to UNINSTALL SQL server and reinstall it.

Thanks,

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 3

The general recommendation is that you can change an instance name if it is the default instance
see here: http://msdn.microsoft.com/en-us/library/ms143799.aspx
But modifying an existing named instance is not recommended without uninstall/reinstall.

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 4

You can rename an instance name, why not? It's simply supported. The name of an installed sql server instance is just an alias for the unique id the instance is associated with in the physical server.
Renaming a stand-alone instance is easier than an instance in cluster.
Take a look here for example http://www.sqlmighty.com/single-post/2016/10/02/Changing-SQL-Server-name

Igor Micev,My blog: www.igormicev.com

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

Igor Micev - Wednesday, February 15, 2017 1:30 AM
You can rename an instance name, why not?

No, you can't. You can change a server name (as your link shows and as people 5 years ago stated in this thread), not an instance name.

Server01\MyInstance can be changed to SQLProd01\MyInstance, but not to Server01\SomeOtherInstanceName

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 6

GilaMonster - Wednesday, February 15, 2017 2:47 AM
Igor Micev - Wednesday, February 15, 2017 1:30 AM
You can rename an instance name, why not?
No, you can't. You can change a server name (as your link shows and as people 5 years ago stated in this thread), not an instance name.
Server01\MyInstance can be changed to SQLProd01\MyInstance, but not to Server01\SomeOtherInstanceName

Uff, that's correct. I mixed the instance with the server. My apologise. And the topic is correct too.

Igor Micev,My blog: www.igormicev.com