If you have a SQL Server that is accessible in anyway outside your network you really should ensure that connections to it are encrypted. In this article I will do my best to give a comprehensive guide on how to configure SQL Server 2017 to use free certificates from Let’s Encrypt.
Be warned, this is not going to be an easy process and this article will be very heavy on technical detail some of which I may not fully understand myself – I’m a software developer doing my best to look like a sys admin.
I know this has been done before though based on two posts on the subject, one by Daniel Hutmacher and the other by Jan Pieter Posthuma. I am eternally grateful to them for their help and I hope they don’t mind me borrowing and adapting what they have done. Why write my own article if two already exist? Daniel covered this subject back in 2017 and things have moved on a bit since then, his article was an excellent starting point for me though.Continue reading