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.