Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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 Eric Bryant on Jan 31, 2018

Views: 810 Votes: 1 Revisions: 11

Updated July 11th, 2016

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.

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