distal-attribute
distal-attribute
distal-attribute
distal-attribute

Connect to MS-SQL using SSL

MrBW posted 4 months ago in General

How do you setup HeidiSQL to connect to MS-SQL using SSL.....the SSL boxes in HeidiSQL are disabled :-( I have a root certificate from Amazon I want to use connecting to my MS-SQL instance on AWS. I've imported the certificate into my Windows.

MrBW posted 4 months ago

ups...I found the page with command parameters in the help section. That's a good place to start :-P

MrBW posted 4 months ago

Hmm....cannot get it to work. Using this command:

"...\heidisql.exe" -d="SQLSrv1" --ssl=1 --sslcacertificate="c:\temp\rds-ca-2015-root.pem"

HeidiSQL does start and get connected but it seem the connection is not encrypted:

SELECT encrypt_option FROM sys.dm_exec_connections WHERE session_id = @@SPID

Return "FALSE" :-(

Any help?

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