Page History

...

• This process requires manually deploying the SQLcompliance SQL Compliance Manager Agent to the instance that hosts this database.
• The auditdatabase command does not support enabling auditing of a database that belongs to a virtual SQL Server instance hosted on a Windows cluster.
• The auditdatabase command supports case-sensitive named instances. Ensure you are using the appropriate case when you cite the instance and database names.
• The CLI does not support configuring Before-After data auditing.
• You can apply either a built-in regulation guideline or an XML template file.

...

1. Use the SQL Compliance Manager setup program to to manually deploy the SQLcompliance SQL Compliance Manager Agent to  to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database.

...

1. Use the SQL Compliance Manager setup program to to manually deploy the SQLcompliance SQL Compliance Manager Agent to  to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -Regulation {PCI | HIPAA | PCI, HIPAA}.

...

1. Use the SQL Compliance Manager setup program to to manually deploy the SQLcompliance SQL Compliance Manager Agent to  to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "FERPA regulation guideline file path".

...

1. Use the SQL Compliance Manager setup program to to manually deploy the SQLcompliance SQL Compliance Manager Agent to  to the instance that hosts the target database.
2. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "SOX regulation guideline file path".

...

1. Determine which currently audited database has the audit settings you want to apply to the new database.
2. Export your audit settings from the source database.
3. Use the SQL Compliance Manager setup program to to manually deploy the SQLcompliance SQL Compliance Manager Agent to  to the instance that hosts the target database.
4. In Windows Command Prompt, use the following syntax: SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "exported audit settings file path".

...

...

...