cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Help please -- SSL Provider error / certificate has expired

Hi,

I'm receiving the below error message (I've hidden the DataSourcePath which was just the server,port;dbname).

The datasource is an on-premises SQL Server database. To test the user access I use SSMS to connect to the database and run a couple of queries. All works fine.

I have successfully added the SQL Server database to the On-Premises Data Gateway. So all looks like the refresh should work.

Why do I get the below error message?  What is it actaully telling me?  Do I need to add some sort of software to the Server where the On-Premises Data Gateway is installed.

Thanks in advance.

 

SSL.PNG

5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: Help please -- SSL Provider error / certificate has expired

Hi @Anonymous,

 

The error message suggests that there's a problem with the encryption configuration on the SQL Server. It might be just what the message says – that the server is configured with a certificate that has now expired. Or, it might be a different problem.

 

1. Please edit the data source setting in Power BI Desktop and disable encryption to republish the report in order to avoid this problem.

 

w2.PNG

 

2. Update the on-premise data gateway to the latest version.

3. If issue still persists, please share on-premise data gateway service log files (C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log) around the time error throws out with us. You can upload log files to your OneDrive and share the link here.

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gune01
Regular Visitor

Re: Help please -- SSL Provider error / certificate has expired

we had same issue,  we had a sql server certificate which expired and was not needed, 

powerbi was working using the default encryption option and stopped working after the cert expired, we republished

the powerbi dataset using unencrypted connection but gateway still tries to look for the certificate on this server

below is the snippet of log, 

we applied latest patch to gateway, 

restart gateway service 

recreated the powerbi data source , thinking it might be cached, 

 

still its looking for the certifcate that is expired and no longer on the server

 

 

-ba2c-fd7c1e21ae61 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2019-02-23T02:40:31.0335409Z DM.EnterpriseGateway c6ed21b5-4db9-4cfb-adef-61f003a642d1 591a386d-db71-3b57-2621-f9eb069c807c MGCC 80c5f97e-414d-4a9a-ba2c-fd7c1e21ae61 4331972A [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <pi><pi>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 received certificate has expired.)</pi></pi>

JakeInUK
Frequent Visitor

Re: Help please -- SSL Provider error / certificate has expired

I also had this problem. My workaround was to create an ODBC SQL connection instead; not ideal. It meant reconfiguring the Power BI model, but at least everything is refreshing again.

Highlighted
Anonymous
Not applicable

Re: Help please -- SSL Provider error / certificate has expired

Having someone just contribute to this post has prompted me to state the fix for my instance of the issue. In short, it was the SSL Certificate that had expired against the SQL Server. It took the DBA a while to suss what the problem was but once the SSL Certificate was renewed all was fine again (if my memory is correct).

JakeInUK
Frequent Visitor

Re: Help please -- SSL Provider error / certificate has expired

In my situation the expired SSL certificate had been removed (as the other connections were working), but the PowerBI gateway connection was still stating the error.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors