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?
Asked
Active
Viewed 856 times
2 Answers
0
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

Jason Cumberland
- 1,579
- 10
- 13