Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.