MS SQL Server OLAP - Developer access to Analysis Services 2005

Author

Developer access to Analysis Services 2005

Dave

2006-01-30, 8:24 pm

We would like to configure access to an instance of AS2005 on a
development server so that developers can create and process databases
and cubes from their desktop machines. Our developers are in a Windows
Group which has been added to the SQLServer2005MSOLAPU
ser$.... group on
the server. The developers can see the AS2005 instance and the objects
on it but cannot create any new objects or process existing ones. How
should access be configured so that developers have full control of
cube databases (create/deploy/process etc) on the AS2005 instance
without making the developers server administrators?

Cheers,
David

Marius Dumitru

2006-01-31, 3:23 am

You can define a role for desired databases, include developers (the Windows
group) as role members, and give full "administrator" database permissions
for each role.

Then, developers will have full control on objects inside these databases
(except for the ability to create and delete database objects themselves).

--
Hope this helps

Marius

"Dave" <david.antelmi@gmail.com> wrote in message
news:1138667162.753061.192350@g43g2000cwa.googlegroups.com...
> We would like to configure access to an instance of AS2005 on a
> development server so that developers can create and process databases
> and cubes from their desktop machines. Our developers are in a Windows
> Group which has been added to the SQLServer2005MSOLAPU
ser$.... group on
> the server. The developers can see the AS2005 instance and the objects
> on it but cannot create any new objects or process existing ones. How
> should access be configured so that developers have full control of
> cube databases (create/deploy/process etc) on the AS2005 instance
> without making the developers server administrators?
>
> Cheers,
> David
>

Dave

2006-01-31, 8:24 pm

Marius,

Did what you said and it works well.

I also found some useful advice on msdn at
http://msdn2.microsoft.com/ms174561.aspx. It appears that
"server-wide" permissions must be granted to create/delete database
objects within the AS2005 instance. Granting database roles alone are
not enough for this. So what we have ended up doing is having a couple
of "super-developers" with server-wide permissions that can create new
databases within the AS2005 development instance. Another group of
developers have been set up following your instructions with only
database roles allowing them to administer objects within these
databases.

Thanks for your response.

Cheers,
Dave

Sponsored Links