Granting Access to Analysis Services with access to server level

  • 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.

    ------------
    🙂

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply