Question:
I’m unable to test a query with the sqlserver probe
Answer:
When creating a new template, the query should be added in the Query tab.
However, when trying to type/paste the query, the field seems to be greyed-out.
In order to unlock it and be able to add the query the database access needs to be configured via the Edit/New button.
Once the database access credentials have been added and tested, click OK to close the window and return to the Query tab. Now the query can be added correctly.
Additional Information:
Please check the sqlserver probe configuration guide for more information:
https://docops.ca.com/ca-unified-infrastructure-management-probes/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-ac-configuration
For issues with the probe of further questions please contact CA Technologies support:
http://www.ca.com/us/services-support/ca-support/contact-support.html
This is a copy of my Knowledge Base document TEC1073905: I’m unable to test a query with the sqlserver probe.
http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1073905.aspx