Home / server / Questions / 99797
Accepted
empz
Asked: 2010-01-06 13:24:12 +0800 CST

How to change the default instance of SQL Server?

  • 772

we have a dev server. First we had SQL 2000 (default instance), when SQL 2005 came out, we installed it as a named instance. Nowadays we barely use the SQL2000 instance, but this is the default. We would like the SQL2005 to be the default instance and make the 2000 a named one. Is this even possible?

Thank you!

sql-server-2005

2 Answers

  1. Best Answer

    Unfortunately, no. You'll need to upgrade the default instance to SQL 2005, remove the 2005 named instance and reinstall SQL 2000 as a named instance. Or just wipe clean and install SQL 2005 first as the default and SQL 2000 as a named instance.

    Any reason you need to keep the SQL 2000 instance around?

    • 5

  2. I did step 1 and 2 from here and it worked. Didn't have to reinstall SQL Server.

    • 0