Download SSRS Artifacts From Reporting Services

%3CLINGO-SUB%20id%3D%22lingo-sub-2792244%22%20slang%3D%22en-US%22%3EDownload%20SSRS%20Artifacts%20From%20Reporting%20Services%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792244%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20download%20the%20contens%20of%20our%20Reporting%20Services%20instance.%20I%20managed%20to%20find%20a%20very%20nifty%20PowerShell%20script%20which%20does%20just%20that.%20But%20for%20some%20reason%2C%20when%20running%20the%20script%20against%20one%20of%20our%20servers%2C%20I%20get%20an%20error%20message.%3C%2FP%3E%3CP%3EHere%20is%20the%20script%20I%20found%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powershell%22%3E%3CCODE%3E%23------------------------------------------------------%0A%23Prerequisites%0A%23Install-Module%20-Name%20ReportingServicesTools%0A%23------------------------------------------------------%0A%0A%23Lets%20get%20security%20on%20all%20folders%20in%20a%20single%20instance%0A%23------------------------------------------------------%0A%23Declare%20SSRS%20URI%0A%24sourceRsUri%20%3D%20%22http%3A%2F%2Fhqmnbi%2FReportServer_sql08%2FReportService2010.asmx%3Fwsdl%22%0A%0A%23Declare%20Proxy%20so%20we%20dont%20need%20to%20connect%20with%20every%20command%0A%24proxy%20%3D%20New-RsWebServiceProxy%20-ReportServerUri%20%24sourceRsUri%0A%0A%23Output%20ALL%20Catalog%20items%20to%20file%20system%0AOut-RsFolderContent%20-Proxy%20%24proxy%20-RsFolder%20%2F%20-Destination%20'C%3A%5CUsers%5Carobinson%5Csource%5CWorkspaces%5CEDW%5CMAIN%5CSSRS%5CHQMNBI'%20-Recurse%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20run%20this%20script%20against%20two%20of%20our%20Reporting%20Services%20servers%2C%20everythin%20works%20fine.%20But%20when%20it's%20run%20against%20the%20server%20above%2C%20I%20get%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powershell%22%3E%3CCODE%3EFailed%20to%20establish%20proxy%20connection%20to%20http%3A%2F%2Fhqmnbi%2FReportServer_sql08%2FReportService2010.asmx%20%3A%20The%20HTML%20document%20does%20not%20contain%20%0AWeb%20service%20discovery%20information.%0AAt%20C%3A%5CProgram%20Files%5CWindowsPowerShell%5CModules%5CReportingServicesTools%5C0.0.6.6%5CFunctions%5CUtilities%5CNew-RsWebServiceProxy.ps1%3A136%20char%3A9%0A%2B%20%20%20%20%20%20%20%20%20throw%20(New-Object%20System.Exception(%22Failed%20to%20establish%20proxy%20...%0A%2B%20%20%20%20%20%20%20%20%20~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~%0A%20%20%20%20%2B%20CategoryInfo%20%20%20%20%20%20%20%20%20%20%3A%20OperationStopped%3A%20(%3A)%20%5B%5D%2C%20Exception%0A%20%20%20%20%2B%20FullyQualifiedErrorId%20%3A%20Failed%20to%20establish%20proxy%20connection%20to%20http%3A%2F%2Fhqmnbi%2FReportServer_sql08%2FReportService2010.asmx%20%3A%20The%20%20%0A%20%20%20HTML%20document%20does%20not%20contain%20Web%20service%20discovery%20information.%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20every%20permutation%20and%20still%20can't%20ge%20**bleep**%20to%20run%3A%20I've%20used%20ReportService2010%2C%20ReportService2005%2C%20I've%20tried%20both%20with%20and%20without%20the%20%3Fwsdl%2C%20and%20none%20of%20them%20work%20-%20same%20error%20gets%20thrown.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20bit%20more%20information%2C%20the%20server%20SSRS%20is%20on%20is%20a%20Windows%20Server%202008%20server%20and%20it's%20running%20SSRS%202008%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20or%20insight%20anyone%20could%20provide%20would%20be%20great!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2792244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%20PowerShell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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!!

0 Replies