We strongly recommend configuring SQL Server Configuration
Manager to force all clients to connect securely.
- In SQL Server Configuration Manager, in the left pane, expand the SQL Server Network Configuration node.
-
Right-click the Protocols for [Instance Name] node below
the SQL Server Network Configuration node and then click
Properties.
The Protocols for MSSQLSERVER Properties dialog box is displayed.
-
On the Flags tab, set Force
Encryption to Yes.
-
Click OK
When prompted, restart the SQL Server.
-
To check the encryption status of an open connection, use an SQL client such as
Microsoft SQL Server Management Studio to run the
following statement while you are connected to the database.
SELECT encrypt_option, * FROM sys.dm_exec_connections