Tech Tip - I’m unable to test a query with the sqlserver probe.

Document created by iulian_ursu Employee on Jul 19, 2016Last modified by Melissa Potvin on Dec 17, 2016
Version 5Show Document
  • View in full screen mode

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.

sqlserver_1.jpg

In order to unlock it and be able to add the query the database access needs to be configured via the Edit/New button.

sqlserver_2.jpg

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.

sqlserver_3.jpg

 

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

Attachments

    Outcomes