This article applies to Barracuda ArchiveOne version 7.0 and higher.
The Mailbox Manager node in the ArchiveOne admin console displays the list of mailboxes configured for ArchiveOne. This information is stored in the C2CAOneConfig database in the ArchiveOne SQL instance. If there are any connectivity issues with the SQL instance, you may see the following error when selecting the Mailbox Manager node:
Mailbox Manager Error
There is a problem reading the list of mailboxes.
Database connection in use: Provider=SQLNCLI10;SERVER=SERVER\C2CArchiveOne;Integrated Security=SSPI;DATABASE=C2CAOneConfig;DataTypeCompatibility
Click here or contact your ArchiveOne provider for more assistance
Use the following steps to resolve the SQL connectivity error.
Step 1. Enable Advanced Service Tracing
The specific SQL error displays in the ArchiveOne service tracing.
- Enable advanced tracing using the steps in the article How to Enable Advanced Tracing. Once tracing is enabled, reproduce the error before analyzing the log file.
- If tracing is already configured, you can simply open the log file. To open the service trace folder from the ArchiveOne admin console, right-click the Status node, and click Configure.
- Click the Diagnostics tab, and click Open Service Trace Folder. The Logs folder opens in the Add-ins share.
- The attempt to connect to the SQL database is traced in the ClientConnection log which is stored in \\Configuration_Server\Add-ins\AOnePol\logs\AOnePolService\DATE_TIME\ClientConnection.
- In the ClientConnection directory, open the file with the modification date of when you reproduced the error in a text editor such as Notepad. This is likely the most recently generated .log file.
Step 2. Analyze the ClientConnection Log for the SQL Connection Error
- With the file open in Notepad, look for lines that start with: AOneMailboxManagerDatabase::Connect Connection Open failed
- The nature of the SQL error is specified in these log lines.
Step 3. Resolve the SQL Connection Error
There can be a number of different causes:
- The SQL instance name is incorrect
- The named server cannot be resolved in DNS
- There is a firewall preventing connection to the SQL instance
- The SQL Server Browser service is not running on the SQL server
- The TCP/IP protocol is not enabled for the specified SQL instance
The error in the ClientConnection log provides more detail as to the nature of the failure. You should:
- Confirm that the SQL instance name is correct and contains no misspellings.
- Confirm the specified hostname resolves in DNS from the ArchiveOne server, for example, ping this from the command line.
- If you have deployed any firewalls between the SQL server and the ArchiveOne server, ensure the necessary ports for SQL connectivity are open (see the Firewall Configuration section in Prepare for Installation).
- On the SQL server, ensure the SQL Server Browser service is running from the Microsoft Services console (services.msc).
In the SQL Server Configuration Manager, ensure the TCP/IP protocol is enabled for the ArchiveOne SQL instance.
- Launch the SQL Server Configuration Manager.
- Expand the SQL Server Network Configuration node and select the Protocols for INSTANCE, where INSTANCE is the name of the SQL instance used by ArchiveOne.
- Ensure TCP/IP is set to Enabled.