Solarwinds Installation Resolution when you have SQL installed on the same that you are trying to remove

Correcting the Dependencies when the Customer Removes SQL Server Instance from the Orion Server.

Issue: During the Configuration Wizard after SQL Server has been removed from the Orion Server, you have an Error in the ConfigurationWizard.log stating that it could not find the SQL Service Dependency:

System.InvalidOperationException: Service MSSQL$ was not found on computer '.'. ---> System.ComponentModel.Win32Exception: The specified service does not exist as an installed service

Cause: The Information Services, Collector Serivces and Job Engine v1 and v2 Services will not update and Remove the Dependency of the SQL Server. This can occur if you install the SQL Server Express prior to the Orion Installation, or if you Installed the Evaluation of Orion and it automatically installed SQL Express.

Resolution:

1. Go into Add and Remove Programs, and Remove Information Services, Collector Services and Job Engine v1 and v2

2. Go into the Installers Folder

     a. Server 2003:    C:\Documents and Settings\All Users\Application Data\ Solarwinds\Installers

     b. Server 2008:    C:\ProgramData\Solarwinds\Installers

3. Run the Installer For Information Services, Collector Services and Job Engine v1 and v2 (when prompted select Typical)

4. Run the Configuration Wizard, select Services and select Next.

The Wizard should not complete successfully.