Enabling TLS 1.2 in a SQL server

Question

Hi all,

Is it possible to enable encryption -TLS 1.2- on a single database in a SQL server if there is more than one? We have a test database, and eventually, we want to enable encryption on the production database.

Thanks!

Quimso

Answer 1

TLS is used to encrypt the connection traffic, not the database. The client chooses to use it or not, but non TLS traffic can be disabled.

Sqlserver also supports encrypt at rest, where the database file itself is encrypted. There is also the encrypt in place for individual columns.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/security/transparent-data-encryption

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-enclaves-configure-encryption?view=sql-server-ver16

Answer 2

Hi Joaquin Alvarez •

As per my understanding from your question, it seems that you have multiple databases on a server with a TLS version below 1.2, and you want to test the functionality of TLS version 1.2 on a single database. In that case, you can follow these steps:

1. Create a new temporary server with TLS 1.2
2. Copy the specific database you want to test onto the new server.
3. Conduct the necessary tests and evaluate the functionality using TLS version 1.2 on the copied database.

By setting up this temporary server with TLS 1.2, you can isolate the testing to a single server/database and ensure compatibility with the desired TLS version.

Let us know if this help or if you have any further questions.

Thank you!

Answer 3

Hi Joaquin Alvarez ,

Also check it out here.

Configure SQL Server Database Engine for encrypting connections

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.