Sep 28 2021 09:02 AM - edited Sep 29 2021 06:11 AM
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!!
Jan 30 2022 03:18 AM