Forum Discussion
NandanHegde
2 years agoSuper User
Error via On Premises Data Gateway to SQL server
I have installed an On Premises gateway on a server. I am able to access the SQL Server from the server on which the gateway is installed and the PBIX/report development was done from the same serve...
- 2 years ago
Has nothing to do with the gateway. On the SQL server renew the expired certificates and then restart the SQL Server service.
lbendlin
2 years agoSuper User
Has nothing to do with the gateway. On the SQL server renew the expired certificates and then restart the SQL Server service.
- NandanHegde2 years agoSuper User
Hey lbendlin
Thank you for your response.
But my query was more on :
We were able to connect to the database via Powerbi desktop by disabling encrypt connection, so is there any similar setting across On Prem gateway set up/Powerbi service.
- lbendlin2 years agoSuper User
There is not. We had a ticket open with Microsoft on that topic, and they swatted it away. They have no interest in allowing unencrypted connections on the gateway.