Can't Find Report Builder in RS?

Yep, neither could I. Bizarre, or so I thought. I had upgraded to SQL 2005 RS from RS 2000 and never thought about the fact that I couldn't see Report Builder until someone asked for it. I searched and searched but couldn't find ANY info. Finally BoL to the rescue! It's always the last place I look, geez. It's gotten so much better it should be the first, but I'm just set in my ways I suppose.

You simply follow the simple steps after the jump to fix the problem. Add a group and edit a few roles and you're good to go.

New installations of SQL Server 2005 Reporting Services include a new role definition named Report Builder. This role defines a collection of tasks necessary for using Report Builder. The Report Builder role is not created for you when you upgrade an existing installation. However, you can create the role definition manually if you want to have the complete set of role definitions that are available in a new Reporting Services installation.

How to Update Existing Item-Level Role Definitions If you are using the predefined role definitions, you can edit them to include the new tasks. Adding new tasks to existing role definitions is the easiest way to grant current users permission to view and manage Report Builder reports and models. When you add a new task to an existing role definition, all role assignments that include that role definition will get the new tasks automatically.

Find the role definitions that are defined on the report server. In Management Studio, the role definitions are located under the Security node in the Roles folder. In Report Manager, open the Site Settings page and click Configure item-level role definitions.

Expand the Browser role definition. Add the "View models" task to the role, and then click OK.

Expand the Content Manager role definition. Add "Manage models", "View models", and "Consume reports" to grant full permission over models, and the ability to create and modify reports in Report Builder. Click OK.

Expand the Publisher role definition. Add "Manage models" to grant permission to create, view, and delete models on the report server. Click OK.

How to Update Existing System-Level Role Definitions To make Report Builder available to users, you must add tasks to the system-level roles.

In Management Studio, expand the System Roles folder. In Report Manager, open the Site Settings page and click Configure system-level role definitions.

Expand the System Administrator role definition. Add the "Execute report definitions" task. Click OK.

Expand the System User role definition. Add the "Execute report definitions" task. Click OK.

Creating a New Report Builder Role Definition New installations of SQL Server 2005 Reporting Services include a new role definition that organizes the set of tasks used for working with Report Builder into a single collection of tasks. If you are upgrading an existing installation, you must create this role definition manually. Creating a separate role definition ensures that Report Builder users have only those tasks that are necessary for creating ad hoc reports.

Create a new role definition using either Management Studio or Report Manager. For more information, see How to: Create, Delete, or Modify a Role (Report Manager) or How to: Create, Delete, or Modify a Role (Management Studio).

Name the role Report Builder.

Add the following tasks: Consume reports, View reports, View models, View resources, View folders, and Manage individual subscriptions.

Save the role definition.