Installing ARIS Publisher Server using a Microsoft SQL Server

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.

For a productive ARIS Publisher system you must select the medium or large installation option. For these installation options an external database system is required. The external database system is not included in the package. Depending on the ARIS Publisher Server license purchased, the system enables all users to simultaneously work on exports.

Prerequisite

Procedure

  1. Adjust the system as required to manage ARIS Publisher Server in combination with a Microsoft SQL Server database. For additional information about Microsoft SQL Server, visit the Microsoft SQL Server site.
  2. Open the Microsoft SQL Console.
  3. Open the Server properties dialog.
  4. On the Security tab, select the SQL Server and Windows authentication mode option (mixed mode).
  5. Create a database using the create_db.sql script.
  6. Note the database name, user name, and password. You must enter these values later during the setup process.
  7. Ensure that Latin1_General_CI_AI sorting is selected for the COLLATE statement.

    The script creates the specified data groups. Note these values. You must enter the values later during the setup process.

    ARISBPDATA: contains all database objects

    ARISBPINDEX: contains all index data

  8. Close the Microsoft SQL Console.
  9. Start the ARIS Publisher Server installation as an administrator (DVD folder Setups\Windows\ARIS_Publisher_Server).
  10. Install ARIS Publisher Server on the active computer and use the default agent user credentials. To perform remote installations on Microsoft Windows machines, first run the ARIS Agent setup on the remote computers.
  11. Select the installation directory.
  12. To import the ARIS license file right now, click Select file... and navigate to the license archive file. Otherwise licenses must be imported after the installation.
  13. Select the ARIS Publisher Server to be installed. A Report Server can only be installed on another machine. This is to optimize system performance when running reports.
  14. If you retain the settings of the installation program, the context path and the default port 14500 to the web server are entered automatically. Either make sure that the default port is not used by other programs, or enter another free port number.
  15. If you use Process Governance specify the IP address or fully-qualified ARIS Server name. Enter the port number only if it is another than the standard port.

    The Process Governance module and the Start governance process pop-up menu are only available in the Publisher exports if a Process Governance license is available for the connected ARIS Server and all Process Governance integration parameters have been entered during the ARIS Publisher Server setup process.

  16. To use the user and license management of another ARIS server, select Use the ARIS Administration of an existing ARIS server.

    Enter the URL to that ARIS Server ARIS Administration:

    http://<IP address or fully-qualified host name>:<load balancer port>/umc

    You must enter the port number only if you have changed or redirected the standard port.

    Enter the ARIS Administration user's name superuser and the corresponding password.

  17. If you are about to manage documents using ARIS document storage of another ARIS Server, enter the required parameters. Only in this case ARIS document storage will be available if customized.
  18. Select the Medium or Large installation option. You need to take the memory requirement into account to ensure optimum load distribution and better protection against failure.
  19. Select the Microsoft SQL Server as database system.
  20. Select the required JDBC driver for the Microsoft SQL database management system.
  21. Enter the connection parameters used in the create_db.sql file and exactly the values used by the Microsoft SQL server.

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

    Server

    Fully qualified name or IP address of the Microsoft SQL server.

    Port

    Port addressing the SQL server instance running over TCP. The default port number is 1433.

    Instance name

    When setting up a Microsoft SQL server, the default instance name is MSSQLSERVER. If you use named instances, append a backslash and enter the used instance name instead.

    Database name

    Name of the database that was created by the create_db.sql script. The default value is ARISBP10.

    Application user

    Login user name that is used by the application. The default value used in the from create_db.sql file is ARISBP10.

    Password

    The application user's password. The default value used in the create_db.sql file is *ARISBP!1dm95n#. This password is automatically encrypted during the setup process. You can also enter encrypted passwords.

    Data file group

    Name of the tablespace for table data that had been created earlier. The default value used in the create_db.sql file is ARISBPDATA.

    Index file group

    Name of the tablespace for index data that had been created earlier. The default value used in the create_db.sql file is ARISBPINDEX.

  22. Start the installation process.

This process takes some time. Settings entered during the setup process can be adjusted, such as standard database connection parameters. 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.

After the installation, reports are run by ARIS Publisher Server. You can additionally install a Report Server on another machine to optimize system performance when running reports. To install ARIS Publisher Report Server, start the ARIS Publisher Server setup on another machine and install the ARIS Publisher Report Server. After you have installed ARIS Publisher Report Server, exports are managed by ARIS Publisher Server and reports are run by ARIS Publisher Report Server.