It seems like your browser didn't download the required fonts. Please revise your security settings and try again.

Attention

Starting May 1st, 2018, we will no longer offer the ArchiveOne family of products. This includes all editions of ArchiveOne, ArchiveOne for Files, Max Compression, and Access Security Manager. If you currently hold a maintenance and support contract, you will continue to receive our award-winning support until your contract expires, or until May 1st, 2019, whichever occurs first. The license for ArchiveOne is perpetual; therefore the software may continue to be used independently without any updates or support indefinitely.

How to Resolve ArchiveOne Database Creation Errors During Installation

  • Last updated on

ArchiveOne requires the use of a Microsoft SQL Server instance; see Prerequisites for more information. A number of databases are created in this SQL instance for the ArchiveOne configuration data to provide the auditing, search optimization, advanced discovery, and browse archive features. When installing ArchiveOne, specify whether to use an existing SQL Server instance or to install a SQL Express 2008 R2 instance on the ArchiveOne server. If there is a failure during the creation of the databases in the specified SQL instance, you are presented with the following message:

Installation step 'Create databases' failed with message 'Creating database or setting database permissions returned response: XXXX'

Where the returned response is one of the following:

  • ConnectionFailed
  • VersionNotSupported
  • FailedAddLogonToInstance
  • FailedOneDatabaseCreate
  • FailedOneDatabaseAddAccount
  • Failure

To resolve this error, see the relevant section below.

ConnectionFailed

The installer is unable to connect to the specified SQL instance; confirm that:

  • If you have manually typed the SQL instance name, confirm that this is correct and not misspelled.
  • Ensure that the SQL server hostname resolves successfully in DNS and is contactable from the Archive server.
  • The SQL instance must have the TCP/IP protocol enabled.
  • If there are any firewalls between the ArchiveOne server and the SQL server, the ports required by SQL are not blocked (for SQL server TCP port 1433, and for the SQL client TCP ports in the range 1024-5000). For more information about firewalls and ArchiveOne see Prepare for Installation.

VersionNotSupported

The installer can successfully connect to the specified SQL instance, but the SQL version is not supported for use with ArchiveOne. The SQL instance specified must be SQL Server 2008 or later. SQL Server 2005 and earlier versions are not supported.

FailedAddLogonToInstance

The installer can successfully connect to the specified SQL instance, but is unable to create a login for the ArchiveOne service account. Ensure the user running the installer, or the manually entered SQL administrative credentials, has sufficient permissions on the specified SQL instance to create new logins. Alternatively, a SQL administrator can manually create a new login for the ArchiveOne service account in the required SQL instance via SQL Management Studio. The ArchiveOne service account requires dbcreator rights.

FailedOneDatabaseCreate

The installer can successfully connect to the specified SQL instance and create the login for the ArchiveOne service account, but is unable to create the required databases for ArchiveOne. Ensure the user running the installer, or the manually entered SQL administrative credentials, has sufficient permissions on the specified SQL instance to create databases.

Alternatively, a SQL administrator can manually create the required databases via SQL Management Studio. These must be named:

  1. AOneAudit
  2. AOnePartitionData
  3. C2CAOneConfig
  4. C2CBrowseArchiveFolders

The ArchiveOne service account requires owner rights on these databases.

This can also occur if there database .mdf files are still present on disk, for example from a previous SQL installation. If you intend to use the ArchiveOne databases still present on disk, manually mount the databases via SQL Management Studio. If you do not intend to use the existing databases, rename or remove these files from disk before running the installer again.

FailedOneDatabaseAddAccount

The installer can successfully connect to the specified SQL instance and create the required ArchiveOne databases, but is unable to make the ArchiveOne service account the owner of these databases. Ensure the user running the installer, or the manually entered SQL administrative credentials, has sufficient permissions on the specified SQL instance to assign this right. Alternatively, a SQL administrator can manually set the ArchiveOne service account as the owner of the AOneAudit, AOnePartitionData, C2CAOneConfig, and C2CBrowseArchiveFolders databases via SQL Management Studio.

Failure

The installer has encountered an unspecified error. Attempt the following diagnostic steps:

  1. As the account running the ArchiveOne installation, log on to SQL Management Studio and connect to the desired SQL instance.
  2. If the connection is successful, create a new login for the ArchiveOne service account and assign this account the dbcreator role.
  3. Create databases named AOneAudit, AOnePartitionData, C2CAOneConfig, and C2CBrowseArchiveFolders.
  4. Assign the ArchiveOne service account as the owner of these databases.
  5. Connect to SQL Management Studio as the ArchiveOne service account and confirm the databases are accessible under this user context.