Installing ARIS Connect/ARIS Design Server using a Microsoft SQL Server (mixed mode)

This procedure describes the installation on the active computer. To perform remote installations on Microsoft Windows machines, first run the ARIS Agent setup on the remote computers.

Prerequisites

Procedure

  1. Adjust the settings used by all configuration scripts.

    Edit the envset.bat file to specify the connection data of the Microsoft SQL server instance. It's a good idea to write down the credentials. They must be entered later during the ARIS setup process.

    To specify the connection data of the Microsoft SQL instance, modify the highlighted parameters:

    @ECHO OFF

    REM

    REM You may edit this section for customizing purposes.

    REM

    REM If you use named instances then append a "\" and the name of your instance

    SET MSSQL_SAG_MSSQL_SERVER_NAME=localhost

    REM The login name that is used to execute this script

    SET MSSQL_SAG_MSSQL_LOGIN_NAME=localhost\username

    REM name of database that will be created by the script.

    SET MSSQL_SAG_DATABASE_NAME=ARIS10DB

    REM folder in which the database files should be stored.

    SET MSSQL_SAG_FILEGROUP_FILE_DIR=F:\msqldata\ARIS10DB

    REM credentials of the login that is used by the application.

    SET MSSQL_SAG_APP_USER=ARIS10

    SET MSSQL_SAG_APP_PWD=*ARIS!1dm9n#

    REM schema names for the default and master tenants

    SET MSSQL_SAG_TENANT_DEFAULT=aris_default

    SET MSSQL_SAG_TENANT_MASTER=aris_master

    ...

  2. Execute the inst.bat file. This will create the database including the two mandatory tenants and the application user. The application user (APP_USER) is the Microsoft SQL user connecting ARIS and the Microsoft SQL database. The default user name is ARIS10. But you may have changed that name in the envset.bat earlier. Two schemes are mandatory. One for the master tenant and one for the default tenant. The values must be entered later during the ARIS Server setup process.
  3. If you need additional tenants you must create additional schemes for each new tenant. If you are going to create additional tenants for ARIS10.0 in order to migrate data from ARIS 9.8.7 or later, make sure to use identical names in both ARIS versions.

    Run the script create_schema_for_tenant.bat and pass the schema name as parameter, for example:

    create_schema_for_tenant.bat <schema name for additional tenant>

    If the schema already exists it will be dropped and recreated automatically. If you do not use the scripts you can also setup the database and create an empty schema for each tenant manually.

    If you use an external database management system and you have created empty schemes for additional tenants, you must assign additional tenants to these schemes after the ARIS Server setup is completed. The default tenant and the master tenant were assigned automatically.

  4. Run the ARIS Server setup.exe file as administrator
    (DVD folder Setups\Windows\ARIS_Server).
  5. Install ARIS on the active computer and use the default agent user credentials. You will change them in one of the following steps. This is to prevent unauthorized access to the system.
  6. Select ARIS Connect/ARIS Design Server to be installed.
  7. Select ARIS Aware. This will activate the dashboarding runnable and provide dashboards in ARIS Connect. If you do not select this option, the runnable will be installed but not activated.
  8. Select the installation directory if required.
  9. Only if you need to specify an external proxy server IP address for incoming requests enter the proxy server computer name or IP.
  10. Change the ARIS Agent user credentials to prevent unauthorized access to your ARIS system. Make sure to store the credentials on a save place. If you forget the credentials, you can no longer update the system or modify the configuration.

    If you change the credentials, you will be further on prompted to enter that password you've chosen whenever you start/stop the ARIS Server or access your ARIS installation using ARIS Cloud Controller.

  11. If the ports 80 or 443 are already in use, specify the load balancer port numbers to be used. If you change the default port numbers users must ad :<this port number> to the URL (see below).
  12. Select the suitable system settings option. You need to take the RAM required and the number of users who will be accessing the ARIS Server into account. For a productive system it is recommended to select the Medium or Large option.

    The Demo scenario option is recommended for demonstration purposes (laptop) only.

    Warning

    If the hardware does not fit the system requirements, a warning is prompted. In this case do not proceed the setup. Otherwise ARIS might not work reliably.

  13. To import the ARIS license file, click Import and navigate to the license archive file. Otherwise licenses must be imported after the installation.

    Make sure this file contains the required ARIS Server license. If you have purchased an ARIS Design Server license (YDS), ARIS Connect components are not available and ARIS document storage provides only basic functionality. ARIS Connect and the full range of ARIS document storage are only available if you are using an ARIS Connect Server License (YCS).

  14. Select MSSQL.
  15. Select the required JDBC driver for the Microsoft SQL database management system.
  16. Enter the connection parameters used in the envset.bat file and exactly the values used by the Microsoft SQL server.

    The values shown are the default values used in the envset.bat file and the default parameters used when setting up the Microsoft SQL server.

  17. Enter the SMTP mail processing parameters of an existing account.

    Warning

    If you don't, ARIS will not send any notifications, due to the missing mailing functionality.

    But you can configure SMTP mail processing at any later point of time. Some parameters can also be managed using the ARIS Administration of this server. Please refer to the online help of ARIS Administration.

  18. Activate Use TLS/SSL encryption to prevent password sniffing.
  19. Only if your mail server requires SMTP authentication, select the option SMTP authentication and enter the user's credentials.

    Warning

    If you enter these parameters but your mail server does not require SMTP authentication, the connection will be rejected.

  20. If you are about to use a proxy server, please enter all proxy processing parameters. You can also enter them later, using the ARIS Administration of this server. Please refer to the online help of ARIS Administration.
  21. Configure the start option:

    Select Start automatically if you want to have the server started up with every restart of your operating system.

    Select Start manually if you want to start/stop the server on the active computer manually.

  22. Start the installation process.

    If you have changed the ARIS Agent's default user credentials during this procedure, you will be prompted for that password you have chosen. Alternatively, you might want to modify the shortcut (Start > All Programs > ARIS > Administration >...). However, that bears the risk of a stolen password.

This process takes some time. Settings entered during the setup process can be adjusted. Use the reconfigure ACC command (see ARIS Cloud Controller (ACC) Command-Line Tool.pdf document) to change settings. After the ARIS Server installation has completed, you must check the installation and configure the system.