SSAS SQL Server Management Studio

Question

Hello!

Faced with such a problem.

After i install SQL Server Analyssis Services i can't connect using the effectiveusername option even through SQL Server Management Studio.

Checked on several other servers in other domains - it works.

And the error committed is not informative: "following system error occured:"

Tried a lot of things, but so far that has not helped. In the server administrators added. Added role.

Firewall off. Service account changed.

What could be the problem?

Answer 1

Have you checked to make sure SSAS service is running? Have you tried restarting SSAS service (from SQL Server Configuration Manager)?

Are you trying to connect with a windows domain account or with SQL authentication?

Are you logged in locally on the SSAS server machine or are you trying to make a remote connection from another machine?

Have you verified that your user account has been added to Security tab of Analysis Server Properties?

What version of SQL Server? Do you have the latest SP update applied?

HTH,

---

Phil Streiff, MCDBA, MCITP, MCSA

Answer 2

What role assign to user ? Refer following link for better understanding

https://msdn.microsoft.com/en-us/library/cc304417.aspx

---

Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

Answer 3

Hi Argusk,

Thanks for your question.

In this scenario, you may need to make sure you can login your SSAS server directly with that user name in effectiveusername through SQL Server Management Studio.

If you can not login, please make sure the SSAS services are in running status. If SSAS services are running normal, then you may need to repair your SSAS instance.

If you can login directly, please make sure you have added that uer to SSAS server administrators,effectiveusername will only work if you're an SSAS administrator.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 4

Hello, we found the problem - there was not enough rigts for some users in Active Directory.

It was right for Read ACL on users that uses SSAS with effective username

As we mean it was bug of current infrastructure