0

Im getting the below error while logging into the database.By default only "Encrpt connection" is checked .

error

In this case should I need to uncheck "Encrypt connection" and "trust server certificate" Or should I need to check "Encrypt connection" and "trust server certificate" For production.

connection properties

1 Answer 1

0

I believe this happens when your SSL certificate for the SQL Server machine is not setup properly.

You should be able to workaround it by checking off the "Trust server connection" property for the SSMS connection. (This only affects your specific connection with SSMS.)

Whoever manages the SSL certs should ultimately fix whatever the root issue is, which these Microsoft docs might help with: The certificate received from the remote server was issued by an untrusted certificate authority error when you connect to SQL Server

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.