Forum Discussion
The server name provided doesn't match the server name on the SQL Server SSL certificate.
Hi all, can You help me with the next issue? When I refresh data from PowerBI.com using the On-Premises Gateway appears the next message: The server name provided doesn't match the server name on the SQL Server SSL certificate.)
I have reinstalled the On-Premises Gateway, reboot SQL services, but message continues appear
Best regards
Anonymous See this thread you may need to use the Fully Qualified Domain Name. This error indicates to me that this is just a wrong connection string as opposed to something wrong with the gateway setup.
5 Replies
Anonymous See this thread you may need to use the Fully Qualified Domain Name. This error indicates to me that this is just a wrong connection string as opposed to something wrong with the gateway setup.
Thank for your response, I have installed ADO.NET and set in PowerBI.com SERVERNAME.contoso.com\DBInstance as server name in gateway connection all good but when I want to set that DataSource to refresh data in Gateway connection, doesn't appears, I need to reinstall the on-premises gateway?
Best regards
To resolve the SSL certificate error in Power BI, create an environment variable PBI_SQL_TRUSTED_SERVERS with your SQL Server's name, then restart Power BI. This bypasses the server name mismatch issue.
Refer to the article
