Hi @ThomasWeppler ,
The error message you’re seeing is related to the SSL certificate of the SQL Server.
It seems that the certificate chain was issued by an authority that is not trusted.
If you have in the connection string, you can either set that to off (not recommended), or add to the connection stringEncrypt=TrueTrustServerCertificate=True. This will tell the connection to trust the certificate presented by SQL Server without further verification.
Original post:
"The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role...
You may also try to install a Trusted Certificate, install a CA-signed certificate in your SQL VM’s trusted root store. SQL Server will create a self-signed certificate if you don’t install one for it to use, but it won’t be trusted by the caller since it’s not CA-signed.
The certificate chain was issued by an authority that isn't trusted - SQL Server | Microsoft Learn
Further more,you can configure SQL Server to use the certificates. Depending on the version of SQL Server Configuration Manager you have access to on the SQL Server computer, use one of the following procedures to install and configure the SQL Server instance.
Configure SQL Server Database Engine for encryption - SQL Server | Microsoft Learn
Best regards.
Community Support Team_Caitlyn
