MS SQL Server

You can personalize your databases, filegroups, schemas, and login names during the component installation.

To install the product correctly, you must have previously created databases, filegroups, schemas, users, and logins as specified.

Each component must have its own Database(s) and login(s).

Supported versions and editions

Products in the AI Suite (with the exception of Composer) are supported with the following SQL Server versions:

  • 2012
  • 2014

Supported editions are as follows:

  • Enterprise
  • Business Intelligence
  • Standard

Character limitations for SQL server

In the names of filegroups, schemas, users, databases, or logins specified for SQL server, the following restrictions apply:

  • First character: A..Z a..z _
    unaccentuated letters, underscore
  • Other characters: A..Z a..z _ 0..9
    digits, unaccentuated letters, underscore
  • Names should not be more than 100 characters in length

Database information

If you use SQL Server version 2016, you must add an option in the database to activate compatibility level with SQL Server 2014:

alter database XXXXX set compatibility_level = 120

This option concerns all databases except Datastore Runtime databases.

Filegroups Data file

Below are the minimum disk space needed and the growth potential of the Data file for each filegroup.

IP_INDEX_WORK

  • At least one data file
  • 265 megabytes minimum disk space
  • 10% growth potential

IP_LOB_WORK

  • At least one data file
  • 265 megabytes minimum disk space
  • 10% growth potential

User rights

Database users must have the following roles:

  • db_datareader
  • db_datawriter
  • db_ddladmin
Note   The execute permission must be granted to the database user.
Note   Use dbo schema as default when creating the database users.

If the configuration for the two users (Admin and Functional) is used the roles must be distributed as follows:

Admin

  • db_datareader
  • db_datawriter
  • db_ddladmin

Functional

  • db_datareader
  • db_datawriter
  • Note: The execute permission must be granted to the Functional user.

Related Links