We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
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 Configure SQL Server

  • Last updated on

Configuration data (not archive data) is stored in SQL Server.

  • If you are running SQL Server Express on the same server as the ArchiveOne Service, such as the one installed with Advanced Auditing, no further configuration is required.
  • If you are running SQL Server Express on another server, you can set the necessary permissions by making the ArchiveOne service account, such as mydomain\ArchiveOneAdmin, a member of the machine's Administrators group.
  • If you are running SQL Server, or SQL Server Express but you do not want to change the Administrators group, you must also install Microsoft SQL Server Manager Studio.

To complete configuration:

  1. Run Microsoft SQL Server Manager Studio.
  2. Click Security/Logins.
  3. Right-click and select New Login.
  4. Enter the name of the ArchiveOne service account, for example, mydomain\ArchiveOneAdmin.
  5. Select Server roles.
  6. Select the dbcreator role.
  7. Close Microsoft SQL Server Manager Studio.

You must also ensure that the SQL Server TCP/IP protocol is enabled. To do so:

  1. Run SQL Server Configuration Manager.
  2. Expand SQL Server Network configuration, select Protocols for MSSQLSERVER or the specific instance that you will be using, if necessary, right-click TCP/IP, and click Enable.
  3. Close SQL Server Configuration Manager.

Additionally, if you intend to use the Information Manager website, the SQL Server or SQL Server Express instance must have the Full-Text Search feature enabled.

Last updated on