Security Compliance

Uninstall the default SQL Express from Patch Manager Server after Moving to an External DB

This article discusses uninstalling the out-of-the-box MSSQL Express from the Patch Manager Server. Will there be any negative consequences. This is something which you can do if: You have moved to an External Database, you are not using the Orion Components You are not using the Orion Web Console on your Orion Web Server. Dependency DependOnService HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services HKEY_LOCAL_MACHINE\System\ControlSet001\Servi

First published date

10/16/2018 12:39 PM

Last published date

4/22/2019 6:04 PM

Overview

This article discusses uninstalling the out-of-the-box MSSQL Express from the Patch Manager ONLY Server . This is something which you can do if:
 

  • You have moved to an External Database
  • You are not using the Orion Components
  • You are not using the Orion Web Console on your Orion Web Server.

Product section

Patch Manager

Resolution

IMPORTANT: Do not remove any CLR types.

 

1. You need to uninstall the following components from the Control Panel for removing the Patch Manager Web Console:

  • Solarwinds Collector
  • Solarwinds Information Service
  • Solarwinds Job Engine
  • Solarwinds Job Engine
  • Solarwinds Orion Core Services
  • Solarwinds Orion Improvement Program
  • Solarwinds Orion Network Atlas
  • Solarwinds Patch Manager Web Console


2. Uninstall the following to remove SQL Express. This is required as your Patch Manager database now resides on another server:

  • Microsoft SQL Server 2008 Management Objects
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2008 Native Client
  • Microsoft SQL Server 2008 R2 Setup (English)
  • Microsoft SQL Server 2008 R2 Setup Support Files
  • Microsoft SQL Server 2012 Management Objects
  • Microsoft SQL Server 2012 Management Objects
  • Microsoft SQL Server Browser
  • Microsoft SQL Server VSS Writer

That will mean that your server will be dedicated to Patch Manager.

 

If you encounter a Service dependency related error, follow the steps below:

  1. Backup the registry under HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services.
  2. Under that same key find the ewdgs service listing 
  3. Once you have found the service, right-click the string value DependOnService and choose delete.
  4. Repeat for any entries HKEY_LOCAL_MACHINE\System\ControlSet001\Services and HKEY_LOCAL_MACHINE\System\ControlSet002\Services. Remembering to backup first.
  5. Restart the server for the changes to full take effect.