The ApexSQL Monitor service is not running

Applies to
ApexSQL Monitor

Description
This article explains what to do when ApexSQL Monitor service is not running.

Summary
The ApexSQL Monitor service is not running, an error message is shown, and no SQL Server instance is monitored.

Symptoms
When the ApexSQL Monitor GUI is started, the “Service is not located. Please try a different machine name or port, or verify that the service is running” message is displayed below the menu and the SQL Server instances list on the left is empty, even if you have added SQL Server instances to monitor.

Service is not located message is displayed when the ApexSQL Monitor GUI is started

The ApexSQL Monitor service does not exist, cannot be located, or isn’t running.

Resolution

  1. Check whether the service exists and can be located. Click Locate service in the menu
    If the service exists and is located, a message displaying the machine name and port number is shown.

    The Locate ApexSQL Monitor service dialog

  2. Click Save
  3. Check whether the service is running. Open Windows Control Panel
  4. Select Administrative tools
  5. Open Services

  6. Find the ApexSQLMonitor service

    The ApexSQL Monitor service in Windows Control Panel

  7. If the service doesn’t exist in the list, install it and make sure that the Add “Log on as a service” permission to the specified account option is checked
  8. If the service exists, but is not running, start it manually. Right-click it and select Start, or click the Start Service icon in the menu

  9. If the service fails to start and the following error is shown, check the security settings, as the account must have the Log on as a service right to run the ApexSQL Monitor service.

    Service start failure message

    During the installation, the option to Add “Log on as a service” permission to the specified account is checked by default. This issue is usually caused when this option is unchecked and the error message ignored, or when subsequent changes of user permissions and log on rights occur.

  10. Click Start | Run, or Ctrl+R in Windows 8
  11. Type secpol.msc
  12. In the Local Security Policy window, expand Local Policies
  13. Double-click User Rights Assignment
  14. In the right pane, find Log on as a service and double-click it
  15. In the Properties dialog, click Add User or Group and add the Windows account that the ApexSQL Monitor service uses to log on
  16. Click OK


Related posts:

  1. The “Service is not located. Please try different machine name or port, or verify that the service is running” error
  2. “Unable to open SQL Server connection” when installing application with repository database on a remote server
  3. I cannot activate ApexSQL Monitor, the ‘Hardware ID’ field is empty
  4. Top ApexSQL Log issues and resolutions – an index to often used TS articles
  5. The ApexSQL Monitor repository database transaction log file continues to grow even after data was deleted using the Purge data option