I can't see "Report Builder" button in the Report Manager on SQL Server 2005

Question

I am a member of all the roles (Browser, Content Manager, My Reports, Publisher, Report Builder). If I login with a Local Administrator account, I can see and use it fine. Any ideas?

Solution 1

The first thing I would check is to make sure that your normal login is mapped to a role with the correct system-level permissions. The item-level role definitions don't make a difference for the "Report Builder" button.

From the browser-based report manager interface:

• Click "site settings"
• In the Security section, click "Configure system-level role definitions"
• Click the Role that you want to have this ability (e.g. "System Administrator" and "System User" are the default roles, but I believe that you can create your own if you want to).
• Make sure that the "Execute Report Definitions" task is checked/selected. This is the permission that controls whether or not the "Report Builder" button is displayed.
• Click "OK" and then return to the "Site Settings" page.
• In the Security section, click "Configure site-wide security"
• Click "New Role Assignment" and then map your login (or an AD group to which your login belongs might be even better) to the system-level role you edited in the previous steps.

The forms are pretty straightforward, and I'd guess that your login just isn't mapped to the proper system-level role since you can see the button with the local administrator login. If that doesn't work, you might check your IIS security settings for the report service to make sure that they're configured to use windows authentication (assuming that's what you're using in the first place).

Solution 2

Tried to do as was stated in the answer above. But didn't find "Configure system-level role definitions" as mentioned in the second bullet. Perhaps the interface has changed a little in the past 5 years.

Assuming you already have a browser window open where you see the report manager without the [Report Builder] button, I refer to this as the 1st browser window.

Like Matt said, you need to start a 2nd browser window as Administrator, go to the report manager again and click on [Site Settings].

After that, you click on [Security] and then on [New Role Assignment], type your username in the following page along with a check in [System User] Role.

When this was done, the [Report Builder] button occurred again in my 1st browser window (after refresh of course).

Comments

[Kirk]

This seems to be similar in SQL Reporting 2008 R2 and 2012. There is a MSDN article on this with a bit more detail if someone comes across this as well. <msdn.microsoft.com/en-us/library/ms365173.aspx>

[Michael Plautz]

For SQL Server 2014, steps 2 - 6 must be done in SQL Server Management Studio with a connection to Reporting Services (run as administrator). @Kirk's link to the MSDN article elaborates.