Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Remove dependencies from the SQL Express service from evaluation installs

Remove dependencies from the SQL Express service from evaluation installs

Updated Oct 15th, 2018 


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


Evaluation versions using SQL Express 2005, 2008, 2012, 2016



New Version of NPM 12.X and SQL Express 2016


  1. Uninstall SQL Express (See Microsoft documentation for uninstall instructions)
  2. Open command prompt as local administrator
  3. Run the following commands:

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SolarWindsAdministration /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SolarWindsCortex /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SolarWindsHighAvailability /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SolarWindsRecommendations /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SWCollectorService /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SWInfoServiceSvc /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SWInfoServiceSvcV3 /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SWJobEngineSvc2 /v DependOnService /f

    reg delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RabbitMQ /v DependOnService /f

  4. Reboot the server

    *The expectation after the reboot is for all orion services to stay in a running state.



Legacy Versions of Orion and SQL Express:


  1. Stop the Orion services using Orion Service Manager.
  2. Back up your current registry.
    1. 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