Installation

warning

Analysis Server with Single Sign-On is not supported with Ingress setup.

Installing through the Windows Installer Interface

1. Right-click the openit_<version>_asee_windows_x64.msi installer file, then click Run as Administrator.

   Allow the app to make changes to the device to begin. A setup wizard will be displayed. Click Next.

   

   Welcome Screen

   
   

2. Read the License Agreement before accepting the terms. Click Next.

   

   End-user License Agreement

   
   

3. Specify where the Open iT software will be installed. Click Change to specify a different directory and click OK. Clicking Next without doing any changes will use the default installation path.

   Click Next.

   

   Destination Folder

   
   

4. Specify the TCP/IP port number. This option enables access to the Open iT Analysis Server web application. The default value, 80, may also be used.

   Specify the path to a valid Open iT Analysis Server license key. This location may be changed at a later time on the configuration page of the Open iT Analysis Server web interface.

   Click Next.

   

   Web Server TCP Port Number and License File

   
   

5. Skip this dialog to avoid connecting the installation to Ingress. Click Next.

   warning

   This dialog will not display if the machine you are installing the Analysis Server has Ingress installed.

   

   Ingress Instance URI

   
   

   Click Yes to continue the installation process.

   

   Ingress Warning

   
   

6. Specify the Service Account User Name and Password. The user name must include the Active Directory domain.

   Select Enable Single-Sign-On and click Next

   

   Service Account Credentials

   
   

7. Specify the Administrator Group. Click Next.

   warning

   The group should be an existing group in Azure Active Directory or an individual email address. This accepts a comma-separated list.

   

   User and Administrator Group

   
   

8. Specify the SQL Server Database and instance name where the SQL data warehouse will be created and deployed. Click Browse to look for available SQL Servers on the network.

   Specify the SQL Server Analysis Services database and instance name which will hold the reporting cube.

   Click Next.

   

   Database Servers

   
   

   If the installer detects that the SQL Server provided is an Azure SQL Server and/or the Tabular Server is an Azure Analysis Services, another dialog will appear.

   This will require you to provide the Azure SQL Server Login credentials pre-created in the server. This is required since the credentials will be used to connect to the server. Make sure that the user has a DBMANAGER server role.

   NOTE

   For further details in connecting to Azure SQL Server, please read the article Azure SQL Database Connection Configuration.

   Click Next.

   

   Server Login

   
   

9. Click Install to start the installation process. If you need to review the entries, click Back.

   

   Ready to Install

   
   

10. The installer will set up all necessary files on the computer.

    After the installation, the View Release Notes option will be automatically selected. This option will show a list of updates and fixes included on the installer through a web browser. Deselect this option as needed.

    Click Finish to complete the installation.

    

    Installation Complete

    
    

Installing through the Command Line

1. Open a command prompt with Administrator level privilege.

2. Execute the following command:

   Example

   msiexec /i <msi_file> /l*v <log_file> <options> LICENSEFILE=<license_file> RUNASUSER=<domain\user> RUNASPASSWORD=<password> ADMINGROUP=<admingroup_name> ENABLESSO=1

   Required Parameters:

   Parameter	Description
   /i <msi_file>	The path of the Windows installer file, openit_\<version\>_asee_windows_x64.msi.
   l*v <log_file>	The path of the installation log file that will be created during installation.

   Required Parameters
   
   

   Optional Parameters:

   NOTE

   The installer will use the Windows Installer Interface process when the installation option is not specified.

   Parameter	Description
   /quiet	Run the command in silent mode.
   /passive	Run the command in unattended mode - progress bar only.

   Optional Parameters
   
   

   Required Properties:

   Properties	Description
   LICENSEFILE=<license_file>	The path to the Open iT license file.
   RUNASUSER=<domain\user>	The username, including the Active Directory domain, used as the service account.
   RUNASPASSWORD=<password>	The password of the service account.
   ADMINGROUP=<admingroup_name>	The predefined user group with administrative rights.
   ENABLESSO=1	Triggers the installer to install with Single-Sign On enabled.

   Required Properties
   
   
   Example

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1
   
   

   Optional Properties:

   Use the optional properties to further customize the installation. The default values are used when not specified.

   INSTALLDIR=$INSTALL_DIR
   The path where the Open iT files will be installed. This value is set to C:\Program Files\OpeniT\Analysis Server by default.

   Example

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1 INSTALLDIR="C:\OpeniT\Analysis Server\"

   IISPORTNUMBER=<portnumber>
   The TCP/IP port number used by the reporter website. This is set to 80 by default.

   Example

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1 IISPORTNUMBER=8088

   SQLSERVER=<sqlserver\instance_name>
   The SQL Server including the instance name where the SQL database is created.

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1 SQLSERVER=DESKTOP123WIN\SQL2019

   SQLDATABASE=<database_name>
   The name of the SQL database.

   Example

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1 SQLDATABASE=OpeniT2022

   OLAPSERVER=<olapserver\instance_name>
   The OLAP (SQL Server Analysis Services) Server including the instance name where the OLAP database is created.

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1 OLAPSERVER=DESKTOP123WIN\SQL2019

   OLAPDATABASE=<database_name>
   The name of the OLAP database where the OLAP cubes are created.

   Example

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1 OLAPDATABASE=OpeniT2022

   Combine or use optional parameters at the same time to achieve necessary capabilities.

   Example

   msiexec /i C:\AS_installer\openit_10_2_500_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\admin RUNASPASSWORD=p@$$w0Rd ADMINGROUP=AS_Admins ENABLESSO=1 INSTALLDIR="C:\OpeniT\AnalysisServer\" IISPORTNUMBER=8088 SQLSERVER=DESKTOP123WIN\SQL2019 SQLDATABASE=OpeniT2022 OLAPSERVER=DESKTOP123WIN\SQL2019 OLAPDATABASE=OpeniT2022

3. When using the passive mode, wait until the process bar dialog disappears. When using the quiet mode, verify if the installation is complete by opening the Task Manager and checking in the Details tab if the msiexec process is still running.

Next Steps?

After an installation, it is recommended to run through all the Installation Verification to verify that the installation is successful.

Analysis Server Installation Verification