Installation fails for Data Mart on a server not part of a Windows Domain
The required ETL SQL job resides on the DataWarehouse and when the console tries to get the status of the SQL job, a Distributed Transaction Call will be made. Since this transaction is done via MSDTC, the transaction may fail due to lack of authentication for the DTC.
To complete the installation and verify communication among the Analysis Center components:
- Ensure MSDTC is enabled on both the DataMart server and Data Warehouse server. Note: To enable MSDTC, you may have to reboot the computers.
- Follow the directions within the following Microsoft KB: MSDTC fails to mutually authenticate when computers do not run in the same domain.
- Launch the Analysis Console to ensure all components are enabled and that AC reports the ETL and OLAP jobs are successful.