How to connect to Microsoft Analysis Services from ASP.NET

Unfortunately there is no mixed mode security in Analysis Services like in SQL server. You can not just pass login and password through connection string.

The only way to connect to Analysis Services is windows authentication, and therefore impersonalization.

Here is the simple solution:

1) Create the same User with the same password on both servers: on server with ASP.NET application and on server with Analysis services. For example: “AnalysisUser” and “AnalysisPassword”

2) Configure access to Analysis Services and give him all rights to run ASP.NET application.

3)  Configure impersonalization for ASP.NET application by inserting following line in Web.config in “system.web” section:

<identity impersonate="true" userName ="AnalysisUser" password="AnalysisPassword"/>

That is it, after these manipulations connection should be functional.