I have a problem with connection (to SSAS OLAP cube, using MS Analysis Services 2008 -> OLE DB for OLAP providers) in designer from client machine.
When I testing connection I recived: Server not responding (SBO0001) -
in detail I have information: DBD: Can not find provider msolap.4
If I try to create and test connection from server machine everything work fine!
Additionaly when I want to refresh data in WEBI report in Rich Client from client mashine I recived en error:
Can not find provider msolap.4 (WIS10901)
or from InfoView from client or server machine:
An error has occurred while attempting to connect to the OLAP server. Failed to initialize (The component Microsoft OLE DB Provider for Analysis Services 2008 R2. returned server error (The following system error occurred: A specified logon session does not exist. It may already have been terminated. )). (WIS 10901)
On clients machines we have:
Windows XP SP3
Business Object Edge 3.1 SP3 (18.104.22.1681) Clients components
On server we have:
Windows Server 2008 R2 x64
Business Object Edge 3.1 SP3 (22.214.171.1241)
SQL Server 2008 R2
On the server ports 6400, 8080 and 1433 are opend.
Any ideas how to solve this problem?
Thanks in advance for your replying .