i want to access ms sql server database and get some data and write some data in to it from PRTG. Is this possible? can you please describe the steps to do it?

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

Please have a look at our MSSQL Sensor. You can execute queries, evaluate results, etc. Writing to the database should be possible as well using a stored procedure or something like that :)


Jul, 2016 - Permalink

Thanx a loy. I am using MS SQL 2014 and when i tried to create ADO SQL v2 sensor it asks for connection string. what should i enter as the connection string for MS SQL 2014. can you help me by providing an example connection string for MS SQL 2014.


Jul, 2016 - Permalink

www.connectionstrings.com :)


Jul, 2016 - Permalink

there is no sample connection strings for ms sql 2014. can anyone help?


Jul, 2016 - Permalink

It worked!!! Thanks a lot for the help.


Jul, 2016 - Permalink