Download SSRS Artifacts From Reporting Services

Copper Contributor

I am trying to download the contens of our Reporting Services instance. I managed to find a very nifty PowerShell script which does just that. But for some reason, when running the script against one of our servers, I get an error message.

Here is the script I found:

 

#------------------------------------------------------
#Prerequisites
#Install-Module -Name ReportingServicesTools
#------------------------------------------------------

#Lets get security on all folders in a single instance
#------------------------------------------------------
#Declare SSRS URI
$sourceRsUri = "http://hqmnbi/ReportServer_sql08/ReportService2010.asmx?wsdl"

#Declare Proxy so we dont need to connect with every command
$proxy = New-RsWebServiceProxy -ReportServerUri $sourceRsUri

#Output ALL Catalog items to file system
Out-RsFolderContent -Proxy $proxy -RsFolder / -Destination 'C:\Users\arobinson\source\Workspaces\EDW\MAIN\SSRS\HQMNBI' -Recurse

 

 

When I run this script against two of our Reporting Services servers, everythin works fine. But when it's run against the server above, I get the following:

 

 

Failed to establish proxy connection to http://hqmnbi/ReportServer_sql08/ReportService2010.asmx : The HTML document does not contain 
Web service discovery information.
At C:\Program Files\WindowsPowerShell\Modules\ReportingServicesTools\0.0.6.6\Functions\Utilities\New-RsWebServiceProxy.ps1:136 char:9
+         throw (New-Object System.Exception("Failed to establish proxy ...
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (:) [], Exception
    + FullyQualifiedErrorId : Failed to establish proxy connection to http://hqmnbi/ReportServer_sql08/ReportService2010.asmx : The  
   HTML document does not contain Web service discovery information.

 

 

I've tried every permutation and still can't get it  to run: I've used ReportService2010, ReportService2005, I've tried both with and without the ?wsdl, and none of them work - same error gets thrown.

 

A bit more information, the server SSRS is on is a Windows Server 2008 server and it's running SSRS 2008 as well.

 

Any assistance or insight anyone could provide would be great!

 

Thanks!!

2 Replies