Status:
New
Gateway SSL Provider, error 0 – The received certificate has expired
Is there a way to disable ’encrypt connections’ when doing a data refresh through the On-Premise Data Gateway? Our users have developed a report to a SQL server database that does not have encryp...
Microsoft gave us some intresting info on this ...
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 :
- Please login to the machine where sql server is running
- Open SQL Server Configuration Manager
- navigate to SQL Server Network Configuration and expand it to see "Protocols for MSSQLSERVER"
- Right click on Protocols for MSSQLSERVER" and go to properties
- click on certificates.
- open the drop down to verify if the correct certificate is selected or not. If no certificate is selected please select desired certificate.
- If you do not want to use any certificate, then leave it empty and move forward with rest of the steps.
- 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)
- Now go to registry editor and navigate to the path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.<INSTANCENAME>\MSSQLServer\SuperSocketNetLib
- double click on Certificate
- 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.
- 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.
- 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 .