Friday, November 14, 2008

Not getting any errors, but also not getting button to launch the Report Builder.

Problem Description:
=======================================================================
Not getting any errors, but also not getting button to launch the Report Builder.

Cause:
=======================================================================
Doesn’t have sufficient permissions for the user.

Resolution:
=======================================================================
Solution1:

Users cannot see the Report Builder icon unless they are in the local Administrators group. Users need to be in the site-wide System User role in order to run Report Builder. This role adds the "Execute report definition" task, which is only included in the System Administrator and System User roles.

Solution2:

Tutorials on MSDN and adding the users to just the reporting server via SQL Mgmt Studio.
http://msdn2.microsoft.com/en-us/library/aa337469.aspx

No comments: