none
SSRS Access

    Question

  • Hi All,

    How to provide SSRS access for domain user in SQL server. 

    Regards,

    Karthik

    Wednesday, December 7, 2016 5:41 PM

All replies

  • Hello Karthik,,

    SSRS has a permission system independent of SQL Server permission, so you have to grant permissions in SSRS; see Grant User Access to a Report Server (Report Manager)

    There are may some stored procedure in ReportServer database to add permissions with SQL, but they are not documented = not supported; usage on own risk.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, December 7, 2016 5:45 PM
  • Hi,

    We are getting below error while access though URL

    User does not have required permission. Verify that sufficent permission have been granted and windows user acount control (UAC) restriction have been addressed

    Wednesday, December 7, 2016 6:48 PM
  • Open the report Manager URL

    Go to Site Settings in the top right

    Click home, Folder Settings, then New Role Assignment  --->domain\username and select Content Manager,

    open new internet explorer (non-admin) and recheck the url.



    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.


    Thursday, December 8, 2016 12:54 AM
  • Hi,

    we have provided report database access for the domain user. after that we didn't faced any issue

    Thursday, January 5, 2017 5:48 PM
  • Hi All,

    Thanks for your support.

    Regards,

    karthik B

    Tuesday, January 10, 2017 6:03 AM