November 10, 2016 at 11:53 am
If this is not the best forum for this question, please let me know.
I am a Windows admin and a sysadmin on SQL Server for this particular instance in question. We are running SSAS on the same machine. I can do anything I want in SQL Server (as per sysadmin), but I can't even see the SSAS databases, although I can connect. I know they exist because another colleague can see them.
I have limited knowledge of SSAS, but this appears to be a permissions "thing"..
Thoughts?
Thanks in advance!
November 10, 2016 at 12:46 pm
Analysis Services permissions are separate from the SQL Server engine permissions. In Management Studio, make an Analysis Services connection (click on the Connect button dropdown in Object Explorer)
Once you're connected, right-click on the instance name, select properties, then click on the Security page. You should be able to add yourself or an AD group here to be SSAS admin:
https://msdn.microsoft.com/en-us/library/ms174561(v=sql.105).aspx
November 10, 2016 at 1:34 pm
Worked perfectly. Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply