The “Encrypt connection” needs to be checked and an additional parameter “TrustServerCertificate” set to “True” needs to be added to the connection properties.
Perform the steps below to make the required changes:
- Right-click on SQL Server connection | Properties.
- Under the Login tab, enter the required information and ‘check’ the Encrypt connection.
- Under the Advanced tab, add the parameters “TrustServerCertificate” to “True” and hit Enter.
- Save the connection information and connect again to the instance.
