E.2 Preparing the Microsoft SQL Server Database

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.

E.2.1 Creating an Audit Database

  1. In SQL Server Enterprise Manager, click Tools > Wizards.

  2. In the Select Wizard page, expand Databases and click Create Database Wizard.

  3. Complete 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.

E.2.2 Creating an Audit Database User Account

  1. In SQL Server Enterprise Manager, click Tools > Wizards.

  2. On the Select Wizard page, expand Databases and click Create Login Wizard.

  3. On the Authentication Mode page, select SQL Server Authentication.

  4. Specifies a username, such as auditusr, and a password.

  5. On the Security Roles page, click Next.

    You do not need to grant access to any of the roles for the audit user.

  6. Select the audit database which the account must access. (This is the database that you just created.)

  7. After the wizard completes, expand Databases for the server.

  8. Select the audit database, then double-click Users in the right-hand pane.

  9. Double-click the user account.

  10. On the Permit in Database Role page, select DB_Owner, DB_Writer, and DB_Reader. Click OK when finished.