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)
 SSAS Authentication

Author  Topic 

nicklarge
Starting Member

40 Posts

Posted - 2012-08-02 : 12:26:32
Hello.

I have an SSAS database with multiple cubes. Each cube has ADS Groups assigned to them through role assignments; with users assigned to each group.

However, my users cannot connect to the SSAS database; the server actively refuses the connection. I spoke with colleagues and they assured me that the company does not allow members of staff to log into the servers directly (obviously for security reasons). So now I have no idea how to tackle this problem. I would like my users to browse the cube but they cannot have permissions to the server for logging in.

Can someone offer some suggestion as to my options for this predicament?

:(

Thanks, Nick.
   

- Advertisement -