Network Management

Remove dependencies from the SQL Express service from evaluation installs Or local SQL installs

Remove Orion service dependencies from the old SQL Express service.

First published date

10/26/2018 10:19 AM

Last published date

10/4/2022 7:45 AM

Overview

This article describes how you can remove the service dependencies from the SQL Express service from evaluation installations, if you decide to migrate the database to a different SQL Server. This also applies to SQL server installed on the same Orion server.

Product section

Orion Platform

Resolution

Applies to: Evaluation versions using SQL Express 2005, 2008, 2012, 2016
Complete the following steps when you have installed an evaluation copy of Orion Platform, licensed it and decided to move the Orion database to a separate SQL instance on a different server.

Uninstall SQL Express (See Microsoft documentation for uninstall instructions)

Open command prompt as a local administrator.

Run the following commands:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

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

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

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

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

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

Also, use the following commands if you have Orion Log Analyzer installed:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

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

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

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

Also use the following commands if you have Netflow Traffic Analyzer 4.4 or later installed:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

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

Reboot the server.
After the reboot, all Orion Platform services should stay in a running state.
If you are not able to uninstall before the SQL, you can remove the dependency entries in the regedit and after that uninstall the SQL express.

NOTE: For Windows 2016 and 2019 servers, the paths HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\SolarWinds*** and HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\SolarWinds*** are needed to be updated as well. ie. HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\SolarWinds: Collector DataProcessor

Legacy Versions of Orion and SQL Express:

Stop the Orion services using Orion Service Manager.
Back up your current registry.
Note: Consult your System Administrator before performing this procedure.
Under HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services, find the dependent services for which you would like to remove the dependency. See the screenshot - relevant services are all services between SWCollectorDataProcess and SWJobSchedulerSVC excluding SWenum.
Right-click the string value DependOnService and select Modify.
Delete the service that to remove the dependency from, which will be MSSQL$SQLEXPRESS.
Remove the dependency for that service from each of the services and then delete the DependOnService from SWJobSchedulerSVC because it only has a dependency on SQL.
Repeat steps 2-4 for HKEY_LOCAL_MACHINE\System\ControlSet001\Services and HKEY_LOCAL_MACHINE\System\ControlSet002\Services if the dependencies are there.
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.
For example, the dependencies of 'SolarWinds Collector Data Processor' 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.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.