mmajcica / DeploySsrs

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

Deployment Error - insufficient permissions for Service Account #74

Closed chethann1981 closed 1 year ago

chethann1981 commented 3 years ago

Exception calling "CreateDataSource" with "5" argument(s): "System.Web.Services.Protocols.SoapException: The permissions granted to user 'ITOCSERVICES\hsp.crd.u.dbr.svc' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'ITOCSERVICES\hsp.crd.u.dbr.svc' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, String ParameterName, CatalogItem& ItemInfo) at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, CatalogItem& ItemInfo)"

chethann1981 commented 3 years ago

Please Guide

rsoeung commented 2 years ago

Checking 'Overwrite existing objects' in your 'Deploy SSRS' pipeline task tends to remove the account from SSRS website folders. It should only delete the objects you are deploying and not the account. This is probably a bug.