Connect to MS-SQL using SSL

[expired user #9542]'s profile image [expired user #9542] posted 7 years ago in General Permalink

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.

[expired user #9542]'s profile image [expired user #9542] posted 7 years ago Permalink

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

[expired user #9542]'s profile image [expired user #9542] posted 7 years ago Permalink

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.