SQL Upgrade interrupted from 2008 R2 to 2012

• DBA Cabuloso

  SSCommitted

  Points: 1733

  More actions

  August 24, 2015 at 2:00 pm

  #302271

  Dear DBA's,

  I am in the middle of a migration process, from SQL Server 2008 R2 to 2012. I am using the Upgrade method.

  It is a cluster. I started by the passive node, as recommended by the documentation.

  Three instances were successfully upgraded in the passive node.

  During the fourth instance upgrade process, I received the following error message:

  Unable to cast COM object of type 'System.__ComObject' to interface type 'System.Management.IWbemServices'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{9556DC99-828C-11CF-A37E-00AA003240C7}' failed due to the following error: The requested object does not exist. (Exception from HRESULT: 0x80010114).

  Then the upgrade was interrupted. Later I tried to re-run the upgrade process in the same Instance, in the same node, but I got stuck in the "Instance Configuration" screen, where it gives me the following message:

  [Error Message]

  The Instance ID 'INFRA' is already in use by SQL Server instance 'INFRA.INACTIVE'. To continue, specify a unique Instance ID.

  ================================================================================

  Then I cannot proceed the upgrade.

  Can you give me any tips of how I can act to complete the upgrade?

  Thanks in advance.

  Lucas Benevides

  DBA Cabuloso

  ________________
  DBA Cabuloso
  Lucas Benevides

• DBA Cabuloso

  SSCommitted

  Points: 1733

  More actions

  August 25, 2015 at 6:32 am

  #1822175

  I found a post in another site that worked for me.

  http://sqldbanotes.blogspot.com.br/2013/10/how-to-fix-failed-in-place.html

  ________________
  DBA Cabuloso
  Lucas Benevides