Share via

How to add TLS/SSL Security to SQL Server

Amogh Sharma 45 Reputation points
2024-08-15T15:50:05+00:00

Hello,

I want to set up a secure TLS/SSL security on my Microsoft SQL Server to connect it with an online server. The server requires the CA certificate for this to be in Privacy-Enhanced Mail (PEM) format. I have tried making a self-signed certificate using Microsoft's Powershell Command but that did not work due to the certificate not having a non-exportable private key. If possible, I would like to know how I can create an appropriate CA certificate to enable TLS/SSL security on SQL Server and connect to the online server.

Any help is appreciated.

SQL Server Other
Accepted answer
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2024-08-15T21:10:28.83+00:00

    Here is an article how to create a self-signed certificate in PEM format and then convert it to PFX, written specifically in the context of SQL Server: https://codekabinett.com/rdumps.php?Lang=2&targetDoc=create-install-ssl-tls-certificate-sql-server

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Zahid Butt 961 Reputation points
    2024-08-15T17:29:57.94+00:00

    Hi,

    Please go through below link for instructions to create PEM file:

    https://knowledge.digicert.com/tutorials/create-pem-file-for-tls-ssl-certificate-installations

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.