Forum Discussion
Server Name provided does not match the server name on the SQL Server SSL Certificate
From PowerBi Desktop, when connecting to a SQL Server using the servers FQDN and using either Windows Authentiation or Microsoft Account (with Microsoft Account being our perfered method), we get the error "Server Name provided does not match the server name on the SQL Server SSL Certificate". We are not using any kind of SQL Server encryption and I have confirmed that this is not enabled in PBI Desktop. Ultimitally we want to use the "Microsoft Account" authentication and Powerbi will not allow us to bypass this error when signed in with the Microsoft Account.
Why am I getting this error and what needs to be done to get rid of it.
4 Replies
Anonymous , refer if this can help to solve
Hi Anonymous
I find some posts with similar issue like yours. I hope they can help you solve your problem.
For reference: The server name provided doesn't match the server name on the SQL Server SSL certificate.
Need help connecting Microsoft SQL Server to Microsoft Power BI
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
