Error connected to SQL Server using PBI Report Server

[Anonymous]

Hi,

I've tried using windows account, org account and the database account but it still does not want to connect.

Very frustrating.

Details: "Microsoft SQL: 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.)"

[v-jayw-msft]

Hi @Anonymous ,

I found a post with same problem with you.

https://community.powerbi.com/t5/Issues/Gateway-SSL-Provider-error-0-The-received-certificate-has/idi-p/755598

Please try the following steps and let us know if this helps in resolving the issue with the SQL server connector refresh in Power BI :

1. Please login to the machine where sql server is running

2. Open SQL Server Configuration Manager

3. navigate to SQL Server Network Configuration and expand it to see "Protocols for MSSQLSERVER"

4. Right click on Protocols for MSSQLSERVER" and go to properties 

5. click on certificates.

6. open the drop down to verify if the correct certificate is selected or not. If no certificate is selected please select desired certificate.

7. If you do not want to use any certificate, then leave it empty and move forward with rest of the steps.

8. Make a note of the name and thumbprint of the certificate that is supposed to be used. (step 9 is not applicable is you do not want to use any certificate)

9. Now go to registry editor and navigate to the path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.<INSTANCENAME>\MSSQLServer\SuperSocketNetLib

10. double click on Certificate 

11. See the field "Value data". This shows the thumbprint of the certificate. Validate this with the one collected in step # 7. It should be same.

12. If it is different just clear the data in the field named "Value data:" and click ok. If no certificate is used, then ensure that field is empty. If you see some value clear the contents and click on ok.

13. Restart the sqlserver process so that the changes can be picked up. Restart it at your convenience if the server is production server/critical environment and verify if the refresh issue is fixed .

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Just Check you Server is SSL enabled

Or refer these

https://blog.greglow.com/2020/01/16/sql-sql-server-the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted/

https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-Only/td-p/359157

[Anonymous]

Thanks for the help.

The problem was my database name was case-sensitive. Instead of Database, it was supposed to be typed as DataBase.