Cannot connect to deskstop in sql serve

Question

I cannot connect to desktop, so help me fix this error

Answer 1

Make sure that you have the most recent version of SSMS installed.

The newest versions of SQL Server adds some security-related options on the front-page. For a connection to SQL Server you can select Optional for encryption. You can also check Trust Server Certificate.

None of these options are recommendable in a production environment where you are connecting to a server on the network, least of all if you work with sensitive data.

Answer 2

Hi,

It seems you intentionally use either a certificate from a non-trusted authority or a self-signed certificate to encrypt connections to SQL Server.  Please try below suggestions to resolve your issue.

In SSMS, please select the Options tab in the Connect properties window, and then select the Trust server certificate option.

 

If it is not work, please add the certificate authority to the Trusted Root Certification Authorities store on the client computer, please refer to this MS document The certificate received from the remote server was issued by an untrusted certificate authority" error when you connect to SQL Server to get detail steps.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Answer 3

duplicate reply.