Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Granting Access to Analysis Services with access to server level Expand / Collapse
Posted Thursday, September 5, 2013 9:38 AM



Group: General Forum Members
Last Login: Wednesday, November 2, 2016 7:10 AM
Points: 108, Visits: 445
I can't seem to access Analysis Services using SSMS or create a data source in BIDS for Analysis Services.

I have two accounts, a regular account and an admin account. Admin account has access on the Analysis Services Server as full administrator. I want to give access to my regular account. Per MSDN, I connected to AS using my admin account in SSMS, created a new role for administrators and added my regular account. (See pictures). Per MSDN, my regular account should have access SSAS, but it doesn't.

I created a new report server project in BIDS. I tried to create a Datasource for analysis services. When I try to connect it, it says authentication failed. Same thing works for my Admin account.

In SSMS, I can't connect Analysis Services Instance using my regular login, but I can connect to it using my admin account.

I know if I give access to my regular login at server level, it will work. But I am trying to figure out why can't I access Analysis Services when I give access to it at the database level? (see picture)

I have made sure Analysis Service is running.


  Post Attachments 
Admin.JPG (3 views, 52.58 KB)
Authentication.JPG (3 views, 59.64 KB)
Post #1491860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse