Before you can begin audit and monitoring service, you must create at least one installation and a management database. Creating the management database, however, requires SQL Server system administrator privileges on the computer that hosts the SQL Server instance. If possible, you should have a database administrator add your Active Directory domain account to the SQL Server system administrators role.
If you have not been added to the system administrators role, you should contact a database administrator to assist you. For more information about creating a new installation when you don’t have system administrator privileges, see How to create an installation without system administrator privileges.
To create a new installation and management database as a system administrator:
- Log on using an Active Directory account with permission to install software on the local computer.
- Open the Audit Manager console to display the New Installation wizard.
The New Installation wizard displays automatically the first time you start Audit Manager. You can also start it by clicking Action > New Installation or from the right‑click menu when you select the Audit Manager node.
- Type a name for the new installation, then click Next.
Tip: Name the installation to reflect its administrative scope. For example, if you are using one installation for your entire organization, you might include the organization name and All or Global in the installation name, such as
AcmeAll. If you plan to use separate installations for different regions or divisions, you might include that information in the name, for example
AcmeBrazilfor a regional installation or
AcmeFinancefor an installation that audits computers in the Finance department.
- Select the option to create a new management database and verify the SQL Server computer name, instance name, and database name are correct, then click Next.
If the server does not use the default TCP port (1433), you must provide the server and instance names separated by a backslash, then type a comma and the appropriate port number. For example, if the server name is ACME, the instance name is BOSTON, and the port number is 1234, the server name would be
If you’re connecting to a SQL Server availability group listener, click Options (next to the Server Name) and enter the following connection string parameters:
Type the license key you received, then click Add or click Import to import the keys directly from a file, then click Next.
Accept the default location or click Browse to select a different Active Directory container to which you want to publish audit-related information, then click Next.
Select Enable video capture recording of user activity if you want to capture a full video record of desktop activity on Windows computers when users are audited, then click Next.
Selecting this option enables you to review everything displayed during an audited user session, but will increase the audit store database storage requirements for the installation. You can deselect this option if you are only interested in a summary of user activity in the form of audit trail events. Audit trail events are recorded when users log on, open applications, and select and use role assignments with elevated rights.
- Review details about the installation and management database, then click Next.
If you have SQL Server system administrator (sa) privileges and can connect to the SQL Server instance, the wizard automatically creates the management database.
- Select the Launch Add Audit Store Wizard option if you want to start the Add Audit Store wizard, then click Finish.
If you want to create the first audit store database at a later time, you should deselect the Launch Add Audit Store Wizard option and click Finish.
For more information about adding the first audit store database, see Create the first audit store.