Overview

This article guides you on how to change the GFI LanGuard database backend for Microsoft Access and MS SQL.

Process

1. Open the GFI LanGuard console and navigate to the Configuration > Database backend settings.
   
   
2. If Microsoft Access is selected:
   
   1. Select Browse and navigate to the intended Save in: folder.
   2. Click Apply.
      This allows GFI LanGuard to create the Microsoft Access database.

NOTE: Microsoft Access is only recommended to be used for evaluations purpose.

3. If Microsoft SQL server is selected:
   1. ​Type the SQL instance name in the Server: field.
      • The Microsoft SQL instance name can be seen within the Microsoft SQL Management Studio; usually found near the top with a cylinder and a play icon; normally it has this format <ServerName>\SQLEXPRESS.
      • For Microsoft Non-SQL Express instances, the instance name is typically the name of the machine where Microsoft SQL is installed.
   2. Provide credentials of an account that has the sysadmin role set assigned within Microsoft SQL.
      1. If using Windows Authentication make sure the account used for the GFI LanGuard Attendant service has been added to Microsoft SQL Management Studio under Security > Logins and given the "sysadmin" server role.
      2. Select Apply and GFI LanGuard should create the SQL database.

NOTES:
The Microsoft SQL database name created by GFI LanGuard is static and should not be edited.
If a failure in connecting to the Microsoft SQL instance is presented, ensure connectivity via an ODBC test.

Related Articles

Converting MS Access to MS SQL After Upgrading from LanGuard 9 to 2011