Overview
This article provides the steps required to solve an issue that may occur when you are trying to enable auditing, which fails due to a duplicate <BackEndServer> node in the server.
Information
When you are trying to enable auditing, the attempt fails, and the following error is displayed in the wizard:
Failed during: ConfigTracingStep
Details: Start Server Trace Failed: The read operation failed, see inner exception.
Root Cause Analysis
The configuration file, MArcSettings.xml, contains a duplicate <BackEndServer> node for the Microsoft SQL Server instance, which refers to an old/outdated or non-existent marc_admin login.
Diagnosis
The debug log ..\Store\DebugLogs\AuditProviders.log reads:
"info ","AuditProviders","SqlException Error: (MSSql) ConfigMArcAdminForAudit [SQLSERVER\INSTANCE]. Error execute: 'marc_admin_20130718055157' is not a valid login or you do not have permission.
;User or role 'marc_admin_20130718055157' does not exist in this database."
The following is true for the configuration file ..\Core\Data\MArcSettings.xml:
- The nodes
<MailArchiverSettings>,<ArchiveStoreProfiles>, and<BackEndServers>, contain multiple<BackEndServer>sub-nodes for the same Microsoft SQL Server instance (duplicates). - One of them contains a reference to an old/outdated or non-existent
marc_adminlogin (For example:<Login>marc_admin_20130718055157</Login>).
Solution
Warning: This procedure requires to edit files manually. If the files are edited incorrectly, it can leave the server in a non-operational state. Please create backups of any file that is edited throughout this procedure before saving any changes to them.
- Stop all GFI Archiver services.
- Open the
..\Core\Data\MArcSettings.xmlfile in a text editor (preferably one with syntax highlighting, like Notepad++ or XML Marker). - In the XML file, locate the following nodes:
<MailArchiverSettings><ArchiveStoreProfiles><BackEndServers>
- Check each
<BackEndServer>subnode and find the one that contains the<Login>element which refers to the old/outdated or non-existentmarc_adminlogin.- From the example above:
<Login>marc_admin_20130718055157</Login>
- From the example above:
- Remove the identified duplicate of the
<BackEndServer>subnode (but not other ones). - Save the file.
- Start all GFI Archiver services.
- Try to enable auditing again.
- While going through the wizard, choose Microsoft SQL Server authentication and authenticate with the SA (SysAdmin) login.
Confirmation
Auditing was successfully enabled, and no error messages were displayed.