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

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 Download

Top Tags

View all Tags

How do I correctly configure credentials for ADO SQL sensors?



Your Vote:



When scanning my ADO SQL sensor, I get the error message:

Access denied. Please check your Windows Credentials. (code: PE095)

No matter what I enter in the connection string, I always get this error. What can I do about it?


ado credentials pe-code prtg sql

Created on Dec 14, 2010 9:10:49 AM by  Daniel Zobel [Product Manager]

Last change on Dec 14, 2010 12:35:09 PM by  Daniel Zobel [Product Manager]

1 Reply

Accepted Answer



Your Vote:



Important note: The information in this article is outdated. Please use the ADO SQL v2 sensor to monitor databases using ADO connections.

This article applies to PRTG Network Monitor 8

Using the ADO SQL Sensor

You can only add an ADO SQL sensor to a device if Credentials for Windows Systems are defined for this (either directly, or inherited from the group(s) above). However, when creating this sensor, PRTG does not check if the credentials are actually correct.

For enhanced security reasons, the ADO SQL sensor only works if PRTG is able to authenticate via the defined Windows credentials. So, please make sure you enter the correct data in the device's settings. If the credentials are not valid for the device the sensor is created on, you will see the mentioned Access denied error message.

See Also

How can I monitor other SQL Servers through ADO with PRTG?

Created on Dec 14, 2010 9:27:50 AM by  Daniel Zobel [Product Manager]

Last change on May 12, 2016 12:39:19 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.