Home / server / Questions / 136239
In Process
ScottStonehouse
Asked: 2010-04-28 05:44:55 +0800 CST

How do I give a user permission to install Report Builder from Report Manager? (SQL Server 2008)

  • 772

By default, users do not see the "Report Builder" button on the Report Manager toolbar in SQL Server 2008 (R1). How do I give the user permission to use the Report Builder?

sql-server ssrs ssrs-2008

2 Answers

  1. Try graning Manage Reports

    • 0

  2. There is a role for this on the security tab in Report manager. Do a new role assignment or add the Report Builder role to an existing role assignment. Additionally you may need to add them to the site security section as a System User.

    Home Folder Security:
http:/localhost/reports/Pages/Folder.aspx?SelectedTabId=PropertiesTab

Site Security:
http:/localhost/reports/Pages/Settings.aspx?SelectedSubTabId=SecurityLinkID
    • 0