Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > Remove dependencies from the SQL Express service from evaluation installs

Remove dependencies from the SQL Express service from evaluation installs

Table of contents

Overview

This article describes how you can remove the service dependencies from the SQL Express service from evaluation installations.

Environment

Evaluation versions using SQL Express 2005 or 2008

Steps

1. Stop the Orion services using Orion Service Manager.

2. Back up your current registry.

Consult your System Administrator before performing this procedure.

3. Under HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services, find the dependent services for which you would like to remove the dependency. Screenshot below has the services, it is everything between SWCollectorDataProcess and SWJobSchedulerSVC excluding SWenum.

Please note, for NPM 12 we also have the RabbitMQ service which must be edited.

sql express 1.jpg

4. Right-click on the string value DependOnService and select Modify.

sql express 2.jpg

5. Delete the service that you would like to remove the dependency from, which will be MSSQL$SQLEXPRESS.

sql express 3.jpg

6. Remove the dependency for that service from each of the services and the delete the DependOnService from SWJobSchedulerSVC because it only has a dependency on SQL.

sql express 4.jpg

7. Repeat steps 2-4 for HKEY_LOCAL_MACHINE\System\ControlSet001\Services and HKEY_LOCAL_MACHINE\System\ControlSet002\Services if the dependencies are there.

8. Restart your computer.

After the restart, you should be able to stop or uninstall SQL from the server without it stopping the Orion services. 

 

You can also use the SC.exe command to remove the 'mssqlserver' dependency from each of the respective SolarWinds services.  DISCLAIMER:  It's still tedious, but for those who would rather not touch the registry this is another way to address the issue.

 

For example,  the 'SolarWinds Alerting Engine' process had a single dependency on the 'mssqlserver' process.  To remove that I used the SC command as follows:

 

     run sc config "SolarWindsAlertingEngine" depend= ""

 

NOTE:  Be sure to use the actual service name and not the display name as shown in the list of services.  Using "" for the depend= variable will remove ALL dependencies.

 

You'll notice there are some SolarWinds processes that include dependencies in addition to SQL server process.  In those cases it's probably wise to keep those defined.  Make a note what the other dependencies are and reapply them using the SC command, while leaving out the SQL server process.

 

So for  'SolarWinds Collector Data Processor':  its dependencies originally included: 'Message Queuing', 'Net. Tcp Port Sharing Service' and the' mssqlserve' process.  I used the following:

 

     run sc config "SWCollectorDataProcessorSvc" depend= "MSMQ/NetTcpPortSharing"

 

Note that multiple dependencies are defined using the '/' as the separator with no spaces and the actual service (not display) names are used.

 

 

Last modified
05:55, 19 Apr 2017

Tags

Classifications

Public