Overview

The Archive Stores Wizard fails at the Checking database schema... stage and the following error message is displayed:

Checking database schema...

Database cannot be used as it is not supported.

Please choose another database.

Environment

• GFI MailArchiver
• Microsoft SQL Server
• All Supported Environments

Root Cause

This issue can occur for any of the following reasons:

• The GFI MailArchiver database on the Microsoft SQL Server is set to read-only.

• The media on which the Microsoft SQL Server databases reside, or the Microsoft SQL Server *.mdf files have the Read-only attribute set.

• The credentials that are being used within the Archive Stores Wizard to connect to the Microsoft SQL Server do not have sufficient permissions.

• This issue can also arise when the GFI MailArchiver database schema has been altered manually.

Note: It is strongly advised to not manually alter the database.

Resolution

Ensure that the GFI MailArchiver database has not been configured as Read-Only in the Microsoft SQL Server.

Perform the following procedure to confirm the 'Database Read-Only' value has been set to False:

1. Open Microsoft SQL Server Management Studio.

2. Expand the Databases node.

3. Right click on the GFI MailArchiver database and select Properties.

4. Click on the Options node and ensure the Database Read-Only property is set to False.

Perform the following procedure to confirm the database MDF file has not been set to Read-only.

1. Using Microsoft Windows Explorer, browse to the folder where the database MDF file is stored. The default path is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

2. Right click on the GFI MailArchiver database MDF file and select Properties.

3. Ensure the Read-only attribute is not selected.

The credentials supplied within the GFI MailArchiver Archive Store wizard require sufficient rights to access the GFI MailArchiver database on the Microsoft SQL Server. The following procedure will allow one to confirm which users are assigned the db_owner role on the GFI MailArchiver database:

1. Open the Microsoft SQL Server Management Studio

2. Navigate to Databases > Database name > Security > Roles > Database Roles

3. Right-click on db_owner and select Properties.

4. Take note of which user is displayed under the Role Members section and use these credentials within the GFI MailArchiver Archive Store Wizard.