What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

How to access MSSQL server database using ADO SQL v2 Sensor

Votes:

0

I am trying to access mssql server data base using ADO SQL v2 Sensor and in the process of creating the sensor it asks for the connection string? what exact details should i give for that. should i create a odbc connection? If it is needed how should i create odbc connection and what should i give for the connection string? Any help will be very valuable. Thanks.

ado-sql-v2 mssqlserver odbc

Created on Jul 6, 2016 10:21:26 AM



5 Replies

Votes:

0

Hi,
You might check connectionstrings.com. You should be able to find the correct string there.
Best regards

Created on Jul 6, 2016 11:27:54 AM by Konstantin Wolff [Paessler Support]



Votes:

0

Thank you i will look into that.

Created on Jul 6, 2016 11:51:07 AM



Votes:

0

I am using ms sql server 2014 and in that site there were no examples for my version. can you provide me a sample connnection string for ms sql server 2014? it will be a great help

Created on Jul 8, 2016 10:12:51 AM



Votes:

0

These should work: http://www.connectionstrings.com/sql-server/

Created on Jul 8, 2016 10:16:47 AM by Stephan Linke [Paessler Support]



Votes:

0

Thanks a lot!!!

Created on Jul 8, 2016 10:23:05 AM




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.