Help please -- SSL Provider error / certificate has expired

Question

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?&nbsp; What is it actaully telling me?&nbsp; Do I need to add some sort of software to the Server where the On-Premises Data Gateway is installed.Thanks in advance.&nbsp;

v-qiuyu-msft · Answer

Hi Anonymous,
&nbsp;
The error message suggests that&nbsp;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.
&nbsp;
1. Please edit the data source setting in Power BI Desktop and disable encryption to republish the report&nbsp;in order to avoid this problem.
&nbsp;

&nbsp;
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&nbsp;the link here.
&nbsp;
Best Regards,QiuyunYu

anonymous · Answer

we had same issue,&nbsp; we had a sql server certificate which expired and was not needed,&nbsp;powerbi was working using the default encryption option and stopped working after the cert expired, we republishedthe powerbi dataset using unencrypted connection but gateway still tries to look for the certificate on this serverbelow is the snippet of log,&nbsp;we applied latest patch to gateway,&nbsp;restart gateway service&nbsp;recreated the powerbi data source , thinking it might be cached,&nbsp;&nbsp;still its looking for the certifcate that is expired and no longer on the server&nbsp;&nbsp;-ba2c-fd7c1e21ae61 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = &lt;pi&gt;-2147467259&lt;/pi&gt;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 = &lt;pi&gt;&lt;pi&gt;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.)&lt;/pi&gt;&lt;/pi&gt;

jakeinuk · Answer

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.

anonymous · Answer

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&nbsp;but once the SSL Certificate was renewed all was fine again (if my memory is correct).

jakeinuk · Answer

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.

Forum Discussion

Help please -- SSL Provider error / certificate has expired

7 Replies

Related content

certification

TOKEN EXPIRED

SQL Connection Error: received certificate has expired

Certifications

Power BI Connector Certification