Solved

SSAS permission issues

Posted on 2008-09-29
4
457 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 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