授予用户的权限不足以执行此操作。 (RsAccessDenied)
问题描述:
我需要一些帮助,这个错误:用户没有所需的权限。验证是否已授予足够的权限并且已处理Windows用户帐户控制(UAC)限制。授予用户的权限不足以执行此操作。 (RsAccessDenied)
我正在以管理员身份执行。
谢谢!
答
通过您的评论,我相信你正在寻找NTFS权限,而不是Reporting Services的权限。试试这个:
- “运行为”管理员IE并打开http://localhost/Reports(或任何为URL)
- 在上“网站设置”右上角点击(http://localhost/Reports/Pages/Settings.aspx)
- 检查“安全'设置(http://localhost/Reports/Pages/Settings.aspx?SelectedSubTabId=SecurityLinkID)
- 设置权限后,请重新启动浏览器,而不使用普通帐户并尝试。
有关如何设置权限的更多信息,请阅读这里:https://msdn.microsoft.com/en-us/library/ms156034(v=sql.110).aspx
To add a user or group to a system role
- Start Report Manager (SSRS).
- Click Site Settings.
- Click Security.
- Click New Role Assignment.
- 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.
- 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.]
- Repeat to create assignments for additional users or groups.
To add a user or group to an item role
- Start Report Manager and locate the report item for which you want to add a user or group.
- Hover over the item, and click the drop-down arrow.
- In the drop-down menu, click Security.
- 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.
- 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.
- Select one or more role definitions that describe how the user or group should access the item, and then click OK.
- Repeat to create assignments for additional users or groups.
你有在SSRS并在其许可的具体文件夹? – HEDMON
感谢您的回复。在这两个文件夹我有完全的控制了我的用户(管理员用户): 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