Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Error connected to SQL Server using PBI Report Server

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.)"

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Anonymous
Not applicable

Thanks for the help.

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.