SSL Certificate response obtained from the servr ws not vald

Question

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.

Jefferson S. Motta · Answer

I already setup this, and I guess that the problem is in the IIS certificate.

Salman Beg · Answer

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,

Mansoor Mohammed · Answer

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?

Mansoor Mohammed · Answer

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 Mohammed · Answer

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

SSL Certificate response obtained from the servr ws not vald

Answers (5)