Hi @David Qin ，
To enable encryption to be used when a certificate has not been provisioned on the server, SQL Server Configuration Manager can be used to set both the
Force Protocol Encryption and the
Trust Server Certificate options. In this case, encryption will use a self-signed server certificate without validation if no verifiable certificate has been provisioned on the server.
You can try to enable TrustServerCertifiate (be set to true) in the client configuration,
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.