I wanted to set up DB monitoring for a DB that uses SQL Client 11 Provider=SQLNCLI11;Server=myServerNametheInstanceName;Database=myDataBase; Trusted_Connection=yes; I was unable to do so. What versions of SQL are supported to use the DB monitor?

asked 22 Oct '15, 12:32

skahlam's gravatar image

skahlam
532025
accept rate: 0%


Hi

Please check your connection string It should look something like this...

Driver={SQL Server Native Client 11.0};Server=myServer;UID=userName;PWD=passWord;

I think that you should be able to use the trusted connection.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 23 Oct '15, 14:51

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

I used the string you provided and am still not able to connect from the monitoring server. It is not a question of username or password as I am using the same credentials and Instance that I have configured elsewhere. The error states: The data source name not found and no default driver specified.

(23 Oct '15, 18:23) skahlam

Please retry connecting with the database so that the events are collected the current log file, then zip up and send a copy of your service log file to support@poweradmin.com. Also please send a screenshot of your settings along with the name of the server that you are trying to add this monitor to.

(26 Oct '15, 09:06) Quinn ♦♦

Which log file specifically do you require? I tried again and I am wondering does the SQL client need to reside on the monitoring server?

(03 Nov '15, 18:52) skahlam
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×81
×23
×22
×9
×1

Asked: 22 Oct '15, 12:32

Seen: 5,008 times

Last updated: 03 Nov '15, 18:52