Unable to connect to Database from UiPath

Help Activities
, ,
1

Hi Team,

Using “Connect to Database” activity in UiPath to connect to database.
Datasource: Microsoft SQL Server
DataProvider: .NET Framework Data Provider for SQL Server
Use Windows Authentication
On Test Connection receiving below error:

" A connection was successfully established with the server but then an error occurred during the login process.(provider: SSL Provider, error:0 - The received certificate has expired.)

2

Hi @poornima_sadasivan,

Welcome to UiPath Community!

The error message indicates that the SSL certificate used by the SQL Server has expired, and this is preventing the login process from completing successfully.

To resolve this issue, you will need to update the SSL certificate on the SQL Server.

To check the expiration date of the current SSL certificate by running the following query on the SQL Server: SELECT * FROM sys.dm_exec_connections WHERE session_id = @@SPID

3

Thank you for your response.

Is there a way to disable to SSL verification for now? since we are doing this on development environment