The OLAP service must run under a domain account that has access to the DTA DB in order to successfully process the cubes
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>$\
This can occur in a multi machine configuration where the DTAAnalysisDB resides on one server and the DTA DB resides on another.
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: