Unable to connect to SQL server

[ThomasWeppler]

Hi Power Bi community 
I have a virtual machine that I try to connect to an SQL database and I get this mistake.

Details: "Microsoft SQL: A connection was successfully esablished with the server, but then an error occurred during the login process. (Provider: SSL Provider, error: 0 - The certificate chain was issed by an authority that is not trusted.)"

I just don't know how I get my virtual mashine to trust the SQL database. Can anyone help me?
All help will be greatly appriciated.

[Anonymous · Accepted solution]

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

[ThomasWeppler]

I found a solution with the help of your comment and chat gpt.

[ThomasWeppler]

Thanks for the answer.
How do I add to the connection stringEncrypt=TrueTrustServerCertificate=True.

[Brunner_BI]

Is encryption turned on? Maybe try turning it off and see if it works then