Unable to connect using SQL Monitor
sqlsmurf
Posts: 3 New member
I am trying to monitor my development SQL using SQL Monitor but I have not been able to connect. I've tried for a month and still can't get it configured. When I add the server, the test connection fails on "Query cluster information" and "Detect SQL Servers". Both give me an error of "Access denied." I'm using SQL Authentication to connect and I've ensured the user has sysadmin privs. What am I doing wrong? This has become the hardest monitoring tool for SQL to configure. Also, I want to add that my development server is using the SQL Server Developer Edition...just in case that makes a difference. Please HELP!
Answers
https://documentation.red-gate.com/sm9/advanced-operations/testing-data-collection-methods
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
* will allow you to connect to all remote hosts.