Votes:
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?
Created on Aug 16, 2013 1:38:10 PM by
1 Reply
Votes:
This article applies to PRTG Network Monitor 12 or later
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
Add comment