Version 4 of
Microsoft. includes a breaking change which sets
Encrypt=True by default. If the client and server are not configured with a valid certificate, this can cause an exception at startup:
Message=A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
Source=.Net SqlClient Data Provider
It is not recommended to eliminate this warning by adding
TrustServerCertificate=True to the connection string. Both of these options leave the endpoint unsecure.