Overview

The article details the process to create a new SQL (Structured Query Language) Backend Database for GFI EndPointSecurity.

Process

To create a new SQL Backend Database for GFI EndPointSecurity, implement the steps listed below:

1. From the GFI EndPointSecurity Console, select Configuration > Options.

2. Select Database Backend.

3. Select Change database backend.

4. Select the SQL server from the list or enter it manually (if there are multiple instances of SQL Server on your target server, add the name as ServerName\InstanceName).

5. Type in a name for the database (it must not be an existing database name on that server).

6. Credentials:

   • The account(s) used must be given privileges in SQL Management Studio (under Security > Logins).

   • To create the database the account used has to be able to add stored procedures, create and modify the database (sysadmin server role).

   • When using Windows authentication:

     • When creating the database, the logged in the user needs the above credentials.

     • The account used for the EndPointSecurity Service must have the dbo (database owner) privileges assigned to perform all its activities.

     • A user opening the console only to view events needs read privileges assigned to the database (but will not be able to create a new database).

7. Click OK or Apply. GFI EndPointSecurity will create the database for you.