Allow only encrypted connections.

• krypto69

  SSChampion

  Points: 13604

  More actions

  May 25, 2023 at 2:57 pm

  #4197394

  Hi

  In SQL22, Is there a way to allow only / force encrypted connections?

  I have 'force encryption' on and have cert installed:

  

   

  But when I connect via SSMS I can unselect ' Encrypt Connection' and it connects. My understanding is that means that it is allowing non-encrypted connections:

  

  How do I make my SQL server not support non-encrypted traffic?

  If I run:

  USE [master]

  GO

  SELECT DISTINCT (encrypt_option)

  FROM sys.dm_exec_connections;

  GO

   

  I get:

  encrypt_option

  FALSE

  TRUE

  • This topic was modified 2 years ago by krypto69.
  • This topic was modified 2 years ago by krypto69.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  Follow

  May 26, 2023 at 3:10 pm

  #4198225

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• andreas.kreuzberg

  SSCertifiable

  Points: 6202

  More actions

  May 31, 2023 at 10:37 am

  #4201384

  Hi,

  is the SSMS on the same server like the sql server?

  And what kind of protocols are active on the sql server?