Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Patch Manager > Uninstall the default SQL Express from Patch Manager Server after Moving to an External DB

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

Table of contents
Created by Craig O’ Neill, last modified by Steven Bansil_ret on Jul 18, 2016

Views: 98 Votes: 1 Revisions: 10

Updated July 11th, 2016

Overview

This article discusses uninstalling the out-of-the-box MSSQL Express from the Patch Manager 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.

Environment

Patch Manager 2.0 and later

Steps

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.

 

Last modified

Tags

Classifications

Public