mmajcica / DeploySsrs

Build-Release task for VSTS/TFS that manages Microsoft's SQL Server Reporting Services
MIT License
21 stars 21 forks source link

Permission problem #78

Closed steveking123 closed 2 years ago

steveking123 commented 2 years ago

Hi

I am getting the following error when I run a release:

Exception calling "ListChildren" with "2" argument(s): "System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation.   at Microsoft.ReportingServices.Library.ReportingService2005Impl.ListChildren(String Item, Boolean Recursive, CatalogItemList& CatalogItems)   at Microsoft.ReportingServices.WebServer.ReportingService2010.ListChildren(String ItemPath, Boolean Recursive, CatalogItem[]& CatalogItems)"

That user has Browser, Content and Publish permissions.

My config file is as follows.

{ "Name": "Root", "Folders": [ { "Name": "HBAdminReports", "Hidden": true, "CleanExistingItems": true, "Reports": [ { "Name": "Testing Release Pipelines", "Hidden": true, "FileName": "Testing Release Pipelines.rdl" } ] } ] }

The folder already exists and access permissions for the report once deployed will be set by others not by this deployment.

I have found quite a few similar errors and tried their suggestions where I can (a lot relate to standalone apps and the suggestions are only possible in that context. What have I probably missed?

steveking123 commented 2 years ago

I should say that we have tried the obvious: that user has Browser, Content and Publisher access. How do I diagnose this problem further?

steveking123 commented 2 years ago

It turns out that IT had not set the permission properly. This is resolved.