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.
Connect to MS-SQL using SSL
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.