Prerequisites for locating BMC Remedy AR System Server and BMC IT Business Management Suite databases separately

If your BMC Remedy AR System Server database is located on a different network than the BMC IT Business Management Suite database, you must meet the following prerequisites before installing the application:

• Create a database for BMC IT Business Management Suite.
• Create a link between the BMC IT Business Management Suite database and the AR System server database. The database link is required for the integrations between BMC Service Resource Management and BMC Demand and Resource Management to function.
• Encrypt the BMC Remedy AR System API calls.
• Use the same type of database for both AR System server and BMC IT Business Management Suite. For example, if you are using Oracle Database for AR System server, also use Oracle Database for BMC IT Business Management Suite.
• The BMC IT Business Management Suite application server and the BMC IT Business Management Suite database server must be collocated to eliminate any significant network latency.
• Run the BMC IT Business Management Suite installation program on the same computer on which you install the BMC IT Business Management Suite database.
• The following communication ports must be open between the BMC Remedy AR System and the BMC IT Business Management Suite environments:
  • BMC IT Business Management Suite database server: port 1521 (Oracle), port 1433 (Microsoft SQL Server)
  • AR System server: portmapper-specified port
  • AR System server database: port 1521 (Oracle), port 1433 (SQL Server)

  • BMC IT Business Management Suite application server: port 8080/9090 (depending on where JBoss is listening) 

    Warning

    Note

    These ports are typically used to communicate with databases. However, if other ports have been configured for this purpose, they must be opened.

For prerequisites that are specific to certain databases, see the following sections:

• • Prerequisites specific to SQL Server databases
  • Prerequisites specific to Oracle databases

Prerequisites specific to SQL Server databases

In deployments using SQL Server databases, you must enable network Distributed Transaction Coordinator (DTC) access. You must also enable the XACT_ABORT setting on the BMC Remedy AR System database.

To enable network DTC access

1. From the Microsoft Windows Start menu, click Run.
2. In the Run dialog box, type dcomcnfg, and then click OK.
3. In the console tree of the Component Services window, expand Component Services > Computers > My Computer > Distributed Transaction Coordinator > Local DTC.
4. Right-click Local DTC and select Properties.
5. On the Security tab of the Local DTC Properties dialog box, select the following options:
   • Network DTC Access
   • Allow Remote Clients
   • Allow Outbound
   • Allow Inbound
     
     (Click on the following image to expand it.)
     
     
     
6. Click OK.

To enable the XACT_ABORT setting on the BMC Remedy AR System database

1. Log on to SQL Server Management Studio, right-click on the selected instance name, and select Properties.
2. In the Server Properties window, select Connections in the Select a page pane.
3. In the Default connection options area, select the xact abort check box, and then click OK.
   
   (Click on the following image to expand it.)
   
   
   
4. Restart the AR System server.
    You must restart the AR System server because the server maintains the database connection pool, and changes in the database server connection properties are not reflected in the existing database connection sessions. After you restart AR System server, new database connection sessions are created, and the distributed transactions over remote views start working.

If the distributed transactions over remote views do not work, see Troubleshooting-DTC-communication-through-a-firewall-using-RPC and perform the procedures described in it.

Prerequisites specific to Oracle databases

On the BMC Remedy AR System server computer, edit the TNSNAMES.ORA file to add the connection strings for establishing connections to the BMC IT Business Management Suite database.