# Upgrading Analysis Server

Choose among the available upgrade scenarios that fit your setup:

# Without Ingress Setup

Use this guide if the Analysis Server to upgrade will only be standalone and no connection to Ingress will be made. Choose among the upgrade methods:

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.

Analysis Server Upgrade: Welcome Screen

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

Analysis Server Upgrade: End-user License Agreement

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.

Analysis Server Upgrade: Destination Folder

Skip this dialog since you are installing a standalone Analysis Server (without Ingress). Click Next.

Analysis Server Upgrade: Ingress Instance URI

Click Yes to continue the upgrade process.

Analysis Server Upgrade: Ingress Warning
Specify the new Service Account User Name and Password. The user name must include the Active Directory domain. Click Next.

Analysis Server Upgrade: Service Account Credentials

Specify the User Group and Administrator Group. The current value can also be left as-is.
Click Next.

Analysis Server Upgrade: User and Administrator Group

Specify the new 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. The current value can also be left as-is.

Specify the SQL Server Analysis Services database and instance name which will hold the reporting cube. The current value can also be left as-is.

Click Next.

Analysis Server Upgrade: Database Servers

If the installer detects that the SQL Server provided is an Azure SQL Server, 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.

For further details in connecting to Azure SQL Server, please read the article How to Connect to Azure SQL Server.

Click Next.

Analysis Server Installation: Server Login
Click Install to start the installation upgrade process. If a review of the entries is needed, click Back.

Analysis Server Upgrade: Ready to Install

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

After the installation, a link will be provided for users to access the Open iT Analysis Server Web application. The View Release Notes option can be selected. This option will show a list of updates and fixes included on the installer through a web browser. Deselect this option as needed.

You may experience a delay when viewing the release notes due to the registration process of Analysis Server with Ingress.

Click Finish to complete the installation.

Analysis Server Upgrade: Installation Complete

Continue reading to suggested next steps.

Open a command prompt with Administrator level privilege.

Execute the following command:

Example
 msiexec /i [msi_file] /l*v [log_file] [options] USEPREVSITE=1

Required Parameters:

Parameter	Description
/i [msi_file]	The path of the Windows installer file, `openit_[version]_asee_windows_x64.msi`.
*lv [log_file]**	The path of the installation log file that will be created during installation.

Installing through Command Line: Required Parameters

Optional Parameters:

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.

Installing through Command Line: Optional Parameters

Required Properties:

USEPREVSITE=1
A trigger that commands the installer to use the previous installation settings for creating an IIS website.

If not specified, this will create a new IIS website.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1

All other settings will use the previous values.

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_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins 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_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins IISPORTNUMBER=8088

RUNASUSER=[domain\user]
The username, including the Active Directory domain, used as the service account.

RUNASPASSWORD=[password]
The password of the service account.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 RUNASUSER=SVG\bob RUNASPASSWORD=p@$$W0Rd

ADMINGROUP=[group_name]
The predefined user group with administrative rights.

Make sure that the Administrators Group is an active dome user group.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 ADMINGROUP=AS_Administrators

REPORTERSGROUP=[group_name]
The predefined user group with reporting access.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 REPORTERSGROUP=AS_Reporters

LICENSEFILE=[license_file]
The path to the Open iT license file.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 LICENSEFILE=C:\license

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins SQLSERVER=OSL120WIN\SQL2019

SQLDATABASE=[database_name]
The name of the SQL database.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins SQLDATABASE=OpeniT2022

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins OLAPSERVER=OSL120WIN\SQL2019

OLAPDATABASE=[database_name]
The name of the OLAP database where the OLAP cubes are created.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins OLAPDATABASE=OpeniT2022

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins INSTALLDIR="C:\OpeniT\AnalysisServer\" IISPORTNUMBER=8088 SQLSERVER=OSL120WIN\SQL2019 SQLDATABASE=OpeniT2022 OLAPSERVER=OSL120WIN\SQL2019 OLAPDATABASE=OpeniT2022

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.

# With Ingress Setup

Use this guide if the Analysis Server to upgrade is planned to connect to an Ingress installation (local or remote).

For optimal integration of the Analysis Server with Ingress, facilitating a seamless global navigation experience across Open iT web interfaces, it is advisable to ensure the presence of Open iT Ingress and have the URI prepared. This preparation will pave the way for a streamlined transition to a configuration with Ingress, ensuring a smooth upgrade process. Use the instructions in Ingress Installation section if installing Ingress for the first time.

# Local Ingress Setup

Use this guide if Ingress is installed locally or in the same machine as the Analysis Server. This assumes that the Ingress is properly installed and is accessible. Choose among the upgrade methods:

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.

Analysis Server Upgrade: Welcome Screen

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

Analysis Server Upgrade: End-user License Agreement

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.

Analysis Server Upgrade: Destination Folder

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

Analysis Server Upgrade: Service Account Credentials

Specify the User Group and Administrator Group. The current value can also be left as-is.
Click Next.

Analysis Server Upgrade: User and Administrator Group

Specify the new 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. The current value can also be left as-is.

Specify the SQL Server Analysis Services database and instance name which will hold the reporting cube. The current value can also be left as-is.

Click Next.

Analysis Server Upgrade: Welcome Screen

If the installer detects that the SQL Server provided is an Azure SQL Server, 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.

For further details in connecting to Azure SQL Server, please read the article How to Connect to Azure SQL Server.

Click Next.

Analysis Server Installation: Server Login
Click Install to start the installation upgrade process. If a review of the entries is needed, click Back.

Analysis Server Upgrade: Ready to Install

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.

Analysis Server Upgrade: Installation Complete

Continue reading to suggested next steps.

Open a command prompt with Administrator level privilege.

Execute the following command:

Example
 msiexec /i [msi_file] /l*v [log_file] [options] USEPREVSITE=1

Required Parameters:

Parameter	Description
/i [msi_file]	The path of the Windows installer file, `openit_[version]_asee_windows_x64.msi`.
*lv [log_file]**	The path of the installation log file that will be created during installation.

Installing through Command Line: Required Parameters

Optional Parameters:

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.

Installing through Command Line: Optional Parameters

Required Properties:

USEPREVSITE=1
A trigger that commands the installer to use the previous installation settings for creating an IIS website.

If not specified, this will create a new IIS website.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1

All other settings will use the previous values.

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_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins 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_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins IISPORTNUMBER=8088

RUNASUSER=[domain\user]
The username, including the Active Directory domain, used as the service account.

RUNASPASSWORD=[password]
The password of the service account.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 RUNASUSER=SVG\bob RUNASPASSWORD=p@$$W0Rd

ADMINGROUP=[group_name]
The predefined user group with administrative rights.

Make sure that the Administrators Group is an active dome user group.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 ADMINGROUP=AS_Administrators

REPORTERSGROUP=[group_name]
The predefined user group with reporting access.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 REPORTERSGROUP=AS_Reporters

LICENSEFILE=[license_file]
The path to the Open iT license file.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 LICENSEFILE=C:\license

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins SQLSERVER=OSL120WIN\SQL2019

SQLDATABASE=[database_name]
The name of the SQL database.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins SQLDATABASE=OpeniT2022

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins OLAPSERVER=OSL120WIN\SQL2019

OLAPDATABASE=[database_name]
The name of the OLAP database where the OLAP cubes are created.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins OLAPDATABASE=OpeniT2022

INGRESSURI=[http(s)://hostname:<port_number>]
The valid URI of Ingress installation to connect. Please make sure to use the correct protocol, hostname, and port number to avoid errors in connection. If not specified, the value will be the set to the local Ingress installation.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins INGRESSURI=http://osl120win:8080/

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins INSTALLDIR="C:\OpeniT\AnalysisServer\" IISPORTNUMBER=8088 SQLSERVER=OSL120WIN\SQL2019 SQLDATABASE=OpeniT2022 OLAPSERVER=OSL120WIN\SQL2019 OLAPDATABASE=OpeniT2022

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.

# Remote Ingress Setup

Use this guide if the Ingress is installed remotely or on a different machine as Analysis Server. This assumes that the Ingress installation is up and running, and the URI is ready.

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.

Analysis Server Upgrade: Welcome Screen

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

Analysis Server Upgrade: End-user License Agreement

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.

Analysis Server Upgrade: Destination Folder

Specify the remote Ingress URI to be utilized by the Analysis Server. This will trigger the Analysis Server to establish a connection with Ingress and access the Open iT web application. The default value is http://localhost:27983. Proceed by clicking Next.

Analysis Server Upgrade: Ingress Instance URI

If Ingress is not accessible or installed yet, a pop-up warning will appear. Please make sure that Ingress is installed in the remote machine and accessible. If it persists, skip by clicking Yes to continue with the upgrade process.

Analysis Server Installation: Ingress Warning
Specify the new Service Account User Name and the Password. The user name must include the Active Directory domain. Click Next.

Analysis Server Upgrade: Service Account Credentials

Specify the User Group and Administrator Group. The current value can also be left as-is.
Click Next.

Analysis Server Upgrade: User and Administrator Group

Specify the new 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. The current value can also be left as-is.

Specify the SQL Server Analysis Services database and instance name which will hold the reporting cube. The current value can also be left as-is.

Click Next.

Analysis Server Upgrade: Welcome Screen

If the installer detects that the SQL Server provided is an Azure SQL Server, 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.

For further details in connecting to Azure SQL Server, please read the article How to Connect to Azure SQL Server.

Click Next.

Analysis Server Installation: Server Login
Click Install to start the installation upgrade process. If a review of the entries is needed, click Back.

Analysis Server Upgrade: Ready to Install

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.

Analysis Server Upgrade: Installation Complete

Continue reading if upgrading through command line is necessary. If not, here are some suggested next steps.

Open a command prompt with Administrator level privilege.

Execute the following command:

Example
 msiexec /i [msi_file] /l*v [log_file] [options] USEPREVSITE=1

Required Parameters:

Parameter	Description
/i [msi_file]	The path of the Windows installer file, `openit_[version]_asee_windows_x64.msi`.
*lv [log_file]**	The path of the installation log file that will be created during installation.

Installing through Command Line: Required Parameters

Optional Parameters:

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.

Installing through Command Line: Optional Parameters

Required Properties:

USEPREVSITE=1
A trigger that commands the installer to use the previous installation settings for creating an IIS website.

If not specified, this will create a new IIS website.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1

All other settings will use the previous values.

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_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins 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_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins IISPORTNUMBER=8088

RUNASUSER=[domain\user]
The username, including the Active Directory domain, used as the service account.

RUNASPASSWORD=[password]
The password of the service account.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 RUNASUSER=SVG\bob RUNASPASSWORD=p@$$W0Rd

ADMINGROUP=[group_name]
The predefined user group with administrative rights.

Make sure that the Administrators Group is an active dome user group.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 ADMINGROUP=AS_Administrators

REPORTERSGROUP=[group_name]
The predefined user group with reporting access.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 REPORTERSGROUP=AS_Reporters

LICENSEFILE=[license_file]
The path to the Open iT license file.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet USEPREVSITE=1 LICENSEFILE=C:\license

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins SQLSERVER=OSL120WIN\SQL2019

SQLDATABASE=[database_name]
The name of the SQL database.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins SQLDATABASE=OpeniT2022

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

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins OLAPSERVER=OSL120WIN\SQL2019

OLAPDATABASE=[database_name]
The name of the OLAP database where the OLAP cubes are created.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins OLAPDATABASE=OpeniT2022

INGRESSURI=[http(s)://hostname:<port_number>]
The valid URI of Ingress (remote) installation to connect. Please make sure to use the correct protocol, hostname, and port number to avoid errors in connection. If not specified, the upgrade will not be connected to Ingress.

Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins INGRESSURI=http://osl120win:8080/


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

 ```Example
 msiexec /i C:\AS_installer\openit_10_0_0_asee_windows_x64.msi /l*v C:\AS_install_logs\AS_logs.txt /quiet LICENSEFILE=C:\AS_license\license RUNASUSER=SVG\bob RUNASPASSWORD=p@$$w0Rd REPORTERSGROUP=AS_Reporters ADMINGROUP=AS_Admins INSTALLDIR="C:\OpeniT\AnalysisServer\" IISPORTNUMBER=8088 SQLSERVER=OSL120WIN\SQL2019 SQLDATABASE=OpeniT2022 OLAPSERVER=OSL120WIN\SQL2019 OLAPDATABASE=OpeniT2022

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 upgrade, please accomplish all the post-upgrade procedures.

Analysis Server Post-Upgrade Procedures