Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Microsoft SQL Server Connection Error in 2023 Server

HarishKhanna1
7 - Meteor

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

2 REPLIES 2
HarishKhanna1
7 - Meteor

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
17 - Castor
17 - Castor

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.

Screenshot 2025-04-09 113225.png

 

Best,

Fernando V.