Troubleshooting (OLAP)

The problem is usually in badly configurable XMLA or with security (Flash, IIS or OLAP). Please see below how you can ensure everything is working fine.
  1. Test XMLA is configured properly and responds fine:
    - You should be able to see some sort server-error when typing it in your browser address bar (http://localhost/xmla/msmdpump.dll)
    - You can even connect your Excel Pivot using this URL (just create Pivot and use this URL to connect to analysis-services)

    If any of these methods don't work - then you most probably have the problem with XMLA configuration (app is not running, or IIS is stopped etc). Probably you should check against ALL the steps from this were passed correctly: http://technet.microsoft.com/uk-ua/library/cc917711(en-us).aspx

  2. Test browser and Flash security issues - it is often situation when Flash or browser don't allow connecting.
    - If you run the HTML sample from your local drive - can you copy it to the server so you could try it from http:// URL instead. (locally running Flash often require additional permissions - you may configure them, but putting to http:// is easier)
    - Ideally put crossdomain.xml into the root of your server when XMLA is configured (which allow Flash from site to connect to OLAP). You can copy the sample content of such file from here: http://www.flexmonster.com/crossdomain.xml

  3. Test OLAP permissions are enough:
    The best to do this is to make test "everyone" permissions. To do so go to Management Studio, connect to your Analysis Services. Open the Database you want to connect, then go to Roles and create a new Role with "full control" and add "Everyone" to members of this role.