0

I tried to download documents in bulk from a SSRS 2019 server by following this stackoverflow thread.

Unfortunately I do not have sufficient permissions as can be seen from the prompt below:

Failed to retrieve item definition of '/directory' from proxy: Exception calling "GetItemDefinition" with "1" argument(s): "The permissions granted to user 'domain\username' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\username' are insufficient for performing this operation." At C:\Program
Files\WindowsPowerShell\Modules\ReportingServicesTools\0.0.7.2\Functions\CatalogItems\Out-RsCatalogItem.ps1:117 char:17
+ ...             throw (New-Object System.Exception("Failed to retrieve it ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (:) [], Exception
    + FullyQualifiedErrorId : Failed to retrieve item definition of '/directory' from proxy:  exception calling "GetItemDefinition" with "1" argument(s): "The permissions granted to user 'domain\user' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\user' are insufficient for performing this operation.

I have tried many of the proposed solutions on stackoverflow such as here, here and here. However, due to my permission level the properties tab and security tab are missing, the settings option itself is greyed out, all can be seen below: Overall bar Settings

When I try to enter http:domain/reports/manage/security/browse it prompts: User prompt

And also when I try to go to http:domain/reports/manage/site/general it prompts: Lack of security settings

However, I do have access to quite some reports present in the ReportServer overview, but not all it seems.

  1. How can I specifically download the files i do have access to with Windows PS without getting the user access prompt as shown earlier which followed after: 
    Out-RsFolderContent -Proxy $proxy -RsFolder / -Destination 'C:\SSRS_Out' -Recurse
  2. Is there any method to circumvent access permissions to download all SSRS server files without having access to any admin account?
Rivered
  • 741
  • 7
  • 27
  • Do you have any access to the SQL Server DB? You could query and export there if so. Otherwise, you can try using specific folder paths with `Out-RsFolderContent -RsFolder /My/Folder`. The web service url (not Report *Manager* URL) should give you a list of everything available to your user: e.g. http://server/ReportServer – Cpt.Whale Aug 25 '22 at 16:36
  • I do not have direct access to the SQL server DB. in the ReportServer there are three main folders visible, running code shown in question returns all folders but no files, running specific folder prompts: ```Failed to retrieve items in '/My/Folder/': Exception calling "ListChildren" with "2" argument(s): "The path of the item '/My/Folder/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. --->``` This still returns all subfolders but no files in them – Rivered Aug 26 '22 at 09:29
  • I know the SQL server name and IP domain, is it perhaps possible to connect directly to the SQL database through bash? – Rivered Sep 02 '22 at 09:42
  • **IF** you have permission to connect, then `sqlcmd` is probably the simplest way. For example: `sqlcmd -S server01 -Q "SELECT name FROM master.sys.databases"`. It is a microsoft tool: https://learn.microsoft.com/en-us/sql/tools/sqlcmd-utility . It sounds like you may need to contact whoever manages SSRS to give you permissions though – Cpt.Whale Sep 02 '22 at 15:49

0 Answers0