We recently started getting a large quantity of DML Begin/Commit/Rollback Transaction Audit Events recorded. There is no database listed, the...
SQL Compliance Manager
Filtering RESTORE LABELON
We just installed Compliance Manager in our environment and I'm working on configuring it. One of the things I'm trying to figure out...
New Login Audit Event
I'm setting up and testing Compliance Manager for the first time and trying to understand what it reports on for the default...
Addressing License CLL Issues in SQL Compliance Manager
IDERA has recently updated the license library for our products which has caused some of our customers to receive a license prompt upon...
Install without sysadmin
Is it possible to install and operate SQL Compliance Manager using an AD account that does not have sysadmin privileges on any server --...
Present Compliance Manager Audit Data in Front-End Application
Is there a way to access and present audit data from SQL Compliance Manager in a front-end user application? An API to query and retrieve data would...
EventType and EventClass definitions
I would like to know what the EventType numbers in the Events table stand for? Also would like to know what the EventClass numbers stand for....
Best Practices for Deployment of SQL Compliance Manager
This document deals with the best practices of implementation and deployment of IDERA’s SQL Compliance Manager....
SQL Compliance Manager — SOX Regulation
I see that you have several specific compliance regulations (PCI DSS & HIPAA) upon setting up a database to be audited, but in your...
SQL Compliance Manager – Filtering
Sql Server 2012 Database Audit's audit sysadmins when you specify the principal DBO. However, this causes ALL the sysadmins to be...
SQLcm exception and duplicate records
Hello, We are getting the following error every 2.5 hours. "An error occurred starting traces for <servername>. Error:...
Capture transaction status for DML Activities is disable
After installing Idera SQL compliance manager, i add A new audited server. in audited database properties, audited activities tab, the option of...
Events occurring within MS SQL Management Studio
Is there a way to see what actions are taking place within the SQL Management Studio. My reports can only show me the user and if they select...
SQL Trace Failed
I keep getting the below error: An error occurred starting traces for instance INSTANCENAME. Error: Procedure expects parameter...
Audit Select Statements
How does one audit select statements in terms of what the user sees. For instance if I run the following scripts –Begin Script declare @id int...
Can't register new server
I have a license for 5 servers and currently only have 2 registered, there were more but I removed them. Now every time I try to add a new server it...
No heartbeat
Even though we have restarted the server and the services compliance manager has not had a heartbeat since November 29. This is when we changed...
[Help]ERROR: Some or all identity references could not be translated.
Permissions Check for SQL Server Instance VMELCOGEM-07MSSQLSERVER_EP: SQL Server has permissions to the agent trace directory. A connection could...
Not tracking the actual data when used with ORM like nhibernate
Hi, I am currently evaluating Idera’s SQL Compliance Manager for our product. We are using SQL Sever 2014 with Nhibernate as our ORM. I have...
"Failed integrity check" in Change Log
09/10/2015 I have a nightly process that runs this command for each of our audited servers: SQLCMCMD checkintegrity <AuditedServerName>. One...
DDL Invalid – Missing event types in Compliance Manager
If you are auditing a SQL server that is running extended event traces, you may be seeing events come through in SQL Compliance Manager of category...
Overlapping Filter Application?
How do overlapping filters get handled by Compliance Manager. For example, I want a general filter that brings in anything from domainuser1 for all...
Feature Request-Filter to exclude tables from view
We have a table called SomeSensitiveData. UserA does not have SELECT rights to the table. We have a view called v_NoSensitiveData that includes most...
Agent ForeignSecurityPrincipal Error
While tracking down an issue in the windows event logs, I noticed a regularly occurring error from the SQLcompliance Agent. The error says...