Mar 01

Existing Instance Not Available for Upgrade/Repair/Remove

Yesterday we ran into an issue when upgrading one of our SQL Server 2008 R2 instances to SQL Server 2012.  We ran the install as normal with the upgrade option.  When it came time to choose the instance and features to upgrade, the only options were the shared features.  What happened to our Database Engine instance?

Long story short… We found a registry key that contains the instance name was duplicated in 2 locations:

  • HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL
  • HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\RS

The solution? Since we did not have Reporting services installed on this server anymore, I took a backup of the registry and then deleted the RS folder. Restarted the install and… VOILA!

Leave a Reply