I can connect with "Encrypt connection" if I'm connecting locally, I can connect without "Encrypt connection" remotely, but I can't connect remotely with "Encrypt connection" checked.
The error that I get from ssms: "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - No such host is known.) (Microsoft SQL Server, Error: 11001)
My host just sent me a certificate, I added the certificate both to the Trusted root CA and Trusted publishes.
Any help will be appreciated, thank you.