Configure Component Services

If your production database is on a different computer than the Reporting Database, the following configuration changes are required.

Before you begin

Important: You can perform these steps either before or after installing the Reporting Database; however, you must complete these configuration changes before you run your reporting data synchronization.
Note: For this procedure, your production database server is the "server," while the reporting database server is the "client."

Procedure

  1. Verify that the Distributed Transaction Coordinator service is running on both the server and client computers.
    1. From the Start menu, point to Administrative Tools, and then click Services.
    2. If the Distributed Transaction Coordinator service is not running, right-click it, and then click Start.
  2. On the server computer, from the Start menu, point to Administrative Tools, and then click Component Services.
  3. In the left navigation tree, click Component Services, and then expand Computers.
  4. Right-click My Computer and select Properties.
    The My Computer Properties dialog box appears.
  5. Click the MS DTC tab.
    Important: If you are using Windows 7, Windows Server 2008, or Windows Server 2012, you must use the following path to retrieve these computer properties: Component Services> Computers>My Computer>Distributed Transaction Coordinator>Local DTC.
  6. Click Security Configuration.
    The Security page appears.
  7. Select the following check boxes:
    • Network DTC Access
    • Allow Remote Clients
    • Allow Inbound/Outbound Administration
    • Enable Transaction Internet Protocol (TIP) Transactions
  8. Click OK.
    A message appears, stating that "MS DTC Service will be stopped and restarted. All dependent services will be stopped. Please press Yes to proceed." Click Yes.
  9. In the My Computer Properties dialog box, click OK.
  10. If required, reboot your production database server.
    Note: We recommend that you reboot your production database server.
  11. On the client computer, repeat steps 2-6.
  12. Select the Network DTC Access and Allow Inbound/Outbound Administration check boxes.
    The DTC Service is stopped and restarted.
  13. Restart the client computer.
  14. Verify that the Distributed Transaction Coordinator service is running on both the server and client computers, and, if required, repeat step 1.