Cannot test query for custom checkpoint after upgrading sqlserver probe to 5.40

Document ID : KB000124405
Last Modified Date : 21/01/2019
Show Technical Document Details
Issue:
  • We have upgraded the SQLServer probe from v4.93 to 5.40.
  • Since the upgrade it is required to use the "Enable Cross Domain" setting in the db connection to successfully connect.
  • When creating a custom checkpoint we are unable to test the query as it cannot connect to the database, even though the db connection is successful, which prevents us from saving the custom checkpoint.
Cause:
Since probe 5.40 "Enable Cross Domain" is required when the probe is remote from SQL Server and windows authentication is used.
There is a defect in probe 5.40 which prevents the custom checkpoints from connecting with this configuration
 
Resolution:
There is a Hotfix "sqlserver.zip(5.41-TB1)" that resolves this
Please log a support case to request this and refer to Defect number DE397475