Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JeffS23
Posting Yak Master
212 Posts |
 Posted - 2007-12-26 : 15:49:06
|
| I have a SQL server with SQL 2000 installed and running, in parallel with a recent SQL 2005 installation (viaa named instance on the same box, etc.) - What I would like to do is "decommision" the SQL 2000 installation and "promote" the 2005 named instance to the default- is there a way to do this? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-26 : 15:54:46
|
No. You have to uninstall and install the way you want the instances to be.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-26 : 15:56:02
|
| There is no easy way to do this. You'd have to install the default instance, move your databases over, and then uninstall both the 2000 and 2005 instances (non-default). It would be a lot of work.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQL Instance to Default