I am following this link http://www.flexmonster.com/doc/connecting-to-microsoft-analysis-services/#xmla to set up Pivot control with XMLA connection.
Even after following instructions I am getting ‘Failed to load resource: the server responded with a status of 401 (unauthorized) error and XMLHttpRequest cannot load OLAP . Response for preflight has invalid HTTP status code error.
I am able to open OLAP site in Excel and able to browse through SSAS cube. Any help would be appreciated. But when I try to open OLAP in web browser I get ‘Parser: The syntax for GET is incorrect’ error.
Yes, I understand the problem. It always takes some time to apply all necessary setting and setup XMLA connection correctly. Please notice that it’s not a limitation of the component but browser’s security restrictions. That’s why you can see your data source in Excel but still have a security issue with the browser.
I recommend you to use Flexmonster Accelerator tool. It will help you to avoid the uneasy process of XMLA setup. Also, your data will load several times faster and become more protected.
I would prefer using XMLA set up since Accelerator needs to run all the time. Also as per our application structure we prefer to have OLAP mounted on IIS.
Is there anything you can suggest?
Thank you for the details. We would like to inform you that if your cube requires login and password, XMLA protocol is not suitable. Due to security restrictions, browser cuts off the request header. This is not the limitation from our component. However, we provide user authorization for Accelerator. Please consider using Accelerator and let us know if you have further questions.
Thanks you for response. I would like to know if Accelerator needs to be installed on server hosting application or each client machine? I am not able to connect to Pivot running application which is running on server. I can connect only if Accelerator is running on my machine.
Thank you for your question. There is no need to install the Accelerator on client’s machine. However, it is preferable to have the Accelerator installed as much close to the data as possible. Such approach allows reducing the time spent on data transporting through the network. Speaking about the issue, it seems that the 50005 port for the Accelerator is not opened on your machine. Therefore please make sure that the Accelerator port is opened in the firewall and allows access from the outside.
Let us know if everything works fine for you.