Introduction

Enabling TLS (Transport Layer Security) in SQL Server ensures encrypted communication between clients and the database engine, protecting sensitive data in transit.

Problem

Check if the server is using encrypted connections (TLS) and is controlled by a DBA.Maintenance.Configuration table

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_check_server_encrypted_connection.sql

Example

Based on

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/tls-1-2-support-microsoft-sql-server