Forum Discussion
Unable to connect to SQL server
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.
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:
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
4 Replies
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:
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_CaitlynThanks for the answer.
How do I add to the connection stringEncrypt=TrueTrustServerCertificate=True.I found a solution with the help of your comment and chat gpt.
Is encryption turned on? Maybe try turning it off and see if it works then
