contentACCESS File Archive – Best Practices version 5.4

7.Creating the needed tenant database(s)

Open page All databases (System => Tenants => All databases), click + create new and specify the required values in the Database repository window. Create a single SQL database to TECH-ARROW for FA tenant with connection name “File Archive DB” and Database user “DBAdmin”. The application will automatically set this first created database to default.

Note: When creating databases, consider the size of the company and the number of archived files. For bigger companies with a high number of files, it is recommended to create a separate databases to ensure the transparency of the processes. The first created database will be automatically set as default database for the respective tenant. This option is configurable on the Databases page using the context menu.

Configuration details
Connection name: the display name of the database in contentACCESS
Option “Use system database server”: if the database must be created on the system database server (like in this use case), select this option; otherwise, specify the required database values (Server name, Database, Schema) manually.

In section Database user, you need to specify a user for the newly created database:
Enter the credentials of the existing MSSQL user or create a new user and password by clicking on the Generate user and password button. contentACCESS will give access rights to the database on MSSQL for this user. This newly created user will have access permissions only to the created database. If you specify no explicit user in this section, then the service user will be used to access the database.

In section Connect with user, you must specify the MSSQL admin credentials:
Use explicit credentials: if this checkbox is not checked, then contentACCESS will automatically connect to the database (MSSQL) under the contentACCESS service account. If you wish to connect with an explicit user, then specify an admin user with the rights to create a new database on the database server.

Tenants: select the database owner tenant from the dropdown list (in our case TECH-ARROW for FA)

Note: Limitations to the newly created tenant can be set on the Tenants page, using the given tenant’s context menu. Select “Edit tenant limits” in the context menu.

On the next page, you may set the plugins and stores, the maximum root count, file size and file count that the TECH-ARROW tenant may archive. By default, these values are set to unlimited:

Yes No Suggest edit
Help Guide Powered by Documentor
Suggest Edit