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.
The file create_db.sql (<installation media\Add-ons\DatabaseScripts\PublisherServer\mssql) is copied to a directory of your choice. This script can be modified according to your security guide lines.
You have installed Microsoft SQL Server under Microsoft Windows. Microsoft SQL Server is not included in the package. If you install or configure a database yourself, always follow the instructions provided by the respective manufacturer, or contact your local Software AG sales organization.
You have downloaded the latest version of the Microsoft SQL Server JDBC driver, for example, jTDS.jar or sqljdbc4-4.0.2206.100.jar from the Microsoft Download Center to a directory of your choice.
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.
Open the Microsoft SQL Console.
Open the Server properties dialog.
On the Security tab, select the SQL Server and Windows authentication mode option (mixed mode).
Create a database using the create_db.sql script.
Note the database name, user name, and password. You must enter these values later during the setup process.
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
Close the Microsoft SQL Console.
Start the ARIS Publisher Server installation as an administrator (DVD 2 folder Setups\Windows\ARIS_Publisher_Server).
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.
Select the installation directory.
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.
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.
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.
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.
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 (Redirect ports, Redirect ports) the standard port.
Enter the ARIS Administration user's name superuser and the corresponding password.
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.
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.
Select the Microsoft SQL Server as database system.
Select the required JDBC driver for the Microsoft SQL database management system.
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.
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.