Problem
In Health and Activity Tracking for BizTalk Server 2004, the following errors may occur when you process the cubes:
- The DTA DB doesn't have any data to process
- Log in failed for user <Domain>\<OLAPMachineName>$\
Cause
This can occur in a multi machine configuration where the DTAAnalysisDB resides on one server and the DTA DB resides on another.
Resolution
Ensure that the OLAP service runs under a domain account that has access to the DTA DB.
See all of our documentation issues we are blogging about:
https://blogs.msdn.com/luke/category/7759.aspx