New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

300.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


My ADO SQL sensor doesn’t work anymore. Why?

Votes:

0

Your Vote:

Up

Down

I changed the Service Account of the “PRTG Probe Service” on my Windows machine from “Local System” to a locally created account that is in the administrators group on the server. Now all my ADO SQL sensors have stopped working.

The error message is “Unknown Error (Code 5000000)”.

Why are my adosql sensors broken?

ado ado-sql-sensor code-5000000 probe-service prtg unknown-error

Created on Aug 16, 2013 1:38:10 PM by  Gerald Schoch [Paessler Support]



1 Reply

Accepted Answer

Votes:

0

Your Vote:

Up

Down

This article applies to PRTG Network Monitor 12 or later

The Reason for ADO SQL Sensor Errors after Changing Service Account

If you have changed the service account of the PRTG Probe Service and then encounter stopped ADO SQL sensors, this problem is probably caused by the following:

There must not be set any TEMP or TMP environment variables for the user account the PRTG Probe Services uses.

If you log into the server running the service as a (local) user, take a look at the environment variables of the user. By default, TEMP and TMP variables are set which point to the user profile. But because the user profile will not be loaded automatically with the service login, PRTG’s requests to TEMP folders fail.

The OLE-DB driver creates a temporary file in the directory specified by one of these variables. If the directory does not exist nor has the permissions, then it will not work for a common user.

Created on Aug 16, 2013 1:39:36 PM by  Gerald Schoch [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.