Click here to Skip to main content
Click here to Skip to main content

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

, 2 Oct 2010 CPOL
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.
 
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


License

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

Share

About the Author

kasiarun

United States United States
No Biography provided

Comments and Discussions

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