Hi,
I am facing an issue while trying to use powerplay connect(cognos 7.3)to access ssas cube(sql server 2005). The error message is - "Cannot connect to server 'analysisservername" MSOLAP.The server is too busy or not running".
Below are the checks I have done, after reading various forums:
1. Microsoft ssas cube has been set to 1 under configuration manager's olap data access
2. OLE DB 9 and msxml 6 are installed on the machine
3. I am able to use excel application to create a data source connection and access the cube
4. Checked that the SSAS server is up and running
5. I am able to connect to the ssas server and database via udl file
6. Verified that the registry's HKEY_CLASSES_ROOT folder has MSOLAP.3
Could there be other causes for this issue?
Thanks