Azure the server name provided does not match the server name on the sql server SSL certificate

[po]

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

[po]

Hi,

Thanks for reply.

We are using the FQDN but still get error.

[po]

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

[v-zhangti]

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.