Post reply

The permissions granted to user 'ABC\mssqlsrv' are insufficient for performing this operation. (rsAccessDenied)

  • December 15, 2011 at 11:40 am

    #261916

    Hi,

    I have installed & configured SQL Server 2008 R2 on Server A The reporting services runs under the account abc\mssqlsrv.

    The reportserver & reportserverTempdb are configured to store on Server B with SQL Server 2008 R2, which is aslo running under the account abc\mssqlsrv

    Everything is green in Reporting services configuration manager

    But getting below error when I open reportserver url http://servername/reportserver

    The permissions granted to user ABC\mssqlsrv' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

    Then I tried with the account abc\admin (sysadmin) to login to the http://servername/reportserver) and getting the below error

    The permissions granted to user ABC\admin are insufficient for performing this operation. (rsAccessDenied) Get Online Help

    Verified that rsexecrole and db_owner permissions are already exist for ABC\mssqlsrv in reportserver database

    and ABC\admin is an admin account with all permissions

    Please advice

  • December 15, 2011 at 11:46 am

    #1422140

    Can you screenshot your configuration so we can see how you have things configured?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 15, 2011 at 11:55 am

    #1422147

    It is probably because the user has not yet been added to a server group outside of SQL. Try logging in as sa and then managing the users through the reporting services interface.

    Jared

    Jared
    CE - Microsoft

  • December 15, 2011 at 12:02 pm

    #1422154

    Also, is abc\admin a server administrator? Not SQL Server, but local or domain.

    Jared

    Jared
    CE - Microsoft

  • December 15, 2011 at 12:06 pm

    #1422161

    Inside the server, It's working when I open the Internet explorer Run As Administrator:-):-)

    Out side the server, it just works fine...thanks

  • December 16, 2011 at 7:48 am

    #1422517

    Ah, the UAC. That makes a bit of sense.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 6 posts - 1 through 5 (of 5 total)

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