Configuring SQL Servers event source properties

Similar to group properties both in concept as well as in terms of configuration, SQL Servers event source properties can be configured at both group level and individual SQL Server level.

To configure the properties of an individual SQL Server or server group

1. Click on the Configuration tab.

Screenshot 45 – Database Servers Groups

2. From the Group Type drop-down select Database Server Groups.

3. To configure the parameters of a:

•	Database Server Group: Right-click on the database server/ group to be configured and select Properties.

•	Particular computer in a database server group: Click on the database server group to which the computer group belongs. Then from the right pane, right-click on the required computer and select Properties.

4. Use the tabs provided in the properties dialog, to configure the required parameters:

•	General properties: Use this tab to change the group name.

•	Logon credentials: Use this tab to select the authentication method to be used and if required specify login credentials.

•	Operational time: Use this tab to specify the operational time for the database servers specified in this group.

•	SQL Server audit: Use this tab to configure which event processing rules will be applied against the events collected from source. By default, GFI EventsManager is set to inherit these parameters from the parent Database Server Group.

•	Settings: Use this tab to configure SQL Server event-scanning options (i.e. scan all databases, scan security events only on all databases or scan only a specific database).

NOTE: For more information on how to configure these parameters please refer to the ‘Configuring SQL Servers group properties’ section in this chapter.