How to connect to Analysis Services (SSAS) from a different domain user

In my recent project, I was facing connectivity issues between Microsoft analysis service and my web application.

The code was working in the local environment but not on the production. In production it was throwing following error.

"An existing connection was forcibly closed by the remote host."

After debugging for some time, we come to know that Microsoft analysis service has a limitation of not allowing request from other domains.

"Microsoft SQL Server Analysis Services SSAS only allows users of the same domain or trusted domains and it does not allow users from any domain except from these two"



In our production environment, web server and SSAS were in different domain group.

Solution:

1) Create new domain account and impersonate the web site with that.
2) Create local user account on the analysis service with same exact username/password as like domain account created in the previous step.


That's it now the connectivity will work that because the user will be authenticated on the Analysis Services server by using the local user account with the matching credentials.

Reference:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/cisql2005ascs.mspx