SSL Certificate response obtained from the servr ws not vald

Mansoor Mohammed

6y2.4k

Hi Guys

I get this error when I try to hit the button, download wsdl.

I have file Name(.wsdl) stored in my "C" folder as mentioned.

My HttpConnection is also tested Sucessful.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mansoor Mohammed6y ago
Hi Jeff,

You mean, to export Certificate from the server where the services(usfireuatsvc.e-test.net/TestService.svc?wsdl) is hosted TO my local where I am running SSIS?
Jefferson S. Motta6y ago
I already setup this, and I guess that the problem is in the IIS certificate.
Mansoor Mohammed6y ago
Thank you Salman Bhai, but I still get the error

Would like to give you a brief explanation...

I went to Visual Studio -> Buisness Intelligence -> Create New Project

All i need to do is..

Extract the response from wsdl to mt SQL table, so I dragged WebServices Task, from the left, and ther in, General -> Http Connection -> I gave

https://usfireuatsvc.e-test.net/TestService.svc?wsdl
userId: admin
Passwrd: ****

Note: The url above is not the actual url, but works absolutely fine.

Upon hitting the Test Connection - button, I get the Msg test connection Succeeded.

Now in the General tab, I fill in the other info like wsdl files(pointing to the wsdl file I created)/ Override WSDL to true/Gave the Name and Description, then upon hit of Download WSDL button, I get the pop up msg as

SSL Certificate Response obtained from the server is not valid. Cannot Process the request

May be because my url end with .svc?wsdl and not with .asmx?wsdl
Mansoor Mohammed6y ago
I still get that error Salman Bhai, to tell you in brief

I went to Visual Studio -> Buisness Intelligence -> Create New Project

All i need to do is..

Extract the response from wsdl to mt SQL table, so I dragged WebServices Task, from the left, and ther in, General -> Http Connection -> I gave

https://usfireuatsvc.e-test.net/TestService.svc?wsdl
userId: admin
Passwrd: ****

Note: The url above is not the actual url, but works absolutely fine.

Upon hitting the Test Connection - button, I get the Msg test connection Succeeded.

Now in the General tab, I fill in the other info like wsdl files(pointing to the wsdl file I created)/ Override WSDL to true/Gave the Name and Description, then upon hit of Download WSDL button, I get the pop up msg as

SSL Certificate Response obtained from the server is not valid. Cannot Process the request
Salman Beg6y ago
Hi.
Can you please follow these links,

https://stackoverflow.com/questions/43495703/ssis-download-from-http-error-ssl-certification-response-obtained-from-server

https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/

Thanks,