none
The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)

    Question

  • I Installed SSRS 2008 R2 on Win Server 2008 R2. Every thing is all right, I can open Report Manager and it's Security link to define new users. I can open Report Server page, but when I want to publish my reports on Report Server I faced with this problem:

    C:\CalibrationReports>C:
    
    C:\CalibrationReports>cd\CalibrationReports\
    
    C:\CalibrationReports>rs.exe -i publishreports.rss -s  http://ndcalibration:8080/ReportServer_SQL2008 
    

    rsAccessDenied400The permissions granted to user 'NDCALIBRATION\admin' are insufficient for performing this operation.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.50.1600.1Microsoft SQL Server Reporting Services10.50.1600.1127OsIndependent1033ReportingServicesLibraryThe permissions granted to user 'NDCALIBRATION\admin' are insufficient for performing this operation. System.Web.Services.Protocols.SoapException: The permissions granted to user 'NDCALIBRATION\admin' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NDCALIBRATION\admin' are insufficient for performing this operation. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateFolder(String Folder, String Parent, Property[] Properties) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateFolder(String Folder, String Parent, Property[] Properties) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) System.Web.Services.Protocols.SoapException: The item '/CalibrationReports' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/CalibrationReports' cannot be found. at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings) The command completed successfully

    Does anyone know the reason?

    asked 2 mins ago
    add comment

    Know someone who can answer? Share a link to this question via emailGoogle+,Twitter, or Facebook.

    <input style="border:1px solid rgb(136, 136, 136);font-size:17px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;margin:3px;padding:2px;font-weight:bold;cursor:pointer;" type="button" value="Answer Your Question" />

    Would you like to have responses to your questions sent to you via email?

    tagged

     × 1850

    asked

    today

    viewed

    2 times

    Wednesday, November 28, 2012 7:15 AM

Answers

  • Hi Farzad,

    Based on your description, you publish a report to report server by using rs Utility (rs.exe). Please try to run script process as administrator: right-clicking Command Prompt, and clicking Run as Administrator.

    If the issue persists, please verify that you have a role assignment that allows publishing a report. We can use Report Manager to create the role assignments. For more information, please refer to "Role Assignments" in SQL Server Books Online.

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Thursday, November 29, 2012 5:34 AM
    Moderator