由于权限错误，无法在SQL Server 2008r2中部署报表 [英] Cannot deploy a report in SQL Server 2008r2 due to a permissions error

问题描述

我无法部署报告或项目，因为我一直收到错误



授予用户'KCDCSS-SQL \ EContacts'的权限不足以执行此操作。



报表服务器与SQL Server 2008r2位于同一服务器上

EContacts是服务器上的用户管理员

EContacts是具有SysAdmin权限的SQL Sever上的用户，以及具有建议权限的ReportServer和ReportServerTempDB表的用户。

EContacts也作为系统管理员在报表服务器站点设置中设置

即使我以管理员身份登录，我也以管理员身份运行IE和VS2008



在此服务器上使用此版本的SQL Server的报表服务是新的。我在另一台没有问题的服务器上安装了SQL Server 2005 Reporting Services。我已经在这台2008r2服务器上尝试过这些设置而没有运气。



我在各种论坛上阅读了很多帖子，并尝试了一切我找不到的运气。



我很难过。任何人都可以提供任何非常感激的建议吗？

I cannot deploy a report nor the project because I keep getting the error

"The permissions granted to user 'KCDCSS-SQL\EContacts' are insufficient for performing this operation."

The Report Server is on the same server as SQL Server 2008r2
EContacts is a user on the server as an Administrator
EContacts is a user on the SQL Sever with SysAdmin rights and a user for the ReportServer and ReportServerTempDB tables with the recommended permissions.
EContacts is also set up in the Report Server Site Settings as a System Administrator
Even though I log in as Administrator I run IE and VS2008 as Administrator

Using Report Services on this server with this version of SQL Server is new. I do have SQL Server 2005 Reporting Services on another server that works with no problem. I have tried those settings on this 2008r2 server with no luck.

I have read lots of postings on various forums and tried everything I find with no luck.

I am stumped. Can anyone provide any advise which will be very much appreciated?

推荐答案

确保该帐户有权发布报告。这个链接可能有所帮助：



http://www.mssqltips.com/sqlservertip/2793/sql-server-reporting-services-2012-permissions/ [ ^ ]

Make sure that the account has permission to publish reports. This link may help:

http://www.mssqltips.com/sqlservertip/2793/sql-server-reporting-services-2012-permissions/[^]

这篇关于由于权限错误，无法在SQL Server 2008r2中部署报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！