How to change the named instance name to default instance name on SQL Server 2008 R2?

Question

How to change the named instance name to default instance name on SQL Server 2008 R2?

kommagoni

SSCommitted

Points: 1898
More actions
March 1, 2013 at 9:15 am

#394291

Recently I was deployed SQL Server 2008 R2 on my windows server 2003 box with named instance, already 2005 default instance running on this box. Now i am going to uninstall the 2005 server on this box, so i would like to change the 2008 R2 named instance to default instance is that possible, please give me the suggestions.
Thanks,
Giri

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

You can't. What you can do is install 2008 as a default instance and then migrate the databasse(s) from the named instance to the default instance then uninstall the named instance after ensuring that everything (jobs, logins, SSIS packages, etc) have been migrated.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Upgrade the 2005 instance to 2008 R2, move the databases over from the named instance, uninstall the named instance.

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

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 3

After uninstalling the 2005 default instance you can simply change the port on which the 2008 R2 instance listens to 1433 and it will begin appearing on the network as if it were a default instance.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

BuntyBoy SSCommitted Points: 1876 More actions · Answer 4

Once installed you cannot change the instance name without doing uninstall and reinstall...

===========================================
Better try and fail than not to try at all...

Database Best Practices[/url]

SQL Server Best Practices[/url]

rameelster Right there with Babe Points: 779 More actions · Answer 5

You can rename a named instance to a new named instance, but you cant rename a named instance to default instance. For this you need to re install sql server.