Installing TrueSight Operations Management Report Engine with Microsoft SQL Server

This section provides information about installing BMC TrueSight Operations Management Report Engine with Microsoft SQL Server as Reporting Engine database. You can install BMC TrueSight Operations Management Report Engine on a computer different from the one on which SAP BusinessObjects Enterprise is installed.

This topic includes information for:

• • Before you begin
  • To disable the encryption switch before installing the Report Engine to support TLS
  • To install BMC TrueSight Operations Management Report Engine on the first computer
  • To install BMC TrueSight Operations Management Report Engine on the second or subsequent computers
  • To install BMC TrueSight Operations Management Report Engines using single database and two SQL Server users with different authentication modes

Before you begin

Before installing the Report Engine, ensure that:

• You are logged in as an administrator (Windows) or a root user (Linux) on the host on which you are installing.
• You have installed BMC TrueSight Infrastructure Management Server and the Microsoft SQL Server on different computers.
• You have access to the installation files.
• You have created an SQL Server database and a user.
• If you are installing more than one Report Engine, ensure that you install the Report Engines one after another instead of installing them simultaneously.
• By default, the Report Engine is installed with AES 256-bit encryption key size. If you want to set this to 128-bit encryption key size, set the following environment variable before installing the Report Engine to: 
  AES_ENCRYPTION_KEY_SIZE=128

• If you are installing on an IPv6 Windows host, ensure that the IP helper service started. 

  Note

   Installing SAP BusinessObjects on UNIX operating systems and using SQL Server as Reporting Engine database is not supported.

• Post the TrueSight Report Engine installation, if you want to configure the Report Engine to enable TLS, ensure that you explicitly disable the encryption switch before installing the Report Engine. For more information about how to disable the encryption switch, see To disable the encryption switch before installing the Report Engine to support TLS.

To disable the encryption switch before installing the Report Engine to support TLS

Before the Report Engine installation, if you want to configure the Report Engine to enable TLS mode, ensure that you disable the encryption switch before you proceed with the TrueSight Report Engine installation. Perform the following sequence of steps to disable the encryption switch. 

1. Login to the computer where the Microsoft SQL Server is installed.
2. Open the SQL Server Configuration Manager.
3. Navigate to the SQL Server Network Configuration > Protocols for <SQL Instance> directory location.
4. Right-click the Protocols for <SQL Instance> and select Properties.
   Properties dialogue box is opened.
5. Click the Flags tab, and set the Force Encryption Flag value to No.
6. Restart the SQL server instance.
7. Install the TrueSight Report Engine as explained in the following sections.
8. Ensure that you set the Force Encryption Flag value to Yes once the Report Engine installation is completed.

To install BMC TrueSight Operations Management Report Engine on the first computer

1. Navigate to the Reports/ReportEngine/platform folder, where the platform is Windows or Linux.
   
   

   Note

   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 which has enough space.

   • For Windows, double-click ReportEngine10.7.00_buildnumber.exe.

   • For Linux, at the command line, run the following command: ReportEngine10.7.00_buildnumber.bin

     Note

     For Windows and Linux installations, the installation file supports only the graphical user interface (GUI) mode, not the console or silent mode.

2. In the Welcome page, click Next.
3. In the License Agreement page, click I agree to the terms of the license agreement

4. In the Feature Selection page, select the appropriate features that you want to install.
   Selecting the BMC TrueSight Operations Management Report Engine Installation check box selects both the Install BMC TrueSight Operations Management Report Engine 10.7.00 and Import universe and reports 10.7.00 check boxes.

   Note

   When you select the Import universe and reports check box, it imports the BMC TrueSight Infrastructure Management universe and reports into the SAP BusinessObjects Enterprise automatically. It eliminates the manual process of importing them into SAP BusinessObjects Enterprise. If you are installing BMC TrueSight Operations Management Report Engine for the first time, BMC recommends you to import the universe and reports automatically.

5. In the Database Selection page, select SQL Server Standard Edition or SQL Server Enterprise Edition and provide the necessary information using the values that you populated in the Planning sheet for installation and configuration, and click Next.
6. In the BMC TrueSight Operations Management Report Engine Database screen, enter the following information:
   • Fully-Qualified Database Host Name: SQL Server database host
   • Port: SQL Server instance port number (by default, the port number is 1433)
   • Instance Name: SQL Server instance name (by default, the instance name is MSSQLSERVER), 
   • Database Name: SQL Server database name
   • Select Authentication mode as SQL Server or Windows.
     • If you have selected SQL Server, enter the following information:
       • Database Login: the login name for the SQL Server database you have created.
       • Database Password: password for the SQL Server database you have created.
       • Confirm Database Password: password for the SQL Server database you have created.

     •  If you have selected Windows, enter the following information:

       • Windows Domain: the Windows domain name.

       • Database Login: the login name for the SQL Server database you have created.
       • Database Password: password for the SQL Server database you have created.
       • Confirm Database Password: password for the SQL Server database you have created.
7. Click Next.
8. In the Time Zone Selection page, select an appropriate time zone, and click Next.
9. In the Directory Selection page, accept the default directory or select a different directory to install BMC TrueSight Operations Management Report Engine, and click Next.
10. In the BMC Truesight Infrastructure Management Server Details page, enter the following information:
    
    • Enter Details for Host Name: the BMC TrueSight Infrastructure Management Server name
    • Protocol: Select the network protocol that the TSIM uses (default protocol: HTTP)
    • HTTP/S Port: TSIM port (default port: 443)
    • Username: BMC TrueSight Infrastructure Management Server user name
    • Password: BMC TrueSight Infrastructure Management Server password
11. In the BMC TrueSight Infrastructure Management Server Registration page:
    • If the BMC TrueSight Infrastructure Management Server connects to an Oracle database, review all of the data that was automatically entered and make any necessary changes. Then, enter the password for the database user.
    • If the BMC TrueSight Infrastructure Management Server connects to a Sybase database, review all of the data that was automatically entered and make any necessary changes. The database user password is the default password. You can enter a new password if it is different than the default.

    • If you are working with a BMC TrueSight Infrastructure Management Server that is earlier than v10.7, complete the Registration page fields.

      Click here for instructions to complete the Registeration page fields......

      • BMC TrueSight Infrastructure Management Server name: Enter the name of the BMC TrueSight Infrastructure Management Server.

      • BMC TrueSight Infrastructure Management Server cell name: Enter the name of the BMC TrueSight Infrastructure Management Server cell.

        Note

        Provide the cell name of the same BMC TrueSight Infrastructure Management Server which you want to register.

      • Select the BMC TrueSight Infrastructure Management Server database type:
        • Sybase
        • Oracle
        • Oracle RAC
      • Fully qualified BMC TrueSight Infrastructure Management Server database host name: Enter a fully-qualified database host name.
      • BMC TrueSight Infrastructure Management database port: Enter a database port. The default Sybase port number is 2638.
      • Database login: Enter the BMC TrueSight Infrastructure Management database user name. The default Sybase username is dba.
      • Database password: Enter the password for the BMC TrueSight Infrastructure Management database user.

      
      

      Note

      By default, the Enable Event and Impact reporting option is selected, which means that the report engine installation automatically registers event gateway and cell information with the BMC TrueSight Infrastructure Management server. If this option is not selected, the event gateway and cell information is not automatically registered.

12. In the BusinessObjects Information page, provide the necessary information using the values that you entered in the Planning sheet for installation and configuration, and click Next.

    Note

    If you deselected the Import Universe and Reports checkbox on the Feature Selection page, the BusinessObjects Information page is not displayed. Post-installation, you can import the TrueSight_DataMart.lcmbiar universe file manually using the steps described in Manually importing the BMC TrueSight Operations Management universe and reports into supported SAP BusinessObjects.

13. In the Installation Preview page, click Install.
    
    

    Note

    For BMC TrueSight Operations Management Report Engine 10.7.00, the cell_name slot is mandatory. So, if you have BMC Impact Manager version earlier than 9.5.00, ensure to add the following entries in the %MCELL_HOME%\etc\gateway.reportengine file prior or next to the existing slots listing and restart BMC Impact Manager before proceeding with the installation:

    add.new=[cell_name=$CNAME]

    add.mod=[cell_name=$CNAME]

    The installer begins the installation process. 

14. Click Done.
15. Apply the Hotfix_1070000010 hotfix.
    This is a mandatory hotfix, which resolves the issue where information about daylight saving information for the period after 31 December 2019 is not present in the Report Engine database.
    For more information, see Adding-daylight-saving-information-in-the-Reporting-database.

To install BMC TrueSight Operations Management Report Engine on the second or subsequent computers

If you want to install BMC TrueSight Operations Management Report Engine on second or subsequent computers, you must perform the following steps. You can also install Report Engine on another host if you have upgraded the Report Engine from any previous version (9.5.02 or 9.6.00) to 10.7.00.

If another Report Engine is running using the same SQL database with encryption enabled,

1. To install the Report Engine, run the file located in the Reports/ReportEngine/platform folder, relevant to the operating system.
   • For Windows, double-click ReportEngine10.7.00_buildnumber.exe.
   • For Linux, at the command line, run the following command: ReportEngine10.7.00_buildnumber.bin
2. Follow the instructions on the wizard pages. You need to enter the following information:
   
   • Installing the Report Engine and importing the latest universe and reports.

   • Database connection information such as the database computer name, default port number 1433, and account details of the user that you created at Creating-database-and-user-on-SQL-Server.

     Note

     The Time Zone selection page is not displayed when you install the second (or multiple instances of) Report Engine.

   • The directory in which you want to install the product.

   • BMC TrueSight Infrastructure Management Server registration details. You can register BMC TrueSight Infrastructure Management Server version 10.0.
     
     

     Note

     You must register a different BMC TrueSight Infrastructure Management Server and not the one you have registered for the first or previous BMC TrueSight Operations Management Report Engine.

   • Details of the server in which BMC Reporting Foundation is installed, and the SAP BusinessObjects user who has administrator rights (if you select the Import universe and reports 10.0.00 check box)
3. In the Installation Preview page, click Install. The installer begins the installation process. 
4. Click Done.

To install BMC TrueSight Operations Management Report Engines using single database and two SQL Server users with different authentication modes

In BMC TrueSight Operations Management Reporting 10.0.00, you can install two Report Engines by creating two SQL Server users with different authentication modes. Perform the following steps to create the SQL Server users and install Report Engines:

1. Create SQL Server user in Active Directory. 
2. Run the create_sql_user.bat script. When the script displays the message Enter the type of login you want to create, select Windows Authentication. For more information, see Creating-database-and-user-on-SQL-Server.
3. Install first BMC TrueSight Operations Management Report Engine. When prompted for authentication, select Windows Authentication. For more information, see To install BMC TrueSight Operations Management Report Engine on the first computer.
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 execute the create_secondary_sql_server_user.sql script to create another SQL Server user with different Login Name and Password.

   sqlcmd -S <database host name> -i create_secondary_sql_server_user.sql
6. Install second BMC TrueSight Operations Management Report Engine on a different computer by using the login credentials created using the create_secondary_sql_server_user.sql script. When prompted for authentication, select SQL Server authentication. For more information, see To install BMC TrueSight Operations Management Report Engine on the second or subsequent computers.