Cannot connect to SQL Server (TCP/IP) with SSL

[expired user #11742]'s profile image [expired user #11742] posted 6 years ago in Creating a connection Permalink

Hello HeidiSQL community,

I've been using HeidiSQL to connect to a SQL server until a few months, for security reasons we needed to disable non-SSL connections, so now when trying to connect to database via TCP/IP I'm getting the following error

Error de SQL (18): [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]Error de seguridad de SSL Error de seguridad de SSL.

(Translated)

SQL Error (18): [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error SSL Security error.

There is a "Use SSL" option in "Advanced" tab, but it's greyed out, only available with mysql

I would like to know how to connect to sql server databases again with HeidiSQL, meanwhile I'm using sql management studio but used to work with HeidiSQL I prefer it much better, by far.

Thanks for your help

[expired user #11749]'s profile image [expired user #11749] posted 6 years ago Permalink

This is the best way to communicate the fact about the particular aspects which is going to provide the fact about the SQL database for the server which is going to provide the part.

Please login to leave a reply, or register at first.