Profile cmd_check_connection_string, check connection, COM error [0x80040e4d]

[Miller Echagarreta]

Hi all.
I need monitoring a query with sql_response probe. We configured and all worked okay, but for any reason the configuration not work now.
With management console SQL we can connect to db instance but with the probe not.
When I test the configuration this is the error ---->

Anyone know what happen here?

[Stephen Danseglio]

What user is the robot running as where the sql_response probe is running?

------------------------------
[Designation]
[City]
------------------------------

[Stephen Danseglio]

Please also check the software requirements for sql_response and the known issues section.

https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sql_response-sql-response-monitoring/sql_response-sql-response-monitoring-release-notes#sql_response(SQLResponseMonitoring)ReleaseNotes-ProbeSpecificSoftwareRequirements

------------------------------
[Designation]
[City]
------------------------------

[Stephen Danseglio]

If you set the sql_response loglevel to 5, with logsize of 3000, and then test the connection again, it should populate the log with some helpful info on why it failed.

------------------------------
[Designation]
[City]
------------------------------

[Miller Echagarreta]

Thanks @Stephen Danseglio​ for your comments. Right now the monitoring it's working, I think the customer did something.

[Stephen Danseglio]

Probably! Im glad its working now.

------------------------------
[Designation]
[City]
------------------------------