mmajcica / DeploySsrs

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

Exception calling "CreateFolder" #54

Closed mywarhistory closed 3 years ago

mywarhistory commented 3 years ago

Exception calling "CreateFolder" with "3" argument(s): "The permissions granted to user '_Build' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOT\TFS12PRD_Build' are insufficient for performing this operation."

I have a TFS report structure structure with no folders in it. simple SSRS project inside the Visual Studio solution.

What is the proper settings in the config file?

I have a report server at /Reports/browse/ENGINEERING/Consultant%20Services

TFS REPO is WebsiteSolution/SSRSReportsProject/report1.rdl

<?xml version="1.0" encoding="utf-8"?> <Folder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="Root">

Browser Browser Content Manager

mywarhistory commented 3 years ago

solution to do folders and sub folders.

  <Folders>
    <Folder Name="ENGINEERING">
      <Folders>
        <Folder Name="Consultant Services">
                     <Reports>
                  <Report Name="Report1" Hidden="false" FileName="Report1.rdl" />
                </Reports>
        </Folder>
            </Folders>

    </Folder>
  </Folders>
alextfreitas commented 3 years ago

I'm having the same exact problem as described above. What is the solution?

mywarhistory commented 3 years ago

I'm having the same exact problem as described above. What is the solution?

you have to use folder structure that matches SSRS. It was very confusing to me as well.

e.g.

`<?xml version="1.0" encoding="utf-8"?> <Folder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="Root">

`

alextfreitas commented 3 years ago

Yes! I got it now. Thank you!