SQL SERVER – Installation Failure – Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed

SQL
4 Comments

This is one of the situations where my client installed one clustered instance of SQL Server and the second one was failing. In this blog, I would share my findings of error: Specified instance via transform is already installed. MSINEWINSTANCE requires a new instance that is not installed.

THE SITUATION

My client tried installing SQL Server clustered instance with name Contoso. It failed with below error in Summary.txt file.

Feature: Database Engine Services
Status: Failed: see logs for details
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x86D80052
Error description: The common properties for resource ‘SQL IP Address 1 (CONTOSO)’ could not be saved. Error: There was a failure to call cluster code from a provider. Exception message: The cluster IP address is already in use.
MSI (s) (A0:54) [16:36:00:810]: Specified instance {863E9807-97F0-417A-9957-DE4372A13404} via transform :InstID02.mst;:InstName02.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.

It looks like we haven’t un-installed the previous installation which was a failure. As per one of the StackExchange link it mentioned “This means in the windows installer registry there are remnants of the previous installation which has left orphaned entries there. You have to manually remove it or use some tool.”

THE SOLUTION

Now, we knew that we need to clean up SQL install but the problem was that none of the uninstall UI options were showing us failed instance. I found below tool to look into a registry of MSI database.

I also found an interesting WMIC command which also helped me.

WMIC PRODUCT Where "Caption like '%SQL%'" GET Caption, IdentifyingNumber

Here is the output of the command from my lab server.

SQL SERVER - Installation Failure - Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed msinew-err-01

As per Microsoft’s blog, we did cleanup using a list of all the GUIDs for which we needed to run uninstaller using below from command prompt.

Msiexec /X {GUID}

Almost all components got removed and few failed. There were some stale entries in the below keys.

HKEY_CLASSES_ROOT\Installer\Products\
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products

We need to search for {GUID} and remove the hive which holds it.

Always take backup of the registry before making any change and don’t tell anyone how you solved the issue. Please comment and let me know if you found some other tricks.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQL SERVER – Cluster Install Failure – Code 0x84cf0003 – Updating Permission Setting for Folder Failed
Next Post
SQL SERVER – Which Settings Change in sp_configure Needs Restart to Take Effect?

Related Posts

4 Comments. Leave new

  • I was trying to uninstall sql server 2017 dev edition from last few days. Finally found the working solution. Thank you very much !!

    Reply
  • Sivaramakrishna Movva
    April 11, 2019 9:52 pm

    Thank you it saved my time

    Reply
  • I am trying to remove one of the instance of SSAS and using this remove command, i am now getting a popup saying – SQL Server Setup has detected that no instance ID was passed to the setup. Setup cannot continue pass a valid instance ID to continue the setup

    Reply
  • I’m having the same issues trying to upgrade a SQL Server 2016 instance to a SQL Server 2019

    Reply

Leave a Reply

Menu