Solved

SSAS permission issues

Posted on 2008-09-29
4
464 Views
Last Modified: 2016-02-12
Hello,

We are running SQL Server 2K5 SP2.  

I have a user who needs to be able to access/create/modify cubes/dimensions etc. on our server but is unable to do so.  He can connect to SSAS, but once he does none of the databases are listed.

I have even set his domain account up as an admin (every role checked on the server roles list) on the server and he still cannot use analysis services.

As far as I can tell, he has the exact same permissions as me and I can do everything just fine.

Any thoughts?
0
Comment
Question by:Torrwin
4 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
ID: 22603600
One way to solve the problem is to add my account to the SSAS' server role, which means to grant server-wide security privileges to my account in SSAS:

Run SQL Server Management Studio as Administrator account
Connect to the SSAS server
Right-click the SSAS server name and select Properties from the popup menu
Select Security to add account to server role

taken from http://junmeng.blogspot.com/2008/05/ssas-permission-for-least-privilege.html
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question