Hi All,
We have a webservice, which we are able to consume in the SSRS report.
Due to some requirement, we need to conver this webservice in to the secured webservice using the SSL https extension.
We did this and just changed the connection string from http to https.
But when we try to run the report, we get the following error message. Copied from BIDS.
TITLE: Microsoft Report Designer
An error occurred while executing the query.
Failed to prepare web request for the specified URL.
ADDITIONAL INFORMATION:
Failed to prepare web request for the specified URL. (Microsoft.ReportingServices.DataExtensions)
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System)
The remote certificate is invalid according to the validation procedure. (System)
BUTTONS:
OK
Can anybody help in this.
Thanks in advance.
Virendra
Can anybody help to guide on the changes required for achieving this?
Virendra
|||Hi ,
Has anybody used the secured webservice successfull as data source in the SSRS?
Any pointers to the above problem?
Virendra
|||Hi All (looking at this post),
The problem is resolved. It was a trivial mistake done on my side. The "Windows Authentication" was enabled on the web service and the properties of the data source were set to No credentials in SSRS. After resolving this, it started working.
Virendra
No comments:
Post a Comment