Installation and Upgrade > Installation and Configuration Guide > Using the PTC Solution Installer > Installing Windchill Solutions > Optional Product Settings > Windchill Business Reporting > Distributed Installation - Two Machines
  
Distributed Installation - Two Machines
In a two machine distributed installation scenario, the Windchill Business Reporting host components are installed on a separate machine from the gateway server and your Windchill solution. The PSI is run twice, in the following order:
1. Installing the PTC Windchill Business Reporting Host Components
2. Installing the Gateway Server and Windchill Solution
Installing the PTC Windchill Business Reporting Host Components
From the list of solutions to install, select the Standalone Product or Component checkbox.
Select from the following standalone product or component options:
* 
If you leave both the Oracle Configuration and SQL Server Configuration deselected, it is assumed that a database and associated user already exist, and that you will supply that information in the database information screen.
Option
Default
Description
Oracle Configuration
Deselected
Select this option if you are configuring an Oracle database as part of this installation scenario. Under this option, select the following as appropriate:
• Create Database - selected by default.
* 
When creating an Oracle database using PSI, you can launch PSI as the user that installed the database software, or as root user.
• Create PTC Windchill Database User Account - selected by default.
• Create Windchill Business Reporting Database User Account - selected by default. Select this checkbox to create a new database user. To use an existing database user, deselect the checkbox.
SQL Server Configuration
Deselected
Select this option if you are configuring a SQL Server database as part of this installation scenario. Under this option, select the following as appropriate:
• selected by default.
• Create Windchill Business Reporting Database and User - deselected by default. Select this checkbox to create a new database and user. To use an existing database and user, leave deselected.
Windchill Business Reporting
Deselected
Select this option to install the Windchill Business Reporting components. Under this option, select as follows:
• Install the Host Components - Select this option to install the host. Select from the following as appropriate for your installation; you must select one:
Configure SQL Server Database
◦ Configure SQL Server Cluster Database
• Install the Gateway Server - Deselect this option.
Enter the following installation directory information:
Option
Default
Description
Installation Directory for PTC Windchill Business Reporting
<base installation directory>\Reporting
The location where the host components are installed.
* 
Installation Directory for PTC Windchill Business Reporting should be empty else Cognos installation fails.
Enter the following database information. If you selected the Create Windchill Business Reporting Database User Account or Create Windchill Business Reporting Database and User checkbox previously on the standalone product or component options screen, then the values entered in these fields are used to create the user. Otherwise, enter the values for an existing database user.
Options
Description
Windchill Business Reporting Oracle Database User Name for the Database User Account
or
Windchill Business Reporting SQL Server Database User Name for the Database User Account
The user name for the Windchill Business Reporting database user.
Windchill Business Reporting Oracle Database Password for the Database User Account
or
Windchill Business Reporting SQL Server Database User Password for the Database User Account
The password for the Windchill Business Reporting database user.
Confirm Windchill Business Reporting Oracle Database Password for the Database User Account
or
Confirm Windchill Business Reporting SQL Server Database User Password for the Database User Account
Confirm the password entered in the previous field. This field appears only if the Create PTC Windchill Business Reporting Database User Account or Create PTC Windchill Business Reporting Database and User option was selected previously from the optional products screen.
Specify the appropriate LDAP settings for your configuration. For more information, see Entering Your LDAP Settings.
Set the following optional product settings:
Option
Default
Description
Communication Port of the PTC Windchill Business Reporting Host
9300
Port used by Windchill Business Reporting host to communicate with the Windchill Business Reporting gateway.
Installing the Gateway Server and Windchill Solution
From the list of solutions to install, select the Windchill solution or solutions you are installing.
On the optional products screen, select Windchill Business Reporting.
On the product optional features screen, select the following options, as appropriate:
Option
Default
Description
Install the Host Components
Selected
Deselect this option.
Install the Gateway Server
Selected
Leave this option selected. The Configure Local HTTP Server for Gateway check box must also be left selected (the default) for a local HTTP Server to be automatically configured by the PSI.
Enter the following installation directory information:
Option
Default
Description
Installation Directory for PTC Windchill Business Reporting
<Windchill installation directory>\Reporting
The location where the gateway server is installed.
Set the following data loader settings:
Option
Default
Description
Load base data
Selected
Loads the base data set, including the pre-defined reports for Windchill Business Reporting. PTC strongly recommends leaving this option selected, to avoid the need for certain manual post-installation configurations.
Specify the appropriate LDAP settings for your configuration. For more information, see Entering Your LDAP Settings.
Set the following administrative settings for Windchill Business Reporting:
Option
Default
Description
Windchill Business Reporting Administrative User ID
wbradmin
This user has administrative privileges for Windchill Business Reporting but is not a Windchill administrative user. This user is created in the repository specified in the Base Distinguished Name for Administrative Users option on the LDAP settings screen.
Windchill Business Reporting Administrative User Password
Enter the password for the Windchill Business Reporting administrative user.
Confirm Password for Administrative User
Confirm the password entered above.
Set the following optional product settings:
Option
Default
Description
Windchill Business Reporting Gateway Machine's DNS Registered Host Name
local machine
Location where the gateway server will be installed.
Windchill Business Reporting Gateway Machine's Web Server Port
80
Port that the gateway server will listen on to communicate with the host components.
Mapped location of Windchill Business Reporting Host installation (leave empty if locally installed)
The drive mapped to the host installation. You must share the host installation location on the host machine with read/write permissions for the machine where the Windchill solution is installed. Then, on the machine where the Windchill solution is installed, map a location to that shared host installation.
* 
This step must be completed before you can proceed with the installation.
DNS Registered Host Name of the PTC Windchill Business Reporting Host
local machine
This value must match the machine where the host components were installed.
Communication Port of the PTC Windchill Business Reporting Host
9300
Port used by Windchill Business Reporting host to communicate with the Windchill Business Reporting gateway.
This value should match the value entered when the host components were installed.
Location of Windchill Business Reporting Host Installation as seen by the Windchill Business Reporting Host
Installed location of Windchill Business Reporting
The installed location of Windchill Business Reporting as seen by the host component.