I am receiving below errors on some servers where SQL monitoring is configured (Windows authentication):
Profile:**************-*******/logfile_usage/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]The user does not have permission to perform this action.
Summary varies with different checkpoints included in monitoring. When I manually test the connection, it shows connection OK results.
This would suggest that you do not have enough rights as the user.
The test only does a connectivity and login test.
It does not test for rights.
please make sure that the user your are connecting with as full SA rights.
Currently we do not have information in rights needed for each query.
If you need that please have your DBA review the check points you are using and provide proper level of rights.
Please ensure below pre-requisites are at least met, with emphasis to windows authentication requirement:
sqlserver (SQL Server Monitoring) Release Notes - CA Unified Infrastructure Management Probes - CA Technologies Document…