We have installed BPC 7.0 in 2-server architecture.
First server is VM - Windows 2003 32 bit, it contains
- Reporting Services
- Integration Services
Second server is physical. Windows 2003 64 bit, it contains
- SQL Server 2005
- OLAP Server 2005
We have installed also a separate client: admin and office tools.
During opening Excel 2007 (provider Microsoft.ACE.OLEDB.12.0 is installed on first server) we got error:
InitCatalog:Cannot connect to the server 'XXXXX'. The server is either not started or too busy.
After clicking the OK button in the error message, I was further notified that Account dimension member cannot be downloaded and so on.
It looks like similar problem as in this thread: initcatalogcannot-connect-to-the-server-'xxxxx'
But it wasn;t solved.
We got also the same error during processing cubes/dimensions from BPC Administrator.
Can anybody help us solving this problem?
Thanks in advance.