title: Block unencrypted connection to SQL Server via ODBC
body: <p>I recently enabled the encrypted connection to one of my SQL Server instances. I have software that DSN ODBC must connect to this instance.</p>
  <p>The database is on a W10 PC while the client is a W11 PC.</p>
  <p>I would like the data that the client sends to the server and the server sent to the client to be encrypted. Following the official Microsoft guide (I leave the link below) I managed to configure the connection but I saw that if I create a new ODBC connection without activating the &quot;use strong encryption for data&quot; flag I can still read and write data to the Database. In my opinion it makes no sense, then anyone could connect to the database, even without having the certificate.</p>
  <p>How can I prevent / block connection to the database from a PC that does not have the certificate installed?</p>
  <p><a href="https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?redirectedfrom=MSDN&amp;view=sql-server-ver16" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?redirectedfrom=MSDN&amp;view=sql-server-ver16</a></p>