NOTE TO GFI TECHNICAL SUPPORT PERSONNEL

Code changes introduced in GFI MailArchiver 2014 build 20140616 should avoid the error The EXECUTE permission was denied on the object 'RemoveAuditMarcData', database 'MArcAudit', schema 'dbo' from occurring. In case you encounter this error on GFI MailArchiver 2014 build 20140616 or a newer version please do consult with a Product Specialist before following the solution of this article (so that we can investigate the situation further).

Overview

When the audit database is not available or not accessible then GFI MailArchiver can show the following symptoms:

• GFI MailArchiver fails to create a new Archive Store.
• A warning containing 'Failed To Configure Auditing' is emailed to the GFI MailArchiver Administrator.

..\Store\DebugLogs\ might reveal the following or similar error:

"info ","ArchiveStoreManager","Configure new database for auditing." 
"info ","ArchiveStoreManager","Setup list of Archive Stores on same database server hosting the auditing database." 
"info ","ArchiveStoreManager","Total Archive Stores to setup: 1" 
"info ","AuditProviders","(MSSql) SetMarcAuditData [SQLSERVER\INSTANCE] >> " 
"error ","AuditProviders","Error: (MSSql) SetMArcAuditData [SQLSERVER\INSTANCE]. Error execute: The EXECUTE permission was denied on the object 'RemoveAuditMarcData', database 'MArcAudit', schema 'dbo'." 
"error ","ArchiveStoreManager","Error: CreateArchiveStore(): FailedToConfigureAuditing" 
"info ","ArchiveStoreManager","Try to delete created database and users: 2013 Jan - Feb" 
"error ","ArchiveStoreManager","Error: GetArchiveStoreForDate(): Store.ArchiveStoreManager.Base.AsmException: FailedToConfigureAuditing 
; at Store.ArchiveStoreManager.ASManager.ConfigureAuditing()

Environment

• GFI MailArchiver 2013 R2 build 20131111 or older
• All supported environments

Root Cause

The Microsoft SQL Server holding the audit database is not available or the required permissions to the auditing database are insufficient.

Resolution

1. Open the web interface.
2. Navigate to Configuration > Auditing.
3. Click Configure and follow the wizard.
4. Choose Microsoft SQL Server Authentication, enter the SA account and its password.
5. Finish the wizard.