Installing Report Engine with SQL Server
Where you are in the Installation process:
| Step | Task |
|---|---|
| 1 | Complete the planning activities. |
| 2 | Prepare for TrueSight Smart Reporting installation. |
| 3 | Install TrueSight Smart Reporting. |
| 4 | Install the Truesight Operations Management Report Engine. (You are here) |
| 5 | Complete the post-installation activity. |
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
Log in as an administrator (Windows) or a root user (Linux) to the computer where you have downloaded the Report Engine installation files.
Note
On 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.
(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- (Optional) If you are installing on an IPv6 Windows host, ensure that the IP helper service has started.
- (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 - Extract the downloaded files to your temporary directory.
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.binNotes
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
IATEMPDIRenvironment 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.
- 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. - Select one of the following database, and click Next:
- SQL Server Standard Edition
- SQL Server Enterprise Edition
- 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
- Select the time zone of the computer where you are installing the Report Engine, and click Next.
- Specify the directory for the Report Engine installation, and click Next.
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.
- The host name, protocol, and port number of the TrueSight Infrastructure Management Server.
- 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
. 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.
If you have selected to install the Report Engine, do the following:
- Select one of the following databases, and click Next:
- SQL Server Standard Edition
- SQL Server Enterprise Edition
- 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
- Select the time zone of the computer where you are installing the Report Engine, and click Next.
- Specify the directory for the Report Engine installation, and click Next.
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.
- The host name, protocol, and port number of the TrueSight Infrastructure Management Server.
- 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.
- Select one of the following databases, and click Next:
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
If required, configure the Report Engine to enable the TLS mode.
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:
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.
Navigate to the Reports/ReportEngine/platform folder, where platform is Linux or Windows.
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
- 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
In the Installation Preview page, click Install. The installer begins the installation process.
Click Done to exit the installation wizard.
- If required, configure the Report Engine to enable the TLS mode.
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:
Create an SQL Server user in Active Directory.
- Run the
create_sql_user.batscript. - When the script displays the Enter the type of login you want to create message, select Windows Authentication.
- Edit the
create_secondary_sql_server_user.sqlscript with the correct values for the following:DATABASE_NAMEDATABASE_SECOND_LOGIN_NAMEDATABASE_SECOND_LOGIN_PASSWORDDATABASE_SECOND_USER_NAME
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- When the script displays the message Enter the type of login you want to create message, select SQL Server Authentication.
- Do the following to install the second Report Engine on a different computer:
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.
Navigate to the Reports/ReportEngine/platform folder, where platform is Linux or Windows.
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
- 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
In the Installation Preview page, click Install. The installer begins the installation process.
Click Done to exit the installation reward.
If required, configure the Report Engine to enable the TLS mode.
Comments
What are the supported versions of SQL server for smart reporting? please provide the documentation, if any.
Hello Harish,
The following versions of SQL Server are supported:
SQL Server 2012, SQL Server 2014, SQL Server 2016 Enterprise Edition with Partitioning and Standard Edition
This information is captured here:
System requirements and compatibility information
Please let me know if you need more information.
Hello,
regarding point 2 of the insallation: (Optional) If you want to change the default AES encryption size of the Report Engine to 128-bit,.. What is the default AES encryption size?
Cheers
Log in or register to comment.