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:
- Run Microsoft SQL Server Manager Studio.
- Click Security/Logins.
- Right-click and select New Login.
- Enter the name of the ArchiveOne service account, for example, mydomain\ArchiveOneAdmin.
- Select Server roles.
- Select the dbcreator role.
- Close Microsoft SQL Server Manager Studio.
You must also ensure that the SQL Server TCP/IP protocol is enabled. To do so:
- Run SQL Server Configuration Manager.
- 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.
- 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.