To prepare the Microsoft SQL Server database, you must create an audit database and user account on the Microsoft SQL Server. The database and account enable the Secure Logging Server to log data to Microsoft SQL.
In SQL Server Enterprise Manager, click
> .In the Select Wizard page, expand
and clickComplete the Create Database Wizard.
Provide a relevant database name, such as auditdb. Do not use spaces or special characters in the database name.
NOTE:You do not need to create the database table; the Microsoft SQL Server channel driver, lgdmssql, automatically creates this table when the logging server first loads the current Channel object configuration in memory. For more information on the table structure, see Section 6.9.1, Microsoft SQL Server Channel Driver.
In SQL Server Enterprise Manager, click
> .On the Select Wizard page, expand
and click .On the Authentication Mode page, select
.Specifies a username, such as auditusr, and a password.
On the Security Roles page, click
.You do not need to grant access to any of the roles for the audit user.
Select the audit database which the account must access. (This is the database that you just created.)
After the wizard completes, expand
for the server.Select the audit database, then double-click
in the right-hand pane.Double-click the user account.
On the Permit in Database Role page, select
, and . Click when finished.