0

I have an instance of Analysis Services set up with my cube and am attempting to access it through MS Excel.

This works for one of my accounts but not for another. My goal is to get the second account to be able to access the cube just like the first. However, I am not sure what permissions I am missing for the second.

I have added the second user as an administrator on Analysis services and even on the SQL Server instance and yet can't get past the below error.

How does my second account need to be set up to access the cube?

The server name looks like: https://[server]/OLAP/msmdpump.dll

enter image description here

1

1 Answer 1

0

My issue here was that the accounts had an Active Directory policy that was set to expire the password at first log in. In other words, the user was meant to reset their password when they first use the account.

Taking this off the password policy made the accounts work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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