Pythian Blog: Technical Track

In-Place Upgrade failure from SQL Server 2008 SP1 to SQL Server 2008 R2

by Prakash Karia on Sep 30, 2013 12:00:00 AM

Recently I was trying to upgrade SQL Server 2008 to SQL Server 2008 R2. The upgrade failed with error message below. TITLE: Message Details ------------------------------ The Instance ID 'MSSQLSERVER' is already in use by SQL Server instance 'MSSQLSERVER.INACTIVE'. To continue, specify a unique Instance ID. ------------------------------ BUTTONS: OK ------------------------------ Brief Background of upgrade process: Here we have an orphaned SQL instance named MSSQLServer.Inactive. Let’s understand the upgrade process here. During your upgrade, there are two stages: Pre-PointOfNoReturn Post- PointOfNoReturn Point of No Return is a point at which 2008 R2 will take over the instance name and SQL Server 2008 will be then uninstalled. Resolution: In this scenario, the setup is failing at Pre-Point Of No Return otherwise we would have tried to repair the SQL Server 2008 R2 instance. The first thing I tried was renaming the registry key (below) and upgrading it, but it did not help this time (this has helped in some cases) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\Inactive The second option is to remove the existing instance and reinstall a fresh default instance. I tried to uninstall the new SQL Server 2008 R2 instance from ADD/REMOVE Programs, but it was not showing the instance name as it was inactive. Ran below command setup /action=uninstall /instanceid=MSSQLSERVER /features=SQLEngine,Replication (You can select more features if it is installed in your environment. Refer Summary.txt for last upgrade failure) After the uninstall was successfully completed, I was able to install the SQL Server 2008 R2 instance.
Topics: MySQL DBA Lounge Technical Track Open Source

No Comments Yet

Let us know what you think

See all

See all

Subscribe by email
Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.