The “Service is not located. Please try different machine name or port, or verify that the service is running” error

Applies to
ApexSQL Monitor

Symptoms
The ApexSQL Monitor encounters the error “Service is not located. Please try different machine name or port, or verify that the service is running” after successful completing of the installation

Service not located error shown in ApexSQL Monitor

Reason
Due to a bug, the above mentioned error will be displayed because the Monitor.dat file contains the inappropriate URL and under certain circumstances, it will disable the use of ApexSQL Monitor

Affected versions:
ApexSQL Monitor 2014.01 and 2014.02

Resolution
When this particular error is encountered, follow the steps below:

  1. Close the ApexSQL Monitor client interface (GUI)
  2. Stop the ApexSQL Monitor service from Control Panel\All Control Panel Items\Administrative Tools
  3. Navigate to the folder C:\ProgramData\ApexSQL\ApexSQLMonitor and open the file Monitor.dat with Notebook or any convenient text editor. The content of the file will look like this:
     <?xml version=”1.0″ encoding=”utf-8″?>
    <ExternalInfo xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
    <MonitorServerName>SERVER2012R2</MonitorServerName>
    <SignalRPort>39478</SignalRPort>
    <Url>http://localhost:{0}</Url>
    </ExternalInfo>
     
  4. Replace the localhost with the * so the line should look like this:
    <Url>http://*:{0}</Url>
  5. Start the ApexSQL Monitor service from Control Panel\All Control Panel Items\Administrative Tools
  6. Start ApexSQL Monitor and application should indicate that service is located successfully

We are in the process of resolving this issue and the fix will be available soon

If you experience this issue and need additional help, please contact ApexSQL Support team. We apologize for any inconvenience.