我无法在SQL Server 2005上的报表管理器中看到“报表生成器”按钮

时间:2021-08-11 08:01:24

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?

我是所有角色的成员(浏览器,内容管理器,我的报告,发布者,报告生成器)。如果我使用本地管理员帐户登录,我可以看到并使用它。有任何想法吗?

2 个解决方案

#1


16  

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.
  • 单击“新角色分配”,然后将您的登录(或您的登录所属的AD组可能更好)映射到您在前面步骤中编辑的系统级角色。

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).

表单非常简单,我猜你的登录名并没有映射到正确的系统级角色,因为你可以看到带有本地管理员登录的按钮。如果这不起作用,您可以检查报表服务的IIS安全设置,以确保它们已配置为使用Windows身份验证(假设您首先使用的是)。

#2


4  

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.

试图像上面的答案中所说的那样做。但没有找到第二个项目符号中提到的“配置系统级角色定义”。也许界面在过去5年中发生了一些变化。

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.

假设您已经打开了一个浏览器窗口,您在没有[Report Builder]按钮的情况下看到了报表管理器,我将其称为第一个浏览器窗口。

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

像Matt说的那样,您需要以管理员身份启动第二个浏览器窗口,再次转到报告管理器并单击[站点设置]。

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).

完成后,在我的第一个浏览器窗口中再次出现[Report Builder]按钮(当然刷新后)。

#1


16  

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.
  • 单击“新角色分配”,然后将您的登录(或您的登录所属的AD组可能更好)映射到您在前面步骤中编辑的系统级角色。

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).

表单非常简单,我猜你的登录名并没有映射到正确的系统级角色,因为你可以看到带有本地管理员登录的按钮。如果这不起作用,您可以检查报表服务的IIS安全设置,以确保它们已配置为使用Windows身份验证(假设您首先使用的是)。

#2


4  

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.

试图像上面的答案中所说的那样做。但没有找到第二个项目符号中提到的“配置系统级角色定义”。也许界面在过去5年中发生了一些变化。

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.

假设您已经打开了一个浏览器窗口,您在没有[Report Builder]按钮的情况下看到了报表管理器,我将其称为第一个浏览器窗口。

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

像Matt说的那样,您需要以管理员身份启动第二个浏览器窗口,再次转到报告管理器并单击[站点设置]。

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).

完成后,在我的第一个浏览器窗口中再次出现[Report Builder]按钮(当然刷新后)。