Installing Report Engine with SQL Server

Where you are in the Installation process:

This section provides installation information for TrueSight Operations Management Report Engine with Microsoft SQL Server as the Reporting database.

You can install single or multiple Report Engines based on your requirements. If you are installing multiple Report Engines, you can:

  • Install multiple Report Engines on the same database with the same database user
  • Install multiple Report Engines on the same database with different users that use different authentication modes

While installing multiple Report Engines, install them one after another, and not simultaneously.

To install Report Engine on a single computer

  1. Log in as an administrator (Windows) or a root user (Linux) to the computer where you have downloaded the Report Engine installation files.
    NoteOn Linux, ensure that you have installed the nss-softokn-freebl-3.12.9-11.el6.i686 & glibc-2.12-1.47.el6.i686.rpm package.
  2. (Optional) If you want to change the default AES encryption size of the Report Engine to 128-bit, set the following environment variable:AES_ENCRYPTION_KEY_SIZE=128
  3. (Optional) If you are installing on an IPv6 Windows host, ensure that the IP helper service has started.
  4. (Linux) Set the following environment variable to ensure that the wizard-based installer launches the screens appropriately:
    export DISPLAY=<IP address of the host computer>:0.0
  5. Extract the downloaded files to your temporary directory.
  6. Navigate to the Reports/ReportEngine/platform folder, where platform is Linux or Windows.
    • For Windows, double-click ReportEngine<version>_buildnumber.exe.
    • For Linux, at the command line, run the following command:
      ReportEngine11.3.01_b.bin
      Notes
      • If there is not enough space in the temporary directory, the system prompts you to select an alternate directory. On UNIX-based computers, you can set the IATEMPDIR environment variable to an alternate directory that has enough space.
      • For Linux installations, the installation file supports only the graphical user interface (GUI) mode. There is no support for the console or silent mode installation methods.
  7. Select TrueSight Operations Management Report Engine Installation, and click Next.
    Selecting this option installs the Report Engine and configures the TrueSight Smart Reporting details on the Report Engine.
  8. Select one of the following database, and click Next:
    • SQL Server Standard Edition
    • SQL Server Enterprise Edition
  9. Add or select the following database details:
    • The fully-qualified database host name of the SQL database
    • The port number, instance name, and the database name
    • An authentication mode for the SQL database
    • The database login and password for the SQL database
  10. Select the time zone of the computer where you are installing the Report Engine, and click Next.
  11. Specify the directory for the Report Engine installation, and click Next.
  12. Enter the following TrueSight Infrastructure Management Server details, and click Next:
    • The host name, protocol, and port number of the TrueSight Infrastructure Management Server. 
      The default protocol is HTTPS.
      The default port is 443.
    • The user name and password for the TrueSight Infrastructure Management Server user.
      The user must have Super Admin privileges.

  13. Review the details, select Enable Event and Impact reporting option, and click Next.
    If you do not select this option, you must configure the TrueSight Infrastructure Management cells for event and impact reporting by configuring TrueSight Infrastructure Management cells.

  14. On the Feature Selection page, select the task that you want to perform, and click Next.
    • Install TrueSight Operations Management Report Engine
    • Configure TrueSight Smart Reporting. Selecting this option configures TrueSight Smart Reporting with the Report Engine details.
      If you do not want to configure TrueSight Smart Reporting at this time, clear the Configure TrueSight Smart Reporting check box. You can configure it any time after the installation by running the Report Engine installer again.
  15. If you have selected to install the Report Engine, do the following:
    1. Select one of the following databases, and click Next:
      • SQL Server Standard Edition
      • SQL Server Enterprise Edition
    2. Add or select the following database details:
      • The fully-qualified database host name of the SQL database
      • The port number, instance name, and the database name
      • An authentication mode for the SQL database
      • The database login and password for the SQL database
    3. Select the time zone of the computer where you are installing the Report Engine, and click Next.
    4. Specify the directory for the Report Engine installation, and click Next.
    5. Enter the following TrueSight Infrastructure Management Server details, and click Next:
      • The host name, protocol, and port number of the TrueSight Infrastructure Management Server. 
        The default protocol is HTTPS.
        The default port is 443.
      • The user name and password for the TrueSight Infrastructure Management Server user. The user must have Super Admin privileges.
    6. Review the details, select Enable Event and Impact reporting option, and click Next.
      If you do not select this option, you must configure the TrueSight Infrastructure Management cells for event and impact reporting by configuring TrueSight Infrastructure Management cells.
  16. If you have selected to configure TrueSight Smart Reporting, provide the following details, and click Next:
    • TrueSight Smart Reporting server name and port number
    • TrueSight Smart Reporting administrator name and password

  17. If required, configure the Report Engine to enable the TLS mode.

    Click here to know how to enable the TLS mode.
    1. Log in to the computer where the Microsoft SQL Server is installed.
    2. Open the SQL Server Configuration Manager.
    3. Navigate to SQL Server Network Configuration > Protocols for <SQL Instance>.
    4. Right-click Protocols for <SQL Instance> and select Properties. The Properties dialogue box is opened.
    5. Click the Flags tab, and set the Force Encryption Flag value to Yes.
    6. Restart the SQL server instance.

To install Report Engine on subsequent computers

You can install multiple Report Engines on the same database. Multiple Report Engines use the same database, filegroup, and database user that you created for the first Report Engine. While installing multiple Report Engines on the same database, you can do one of the following:

  • Install multiple Report Engines on the same database with the same database user.
  • Install multiple Report Engines on the same database with different users that use different authentication modes.

While installing multiple Report Engines, install them one after another, and not simultaneously.

Installing multiple Report Engines on the same database with the same database user

To install multiple Report Engines, do the following for each Report Engine one by one:

  1. If the earlier Report Engine is running on the same SQL database with the encryption enabled, disable the encryption switch before installing the subsequent Report Engine.

    Do the following to disable the encryption switch.
    1. Log in to the computer where the Microsoft SQL Server is installed.
    2. Open the SQL Server Configuration Manager.
    3. Navigate to SQL Server Network Configuration > Protocols for <SQL Instance>.
    4. Right-click Protocols for <SQL Instance> and select Properties. The Properties dialogue box opens.
    5. Click the Flags tab, and set the Force Encryption Flag value to No.
    6. Restart the SQL server instance..
  2. Navigate to the Reports/ReportEngine/platform folder, where platform is Linux or Windows.
  3. Perform one of the following tasks depending on your operating system:
    • For Windows, double-click ReportEngine11.3.01_buildnumber.exe.
    • For Linux, at the command line, run the following command
      ReportEngine11.3.01_buildnumber.bin
  4. Follow the instructions on the the installation wizard. When prompted, enter the following information:
    • Database connection information such as the database computer name, default port number 1433, and account details of the database user that you used for the first Report Engine.
    • The directory where you want to install the product.

    • TrueSight Infrastructure Management Server registration details.

      Note

      Use a different TrueSight Infrastructure Management than the one that you registered for the earlier Report Engine installation.

    • TrueSight Smart Reporting server details
  5. In the Installation Preview page, click Install. The installer begins the installation process. 
  6. Click Done to exit the installation wizard.
  7. If required, configure the Report Engine to enable the TLS mode.
Do the following to enable the TLS mode.

    1. Log in to the computer where the Microsoft SQL Server is installed.
    2. Open the SQL Server Configuration Manager.
    3. Navigate to SQL Server Network Configuration > Protocols for <SQL Instance>.
    4. Right-click Protocols for <SQL Instance> and select Properties. The Properties dialogue box opens.
    5. Click the Flags tab, and set the Force Encryption Flag value to Yes.
    6. Restart the SQL server instance.

Installing multiple Report Engines on the same database with different database users and authentication modes

You can install two Report Engines by creating two SQL Server users with different authentication modes.

Do the following:

  1. Create an SQL Server user in Active Directory. 
  2. Run the create_sql_user.bat script.
  3. When the script displays the Enter the type of login you want to create message, select Windows Authentication.
  4. Edit the create_secondary_sql_server_user.sql script with the correct values for the following:
    • DATABASE_NAME
    • DATABASE_SECOND_LOGIN_NAME
    • DATABASE_SECOND_LOGIN_PASSWORD
    • DATABASE_SECOND_USER_NAME

  5. At the command prompt, navigate to \Reports\Util\DatabaseScripts\sqlserver, and run the following command to create another SQL Server user with a different login name and password:

    sqlcmd -S <database host name> -i create_secondary_sql_server_user.sql
  6. When the script displays the message Enter the type of login you want to create message, select SQL Server Authentication.
  7. Do the following to install the second Report Engine on a different computer:

    1. If the earlier Report Engine is running on the same SQL database with the encryption enabled, disable the encryption switch before installing the Report Engine to support TLS.

      Do the following to disable the encryption switch.
      1. Log in to the computer where the Microsoft SQL Server is installed.
      2. Open the SQL Server Configuration Manager.
      3. Navigate to SQL Server Network Configuration > Protocols for <SQL Instance>.
      4. Right-click Protocols for <SQL Instance> and select Properties. The Properties dialogue box opens.
      5. Click the Flags tab, and set the Force Encryption Flag value to No.
      6. Restart the SQL server instance..
    2. Navigate to the Reports/ReportEngine/platform folder, where platform is Linux or Windows.
    3. Do one of the following, depending on your operating system:
      • For Windows, double-click ReportEngine<version>_buildnumber.exe.
      • For Linux, at the command line, run the following command: ReportEngine<version>_buildnumber.bin
    4. Follow the instructions on the the installation wizard. When prompted, enter the following information:
      • Database connection information, such as the database computer name, default port number 1433, and account details of the database user that you created in step 5.
        If the user authentication mode in the earlier installation of the Report Engine is Windows Authentication, select SQL Server Authentication. Else, select Windows Authentication.
      • The directory where you want to install the product.

      • TrueSight Infrastructure Management Server registration details.

        Note

        Use a different TrueSight Infrastructure Management than the one that you registered for the earlier Report Engine installation.

      • TrueSight Smart Reporting server details
    5. In the Installation Preview page, click Install. The installer begins the installation process. 
    6. Click Done to exit the installation reward.

    7. If required, configure the Report Engine to enable the TLS mode.

      Do the following to enable the TLS mode.
      1. Log in to the computer where the Microsoft SQL Server is installed.
      2. Open the SQL Server Configuration Manager.
      3. Navigate to SQL Server Network Configuration > Protocols for <SQL Instance>.
      4. Right-click Protocols for <SQL Instance> and select Properties. The Properties dialogue box opens.
      5. Click the Flags tab, and set the Force Encryption Flag value to Yes.
      6. Restart the SQL server instance.

Next step in the Installation process

Add TrueSight Smart Reporting as a component in TrueSight Presentation Server.