Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Analysis Services Authentication

Author  Topic 

nicklarge
Starting Member

40 Posts

Posted - 2011-08-26 : 15:59:02
Hello

In order that reports can access Analysis Services 2008, they need to do so through NT authentication. When I create the account/group needed to do this, do I have to make that account An analysis services Administrator, or can it have lower privileges than that and still execute MDX?

Thanks, Nick.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-26 : 16:01:08
You can give it read permission
Go to Top of Page

nicklarge
Starting Member

40 Posts

Posted - 2011-08-30 : 14:29:48
Thanks Russell. Do you have any links or further information that will help me discover how to do this? Thanks again.
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-30 : 16:01:55
http://msdn.microsoft.com/en-us/library/ms175408(v=SQL.105).aspx
Go to Top of Page
   

- Advertisement -