"Failed to acquire access to database" when IR retrieve data from SSAS in workspace.
Error: Failed to acquire access to database.
OLE Error: 80004005 unknown Error Source: Microsoft OLE DB Provider for Analysis Services 2008。
Error Description: 出现以下系统错误: 该项不适于在指定状态下使用。 。(Chinese charactors says "The item is not suitable for use in a specified state")
Here is problem background:
1. EPM 11.1.2.2 system deployed on 64bit window 2008 servers and added to domain, meanwhile the SSAS cube is on 64 bit windows 2008 servers in same domain as well.
2. EPM was installed by a domain user which added to local administrators group(necessary local security policies was assigned), also this user is granted as admin role by share service provisioning. The same user was also added to SSAS server administrators group with required local security policies.