Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
In both power bi service and desktop we can connect successfully to Azure sql database using the FQDN
<db_name>.privatelink.database.windows.net
when we use an unencrypted connection.
However, when we set the connection to encrypted get the error that the server name provided does not match the server name on the sql server SSL certificate.
How can we best resolve this to ensure can use encryption?
Thanks
Hi,
Thanks for reply.
We are using the FQDN but still get error.
Hi,
Thanks for suggestion.
However, we are using the FQDN when connect via power bi desktop and service but still get this error.
Is there a way to check the FQDN on the server SSL certificate in Azure and if necessary chnage it so has privatelink within it?
We can connect using below but cannot use encrypted connection due to this.
<db_name>.privatelink.database.windows.net
Hi, @po
Error: The server name provided doesn't match the server name on the SQL Server SSL certificate.
This error can occur when the certificate common name is for the server's fully qualified domain name (FQDN), but you supplied only the NetBIOS name for the server. This situation causes a mismatch for the certificate. To resolve this issue, make the server name within the gateway data source and the PBIX file use the FQDN of the server.
Troubleshoot gateways - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.