Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

The server name provided doesn't match the server name on the SQL Server SSL certificate.

My BI reports on app.powerbi.com was working properly for months already and couple days ago I started reciving following message when I try to refresh the data.

Underlying error code:-2147467259
Underlying error message:The server name provided doesn't match the server name on the SQL Server SSL certificate. Please see https://go.microsoft.com/fwlink/?LinkId=394782. (Source at myserver;myDB.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:SQL
Microsoft.Data.Mashup.CredentialError.DataSourcePath:myserver;myDB
Microsoft.Data.Mashup.CredentialError.Reason:PrincipleNameMismatch
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"SQL","path":"myserver;myDB"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:PrincipleNameMismatch
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:40b8a79a-a35f-5305-6380-808484631ca5
Request ID:268f6c8c-6bf9-61b0-5428-1bdfb8faa452
Time:2017-09-14 16:42:26Z

I see in Gateway management the connection is successful

 

I checked some of other silmiar issue and suggested use FQDN and SQL configuration.

But we did not make any change recently.

Status: New
Comments
v-haibl-msft
Employee

@Vincent

 

Please try to add SSL certs in machines. If you have already done that. You can also try to use the Fully Qualified Domain Name in Gateway configuration in Power BI Service and in the Source configuration in Power BI Desktop.

 

BTW, the on-premises data gateway September update is already available here.

 

If issue still persists, I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).

 

Support Ticket.gif

 

Best Regards,
Herbert

Vincent
Regular Visitor

 Hi, 

Thanks for the reply.

 

We never had SSL certs in this server, and it just stopped working one day. I checked the query in BI desktop and see FQDN is used. 

 

See the updated and updated it and restarted the gateway service.

Still having the same issue.

 

I tried to use support ticket but was denial of access as below

 

 
You can't access this application

 

I have checked that i'm indeed using a pro user account. Is there some other requirment to submit a support ticket?

v-haibl-msft
Employee

@Vincent

 

If you are a using a pro account, you should be able to open support ticket as above gif with no problem. Based on the message you get, maybe you need to contact with your O365 admin to see if they can grant permission to you.

 

Best Regards,
Herbert

Vincent
Regular Visitor

@v-haibl-msft

Thanks for the response.

Can you specifiy what kind of permission they should be looking for?

Koumos
New Member

Hello all,

 

I meet the same problem. I am a Pro Power BI User, Admin on O365 and i use Admin rights on the Server under the On-premise Gateway and SQL Server!!!

 

Check it guys!!!