How to Enable Report Builder tab in SSRS

Many of the SSRS administrator I have interacted are a little confused about enabling Report Builder tab. The reason is when the get on the box where they have installed reporting services, they browse to http://localhost/reports they are able to see the report builder tab, but when the try to access the site remotely they cannot see it. To confuse matters future, the administrator keeps granting access to the Report Builder Role and nothing happens.

image

Below is the step by step instructions on how to enable Report Builder

1. Remote in or log into box where you have installed SSRS

2. Go http:\\localhost\Reports

image

3. Click on site setting in the Right hand corner, you will get the below from

image

4. Click Configure system-level role definitions,

image

Click New Role

image

5. Add a new role name: Report Builder, Description “This role will make report builder visible to users”

Same as shown above click OK

6. Select Site Setting

7. click Configure site-wide security

image

Click Ok.

When User1 access the site remotely should see the Report Builder Tab.

Advertisements

One thought on “How to Enable Report Builder tab in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s