Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using msmdpump.dll with basic authentication to access a SSAS OLAP cube from the internet. Does this method pass the auth info to SSAS so if I put permissions on the cube they get applied depending of the user I input in my connection string? If not, is there a way to do it?

share|improve this question
up vote 3 down vote accepted

Yes, msmdpump will pass the authentication through to SSAS.

Here is an article on how to get it all set up for SSAS 2005.

Here is one for IIS7 to SSAS 2008.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.