How to change the GFI LanGuard backend database from Microsoft Access to Microsoft SQL

Answer

1. Open GFI LanGuard console
2. Click the Configuration tab > Database Maintenance Options > Database Backend Settings
3. Select the Microsoft SQL Server option. Type the hostname of the Microsoft SQL server that will be hosting the database from the provided list of servers discovered on your network. 
   • If you are using Microsoft SQL Express the default name would be HostName\SQLEXPRESS
   • If your Microsoft SQL server has more than one instance of Microsoft SQL Server running on it you must also use the HostName\InstanceName format. 
4. Specify the Microsoft SQL Server credentials or select the Windows Authentication option to authenticate to the SQL server using windows account details. Note: When using the Windows Authentication option make sure the GFI LanGuard Attendant service account has been added to SQL Management Studio under Security > Logins and given the 'sysadmin' server role.
5. Click OK to finalize your settings
6. Click Yes to stop all current scans