Installing BMC 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.

Before you begin

Before installing the Report Engine, ensure that:

• You are logged in as an administrator (Windows) or a root user (Linux/Solaris) 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.
• If you are installing on an IPv6 Windows host, ensure that the IP helper service is started.

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

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

   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.0.00_bbuildnumber.exe.
   • For Solaris, at the command line, run the following command: ReportEngine10.0.00_bbuildnumber.bin

   • For Linux, at the command line, run the following command: ReportEngine10.0.00_bbuildnumber.bin

     Note

     For Windows, Solaris 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. If you have created SQL Server database user using SQL authentication, select Authentication mode as SQL Server and if you have created SQL Server database user using Windows authentication, select Authentication mode as Windows.

5. 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.0.00 and Import universe and reports 10.0.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.

6. 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.
7. 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.
8. Click Next.
9. In the Time Zone Selection page, select an appropriate time zone, and click Next.
10. 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.
11. In the BMC TrueSight Infrastructure Management Server Registration page, enter the following information:

    • BMC TrueSight Infrastructure Management Server name — enter the name of the BMC TrueSight Infrastructure Management Server.

      Best Practice

      On the BMC TrueSight Infrastructure Management Server Registration page of Report Engine installation wizard, ensure that the entry for BMC TrueSight Infrastructure Management Server name is BMC TrueSight Infrastructure Management Server logical name. This logical name is the value of the NGP_Server_Name property in the BMCTrueSightIMServerInstallDir\pw\custom\conf\pronet.conf file. You must add the exact value of the NGP_Server_Name property to join performance and event data.

    • 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. Default for Sybase is 2638.
    • Database login—enter the BMC TrueSight Infrastructure Management database user name. The default Sybase user name is dba.
    • Database password—enter the password for the BMC TrueSight Infrastructure Management database user.

    • Confirm database password—reenter the password.

      Note

      If you are installing a second BMC TrueSight Operations Management Report Engine instance, use the same database created for the first Report Engine instance.

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

    Note

    If you have 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 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.0.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.
    

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.0.00.

1. To install the Report Engine, run the file located in the Reports/ReportEngine/platform folder, relevant to the operating system.
   • (Windows) Run the ReportEngine10.0.00_bbuildNumber.exe file
   • (Solaris) Run the sh ReportEngine10.0.00_bbuildNumber.bin command
   • (Linux) Run the ReportEngine10.0.00_bbuildNumber.bin command
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.

   • 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 When the script displays Enter the type of login you want to create message, 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.