Answer

PROBLEM

When trying to retrieve the Microsoft SQL server database list to enable Microsoft SQL server reporting in GFI MailEssentials, the database list is blank. The credentials used for this have been verified as correct.

ENVIRONMENT

• GFI MailEssentials 
• All supported environments

SOLUTION

The account used to access the Microsoft SQL Server must be the database owner of the database to be used in GFI MailEssentials, ideally have the sysadmin server role. The database has to be created prior to adding it via the GFI MailEssentials Configuration UI. To be able to pull the database list any one of the following permissions must be set for the user configured in GFI MailEssentials for Microsoft SQL database access:
 

• View any definition
• Create any database
• Alter any database

CAUSE

Improper permissions configured in Microsoft SQL server.