Secure connection to SQL Server can be enforced by different ways, e.g. forcing encryption by using ForceEncryption property under the Network Configuration in the server. But this setting will force all clients to use encryption and any client that is not able to use an encrypted connection will fail. If you need to connect to SQL Server You can take advantage of the two client settings, Force