The ApexSQL Monitor service is not running (4213609)

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.

Click To See Full Image.

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.

   

   Click To See Full Image.

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

   

   Click To See Full Image.

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.

   

   Click To See Full Image.

   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