Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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: 67 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
23:18, 17 Jul 2016

Tags

Classifications

Public