Click here to Skip to main content
13,293,698 members (71,709 online)
Click here to Skip to main content
Add your own
alternative version


3 bookmarked
Posted 2 Oct 2010

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

, 2 Oct 2010
Rate this:
Please Sign up or sign in to vote.
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.


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.



This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.

You may also be interested in...


Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.171207.1 | Last Updated 3 Oct 2010
Article Copyright 2010 by kasiarun
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid