6.8	Configuring database server properties

By default, an SQL Server will inherit the properties that were set for the parent group settings (for example the ‘SQL Servers’ group). To change these settings for a specific server:

1. Click on the Configuration tab.

Screenshot 50 – ‘SQL Servers’ Group

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

3. From the Groups area, select the group that contains the SQL Server that you would like to edit, for example ‘SQL Servers’.

Screenshot 51 – Microsoft SQL Server group properties

3. In the left pane, right click on the Microsoft SQL Server to be configured and select Properties. This will bring up the SQL Servers Group properties dialog.

Screenshot 52 – The SQL Server Group properties dialog

4. Use the tabs provided in this dialog as follows:

•	General tab: Use this tab to set post collection processing rules. By default, GFI EventsManager will inherit post collection processing from the parent group.

•	Logon credentials: Use this tab to select the authentication method to be used and to specify login credentials if ‘SQL Server Authentication’ will be used.

•	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.