1. Add SQL Server

To add a Microsoft SQL Server, you need to perform the following steps:

• Select the SQL Server option in Component Selection dialog box

• The solution offers two different ways to add SQL Server.

  • Express Configuration: Add SQL Server with minimum recommended settings.

  • Advanced Configuration: Add SQL Server with the advanced settings to customize the auditing.

1.1 Add SQL Server with Express Configuration

Perform the below steps at the Add SQL Server wizard:

• Select Express Configuration at the wizard.

• Click Next. It asks you to provide the details of SQL Server to be added.

1.1.2 SQL Server Details

• The solution lets you add a local or networked SQL Server. You can enter the name of SQL Server manually in the text box. Alternatively, you can click the

  

  icon to enumerate all SQL Servers in a list, from which you can select the required server.

• You need to select either Windows Authentication or SQL Server Authentication. We recommend that you select the latter option.

• Enter the name and password of a SQL Server user.

• Click Next to proceed. The next step shows Database Settings.

1.1.3 Database Settings

Perform the following steps to configure the database settings.

• Enter the name of an SQL Server. You can also click the

  

  icon to enumerate the list of all SQL Servers, from which you can select the desired one.

• Select the authentication type, preferably SQL Authentication.

• Enter the login credentials of an SQL administrative user.

• Enter the name of the database in which the auditing logs will be stored. Following screenshot displays the sample details.

NOTE: Click the

icon to save the current SQL Server Settings as default in Default SQL Server Settings.

• Click Test Connection to test the connection to SQL Server.

• Click Finish.

1.2 Add SQL Server with Advanced Configuration

• In the following wizard, you need to select the Advanced Configuration option.

• Click Next.

The following steps are the same as when adding SQL Server using Express Configuration and have previously been discussed in this guide. Click the following links to return to these topics:

• SQL Server Details - https://lepide.atlassian.net/wiki/spaces/LEPKB/pages/3845947393/Configuration+Steps+-+SQL+Server#1.1.2-SQL-Server-Details

• Database Settings - https://lepide.atlassian.net/wiki/spaces/LEPKB/pages/3845947393/Configuration+Steps+-+SQL+Server#1.1.3-Database-Settings

The remaining steps are discussed in detail as follows:

1.2.1 SQL Health Monitoring

• The next step displays the SQL Server Health Monitoring Settings.

• Check the box Enable Health Monitoring to enable the health monitoring of SQL Server. You must provide the following details of the computer where SQL Server is installed.

  • Computer Name: Enter the name or IP Address of the computer where SQL Server is installed.

  • User Name: Provide the name of an administrator user of that computer (It can be the domain admin user as well).

  • Password: Enter the password for the above user.

• Click Next to proceed.

The next step displays Audit Settings.

1.2.2 Audit Settings

• Here, you need to specify the auditing type. The following options are available:

  • Audit Everything: Everything at SQL Server including all server objects and databases will be audited.

  • Audit Server: Only Server objects will be audited, whereas databases will not be audited.

  • Audit Server with Selected Databases: All server objects and only selected database objects will be audited. If you select this option, then you must select which databases you want to audit.

• Check the boxes for the databases to be audited. Unchecked databases will not be audited or monitored. Click Next

The next step is Object Settings.

1.2.3 Object Settings

In this step, you can specify the server objects, database objects, and operations for auditing. You can check the box for the object that has to be monitored. Also, you can click the operation list for an object to select which operations have to be included in or excluded from auditing.

Follow the steps below to select the operations for an object.

• Select an operation cell for an object either server or database.

• It will show the

  

  arrow. Click the down arrow to access the list of operations.

• Uncheck the operations that you do not want to audit.

• Click OK to modify the selection of operations for Login object.

• Click Next . The next page displays User Settings.

1.2.4 User Settings

User Settings has the following options.

• Audit All Users: Select this option to audit all users.

• Audit Selected Users: Select this option to enable the Users section and enumerate all SQL users in it.

• Here, you can check the users to be audited and uncheck others to exclude from auditing.

• Click Next. The next page displays database settings.

1.2.5 Archive Database Settings

In this step, you need to provide archive data details. It is an optional step that you can skip it if you do not want to archive the audit data.

• Archive Database Settings are discussed in the process of adding a domain. For further information, please refer to our Advanced Configuration Guide for Active Directory.

• Click Finish to complete the process.

Once you have performed all steps to add an SQL Server through Express Configuration or Advanced Configuration, a message box appears onscreen that needs the permission to restart the solution.

• Click Yes to restart the solution.

• After the restart, a new tab is created in both Radar and Health Monitoring Tabs. Once restarted, a new SQL Server tab is created under Radar tab.

• SQL Server Settings are displayed in Settings Tab under Component Management.

• SQL Server Management lets you manage and remove the listing of SQL Server. Here, you can uninstall the auditing agent, configure the auditing, reinstall the auditing agent, and manage health monitoring.