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 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

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