|
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? |
|
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 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. 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
|
