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

If I would like to create a Business Intelligence (BI) system using SSAS, with SSRS getting data from the SSAS cube.

Which would be the best possible option to store users' credentials used with SSAS?

Active directory seems to be the only option, but unfortunately it creates the need for additional Active Directory licenses and therefore higher costs.

Is there any other solution?

share|improve this question
up vote 0 down vote accepted

SSAS works with windows authentication only. Being in a domain is the normal way to do this, hence Active Directory is usually the way to go. You have not provided much details in terms of suggesting something else.

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.