What does the different state in the compliance Manger job table mean? Why are the files in the Collectionservertracefiles...
SQL Compliance Manager
Destination URLs or IPs on the web for SQLCM
We are installing SQL Compliance Manager and our IT security guys will not allow us to open access to the Internet without a list of websites or IP...
How to audit multiple user types
At the server level, I want to audit privileged users for certain DDL, Security changes, failed logins, etc. At the same time, how can I...
Compliance Manager: Auditing Thousands of Similar Databases
I am in the process of running a POC for CM to see if it will fit our needs. We have 60,000 databases - most similar in schema - across 70 or so...
Compliance Manager and mirrored databases
I have two sets of mirrored databases that I would like to add to CM; any recommendations on how to proceed? I have single servers and clustered...
CM not unloading Program FilesIderaSQLcomplianceCollectionServerTraceFiles folder
Hi Today I noticed that I hadn't received any notification from CM in many hours. Upon further investigation (and testing by creating some...
Audit Event – DML Transaction Events are Server Level
We recently started getting a large quantity of DML Begin/Commit/Rollback Transaction Audit Events recorded. There is no database listed, the...
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...