Client found response content type of '', but expected 'text/xml', While Creating Subscription in SSRS2008 R2

I am trying to Create a Subscription from a windows service and provided all authentication as Anonymous. Added the Web Reference of reporting service 2008 as 'http://ServerName:Port(80)/ReportServer/ReportService2005.asmx' and execution service as 'http://ServerName:Port(80)/ReportServer/ReportExecution2005.asmx'. I was getting the following error while executing the below code statement:

rs.CreateSubscription(reportPath, extSettings, desc, eventType, matchData, parameters);  

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.

I am running Microsoft SQL Server 2008 R2.  Please help.

April 27th, 2015 6:14am

Try below link and options:

Add ReportExecution2005.wsdl as a web reference to my project DLL file. This web reference is specific to SQL Server 2008.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/94606b94-252e-46bc-ba0b-fa3439c35b00/client-found-response-content-type-of-but-expected-textxml-the-request-failed-with-an-empty?forum=sqlreportingservices

In report manager, change properties of connection so instead of using Windows integrated security, use Credentials stored securely in the report server + Use as Windows credentials when connecting to the data source.

Free Windows Admin Tool Kit Click here and download it now
April 27th, 2015 6:41am

Hi PrabhatY,

According to your description, you want to create a subscription for a report with PowerShell.

In your scenario, please check if you could access the report server and create a subscription in report manager. Then you should make sure all parameters within CreateSubscription method are right. If issue persists, please try to use Fiddler to monitor local request and received response message. Please refer to this document to use this tool: Getting Started with Fiddler.

Reference:
ReportingService2005.CreateSubscription Method

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

April 28th, 2015 3:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics