Hi Kathy, I have other server with sqlserver and we have try monitoring all DB's, but for any reason the user "usr_UIM" not working. We check the permission in SQL and the prerrequisites but we don't see where is the problem.
This is the alarms from sqlserver
Profile: ProfileX/lock_timeouts/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][SQL Server Native Client 11.0][SQL Server]VIEW SERVER STATE permission was denied on object 'server', database 'master'.
Profile: ProfileX/buf_cachehit_ratio/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][SQL Server Native Client 11.0][SQL Server]VIEW SERVER STATE permission was denied on object 'server', database 'master'.
Profile: ProfileX/login_count/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][SQL Server Native Client 11.0][SQL Server]VIEW SERVER STATE permission was denied on object 'server', database 'master'.
Profile: ProfileX/deadlocks/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][SQL Server Native Client 11.0][SQL Server]VIEW SERVER STATE permission was denied on object 'server', database 'master'.
This is the permission that was configured in user sql
We used this link for to configure sql user ---->
https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-sql-server-monitoring-release-notes#sqlserver(SQLServerMonitoring)ReleaseNotes-AccessPrerequisites
What other configuration should I do? I am not an expert in SQL
Original Message:
Sent: 10-18-2019 06:08 PM
From: Kathryn Maguire
Subject: Alerts of sqlserver probe
Miller -
I believe that the KB111971 : UIM sqlserver probe the user does not have permission to perform this action for checkpoints addresses this issue.
------------------------------
Kathy Maguire
Technical Support Engineer 4
Broadcom
Original Message:
Sent: 10-18-2019 10:55 AM
From: Miller Grisepe Echagarreta Parra
Subject: Alerts of sqlserver probe
Hi all.
I am testing the monitor for sqlserver probe, and we see this alarms. The customer indicate that the user of the DB have the permission respective and I don´t know why this alerts is generated.
Profile: ProfileDB-XXX-Pruebas/fg_freeSpace_with_avail_disk/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named '#temptab' in the database.
Profile: ProfileDB-XXX-Pruebas/logfile_usage_with_avail_disk/Run Query - DB Provider: Code=0x0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][SQL Server Native Client 11.0][SQL Server]The server principal "Monit_prm" is not able to access the database "SSISDB" under the current security context.