We are getting the error below while connecting to the MS SQL Server Database from UIM but when trying to test the database connection it is successful.
sqlserver:Profile: xxx\xxxx105002_profile/fg_freeSpace_with_avail_disk/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
- sqlserver probe configuration
Use the latest GA version, 5.42.
Required permissions are documented here:
Monitors the amount of free disk space in database file groups in %. Free space for file groups (with auto growth enabled) is calculated after considering the available disk size on which the file group is located. Notes:
A single query is executed for all the databases of the SQL server. If ANY of the database fails to execute the query, the query is considered as failed for the SQL server.
***You require System Administrator privileges on the database server to execute this checkpoint.***
In case the query reaches the SQL timeout, the checkpoint processing will be terminated and the next checkpoint will be started.
How to Increase the MS SQL Remote Query Timeout?