Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, September 5, 2013 9:38 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:38 PM
Points: 97, Visits: 359
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