Microsoft SQL Server Connection Error in 2023 Server

[HarishKhanna1]

Hi , I am getting below error while connecting to a SQL server database via ODBC connection.
I have verified that database access & firewall accesses are present.
Any help would be greatly appreciated !

Error SQLDriverConnect: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECDoClientHandshake()).[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

[HarishKhanna1]

When I changed the driver to Native Client 11.0 I got a different error message.

Error SQLDriverConnect: [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host. [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection

[fmvizcaino]

Hi @HarishKhanna1 ,

The SSL error is probably related to the encryption of the connection. I suggest downloading the ODBC driver 17 or 18 and adjusting this part below.

Best,

Fernando V.