5.Creating a database to the tenant
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 tenant with connection name “Email Archive DB” and Database user “Administrator”. We won’t use the system database server (TACATEST) as it is recommended to use a separate one, so we leave the “Use system database server (TACATEST)” checkbox unchecked. The application will automatically set this first created database to default.
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, 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, 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).