授予用户的权限不足以执行此操作。 (RsAccessDenied)

问题描述:

我需要一些帮助,这个错误:用户没有所需的权限。验证是否已授予足够的权限并且已处理Windows用户帐户控制(UAC)限制。授予用户的权限不足以执行此操作。 (RsAccessDenied)

我正在以管理员身份执行。

谢谢!

enter image description here

+0

你有在SSRS并在其许可的具体文件夹? – HEDMON

+0

感谢您的回复。在这两个文件夹我有完全的控制了我的用户(管理员用户): C:\ Program Files文件(x86)的\ Microsoft SQL Server的\ MSRS10_50.SQLEXPRESS \ Reporting Services的\ ReportManager 和 C:\ Program Files文件( x86)\ Microsoft SQL Server \ MSRS10_50.SQLEXPRESS \ Reporting Services \ ReportServer 在SSRS数据库中,我的用户是dbo – user3865905

通过您的评论,我相信你正在寻找NTFS权限,而不是Reporting Services的权限。试试这个:

  1. “运行为”管理员IE并打开http://localhost/Reports(或任何为URL)
  2. 在上“网站设置”右上角点击(http://localhost/Reports/Pages/Settings.aspx
  3. 检查“安全'设置(http://localhost/Reports/Pages/Settings.aspx?SelectedSubTabId=SecurityLinkID
  4. 设置权限后,请重新启动浏览器,而不使用普通帐户并尝试。

有关如何设置权限的更多信息,请阅读这里:https://msdn.microsoft.com/en-us/library/ms156034(v=sql.110).aspx

To add a user or group to a system role

  1. Start Report Manager (SSRS).
  2. Click Site Settings.
  3. Click Security.
  4. Click New Role Assignment.
  5. In Group or user name, enter a Windows domain user or group account in this format: \. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.
  6. Select a system role, and then click OK. [Roles are cumulative, so if you select both System Administrator and System User, a user or group will be able to perform the tasks in both roles.]
  7. Repeat to create assignments for additional users or groups.

To add a user or group to an item role

  1. Start Report Manager and locate the report item for which you want to add a user or group.
  2. Hover over the item, and click the drop-down arrow.
  3. In the drop-down menu, click Security.
  4. Click New Role Assignment.

Note If an item currently inherits security from a parent item, click Edit Item Security in the toolbar to change the security settings. Then click New Role Assignment.

  1. In Group or user name, enter a Windows domain user or group account in this format: \. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.
  2. Select one or more role definitions that describe how the user or group should access the item, and then click OK.
  3. Repeat to create assignments for additional users or groups.