Post reply

User 'Domain\XXX' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

  • May 24, 2012 at 1:36 pm

    #257033

    I'm trying to setup permission for the user to access specific reports in the Report Manager 3.0

    i have sql server 2008 r2, i created reports, and i need to grant permissions to the users to view some reports only.

    i added the user and granted Browser role for the user, on the Main folder--> and the Report item security properties. but the user is gettting the

    "User 'Domain\XXX' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed."

    can someone tell me what am i missing and where else i need to grant permission to the user?

  • May 24, 2012 at 1:57 pm

    #1492788

    Are u able to connect using that account from SSMS directly ? What kind of authentication are you using?

    Jayanth Kurup[/url]

  • May 24, 2012 at 2:02 pm

    #1492796

    for connectiong to the SSMS i'm using the common connection that i have in the shared datasource.

    so the user for the reports folder is differnt from the user used in the data source sql connection

  • May 24, 2012 at 2:11 pm

    #1492802

    sorry I shud have been more clear , using ssms connect to reporting services using the account you are facing issues with. You may also want to check how your connecting to SSRS and the Report server databases as well as the data sources. NTLM vs Keberos

    Jayanth Kurup[/url]

  • May 25, 2012 at 6:32 am

    #1493106

    I added domain user and granted user permissions on the folder, and the report item. using the report link directly user is able to access and exectue the report. but when accessing the report thru the folder is giving the above UAC permission error. user is us

    where else i need to add this user to? to Windows users and where else?

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

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