Configuring MS SQL Server

General SQL Server requirements

The installation requires an external SQL server as a prerequisite.

Note: AI Center can use the same SQL Server as Orchestrator for metadata storage.

Important: Make sure that the SQL server can be accessed from each cluster VM.

We support versions 2016, 2017, and 2019 for Enterprise and Standard for MS SQL.

The minimum requirements for the server are:

8 (v-) CPU 32 GiB RAM 256 GiB SSD

Important: We do not support the following characters in the SQL username and password: ; # @ ? { }.

By default, we support the option for the installer to create all the databases for you in the installation process. You must provide the necessary permissions for the installer to do so in your SQL server. The installer will then create databases with default names and use them no matter connection string provided.

Alternatively, you also have the option to create your own databases. Please refer to the following table for the default names. Note that if you do not use the default names, you will need to provide the connection string in the cluster_config.json file. You can use the same database for both AI Center and Document Understanding.

The following table lists out the database names and their corresponding format.

Product / service	Default database name	Connection string format
AI Center	AutomationSuite_AICenter	JDBC
Document Understanding	AutomationSuite_DU_Datamanager	ODBC

Note: You could use the databases in an elastic pool for better cost-effectiveness.

Permissions

If you want the installer to create a database on the provided SQL server, then make sure to grant at least dbcreator role to the SQL account used to connect to the database.

If you wish to create your own databases for all the products, then the SQL account should be granted the db_owner role for both databases. If security restrictions do not allow the use of db_owner, then the SQL account should have the following roles and permissions on all databases:

• db_ddladmin
• db_datawriter
• db_datareader
• EXECUTE permission on dbo schema

SQL requirement for Full-Text Search

Document Understanding requires the SQL Server to have the Full-Text Search component of the SQL Server Database Engine, which is not always installed by default.

If you did not select Full-Text Search when you installed SQL Server, run SQL Server Setup again to add it before configuring Document Understanding.

For more info, check this guide on how to add/install features on SQL server. You can also check here all the components that can be added to the SQL Server, which includes also Full-Text Search.