How to access MSSQL server database using ADO SQL v2 Sensor

ado-sql-v2 mssqlserver odbc

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.

Created on Jul 6, 2016 10:21:26 AM by thiwankabsharp (0) ●1

5 Replies

Votes:

0

Your Vote:

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

Your Vote:

Thank you i will look into that.

Created on Jul 6, 2016 11:51:07 AM by thiwankabsharp (0) ●1

Votes:

0

Your Vote:

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 by thiwankabsharp (0) ●1

Votes:

0

Your Vote:

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

Your Vote:

Thanks a lot!!!

Created on Jul 8, 2016 10:23:05 AM by thiwankabsharp (0) ●1