How to access ms sql server database from PRTG?

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?

mssql prtg sql

Created on Jul 4, 2016 12:45:22 AM by Thiwanka (0) ●1

5 Replies

Votes:

0

Your Vote:

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 :)

Created on Jul 5, 2016 12:28:12 PM by Stephan Linke [Paessler Support]

Votes:

0

Your Vote:

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.

Created on Jul 7, 2016 5:28:38 PM by Thiwanka (0) ●1

Votes:

0

Your Vote:

www.connectionstrings.com :)

Created on Jul 8, 2016 5:49:37 AM by Stephan Linke [Paessler Support]

Votes:

0

Your Vote:

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

Created on Jul 10, 2016 3:26:33 PM by Thiwanka (0) ●1

Votes:

0

Your Vote:

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

Created on Jul 10, 2016 5:11:36 PM by Thiwanka (0) ●1