topic Re: How to turn off SSL checking for connecting via API with on premise database in Product Forum

How to turn off SSL checking for connecting via API with on premise database

Onefamily_Simon — Thu, 11 Mar 2021 12:53:41 GMT

Hi,

This question comes from my I.S. department who have been assisting me in setting up a API connection to on premise database to help with a Blue Prism process I am building.

They want to know if there is a way of turning off SSL checking within Blue Prism, or with a single Blue Prism API service?

If someone knows about this or could point me to the relevant guide that explains how he could enable this, that would be great.

thanks
Simon

Re: How to turn off SSL checking for connecting via API with on premise database

ewilson — Thu, 11 Mar 2021 15:24:51 GMT

@Onefamily_Simon,

Check out this VBO on the DX. It may be what you're looking for.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/disable-certificate-vbo

In a nutshell, the only way to disable certificate checking for web requests is via a code stage. This VBO does it for you.

Cheers,

Re: How to turn off SSL checking for connecting via API with on premise database

bruce.liu — Thu, 11 Mar 2021 23:01:57 GMT

Hi Simon,

There is no way to disable the SSL checking via Web API Services. As Eric has said, VBO is the only option you have. If VBO is not an option, you must discuss with your IT department in getting this to work for your runtime resources where the web service calls are being made.

Check the below URL if you wish to get more information on this topic via code stages.
http://stackoverflow.com/questions/22627977/the-underlying-connection-was-closed-an-unexpected-error-occurred-on-a-send-w

As I have found out, it essentially involves adding the following line (VB.NET) before sending out your web request.

System.Net.ServicePointManager.SecurityProtocol = Net.SecurityProtocolType.Tls12