10.1.2

Edit

Prepare MS SQL Server

note

Skip this section if you already have a prepared MS SQL server.

For IA Cloud Enterprise Edition installation you need to have an existing activated instance of the MS SQL server. The server must be up and running during the installation.

To prepare a MS SQL server:

  1. Create the <mssql_db_name> database, and specify the database name. For other options you may use the default values.

    Create DB

  2. Create the <mssql_dba_user> owner with the full-access permissions for the <mssql_db_name> database. This user must be later specified in config.yml.

    Note: for all logins, the following password policies are applied:

    • Allowed special symbols for db password for monitoring tools: @#^*():,.}<>/
    • Allowed special symbols for db password for the Analytics component: @#^*():,.;}[]/

    To create <mssql_dba_user>:

    1. On a MS SQL server, create the mssql login, specify the login name, and then make sure that the Enforce password policy check box is not selected.

    2. In the Default database box, specify the <mssql_db_name> database, and then choose English as Default language.

    3. In the Select a page group, click User mapping, and then select the <mssql_dba_user> check box to map the user to the <mssql_db_name> database. Leave all other options unchanged.

      Create DB User

    4. In the <mssql_db_name> database, click Users, select <mssql_dba_user>, and click the db_owner check box to assign the user to the db_owner role.

      Assign to group

  3. Create the following MS SQL logins for the Workfusion components (note that MS SQL logins are not db users):

    • mssql_ct_user
    • mssql_ws_user
    • mssql_sqc_user
    • mssql_ds_user
    • mssql_rpa_user
    • mssql_pm_user
    • mssql_dm_user
    • mssql_rapi_user
    • mssql_ocr_user
    • mssql_automl_mms_user

  4. For each login, specify the following parameters:

    • If you use the SQL Server authentication,

      1. Specify the login name.
      2. Make sure that the Enforce password policy check box is not selected. See the passwords policies earlier.
      3. In the Default database box, specify the <mssql_db_name> database.
      4. Choose English as Default language.

      SQL auth

    • If you use Windows authentication,

      1. Select a corresponding login name, for example, DOMAIN/mssql_login_name.
      2. In the Default database box, specify the <mssql_db_name> database.
      3. Choose English as Default language.
      4. For other options leave the default values.

      Win auth

  5. When configuring the Integration server, on the INT server, in the config.yml file, in the #MSSQL section, remember to specify the corresponding login names and passwords, that you have created on the previous step.

← PreviousNext →