Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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: 882 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