Use the Powershell cmdlet New-SelfSignedCertificate
Warning: I only ever use this method for testing purposes – never use for Production environments. A typical test would be for SQL Server Network Encryption SSL Certificate Management
Encryption strategy should be part of a wider review of Database Security Countermeasures against hacker attacks
For more details check the Microsoft documentation but here are some notes on some of the parameters attached to the Powershell cmdlet – New-SelfSignedCertificate.
Read on to see how you can create the certificate and use it in SQL Server. Connections will complain (and rightfully so) about the self-signed certificate but you’ll be able to try functionality which requires a certificate in an environment in which you don’t have one available for whatever reason.