Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Connect to MS-SQL using SSL

5 posts
MrBW's profile image MrBW posted 5 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.

5 posts
MrBW's profile image MrBW posted 5 years ago Permalink

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

5 posts
MrBW's profile image MrBW posted 5 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.