Virendra Wadekar


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




Re: Consuming secured webservice in SSRS

Virendra Wadekar


Can anybody help to guide on the changes required for achieving this

Virendra






Re: Consuming secured webservice in SSRS

Virendra Wadekar

Hi ,

Has anybody used the secured webservice successfull as data source in the SSRS

Any pointers to the above problem

Virendra






Re: Consuming secured webservice in SSRS

Virendra Wadekar

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