Monday, July 15, 2013

Change default SQL instance to another version

I happened to install SQL Server 2000 on the machine where I already had SQL Server 2008 as default instance. I forgot to install SQL Server 2008 as named instance, so it actually overwrote SQL Server 2008 default instance. After installing SQL 2000, I was able to use SQL 2000 as default instance. After a few testing, I decided to uninstall SQL 2000 but there was some failure to do so because somehow uninst.isu cannot be found.

I didn't have much to dig into it since I need to use SQL 2008 right away. So I tried to change default SQL instance to SQL 2008. Of course this is not recommended by Microsoft and never will be. Please note this is only to change default instance location and does not uninstall SQL 2000, which should be done later seperately.

The steps are:

1) Stop SQL Server and SQL Agent services
2) To change default instance location, I did change the ImagePath of the following registry.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\ImagePath

Old path pointed to SQL 2000 and I changed it to:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe

3) To change default SQL agent instance, I also change this registry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT

Old path pointed to SQL Agent 2000 path and changed to :
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlagent.exe

4) Start SQL Server and SQL Agent services.

It worked for me, but might not work for you. I am documenting this for my future reference :-)

No comments:

Post a Comment