cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vincent Frequent Visitor
Frequent Visitor

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.

8 REPLIES 8
v-huizhn-msft Super Contributor
Super Contributor

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

Hi @Vincent,

Please try and get date in Power BI desktop, if all things works fine in desktop. Maybe there are some problem in gateway. So update your gateway to the latest version and sign in again. If there is still an issue, I personally suggest you create a support ticket on the right bottom of page for better assistanceSmiley Happy.


Best Regards,
Angelia

Vincent Frequent Visitor
Frequent Visitor

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

Yes I have tried it the refresh from desktop is fine. And I just updated the gateway yesterday.

Vincent Frequent Visitor
Frequent Visitor

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

And I just checked I'm a pro user but the support link still give me the following message

 

 

powerbi.microsoft.com
You can't access this application
powerbi.microsoft.com needs permission to access resources in your organization that only an admin can grant. Please ask an admin to grant permission to this app before you can use it. 

v-huizhn-msft Super Contributor
Super Contributor

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

Hi @Vincent,

How do you open the support ticket? Please follow the steps below.

First, when you click "create a support ticket", you will get the page below.

1.PNG
Then, please search your issue and check if there are any similar threads.

2.PNG

Finally, on the botton, please create a new ticket.

3.png

Best Regards,
Angelia

Vincent Frequent Visitor
Frequent Visitor

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

BI access.JPG

 

 

 

 

 

Thanks for the reply but this is what I got. I do not see any where define what kind of privileges is needed.

v-huizhn-msft Super Contributor
Super Contributor

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

Hi @Vincent,

As the tag shows, you can open create support ticket for free if you have pro license. 

Best Regards,
Angelia

Vincent Frequent Visitor
Frequent Visitor

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

HI,

I understand you are trying to guide me though opening a ticket with a support.

The following is what I have tried.

 

I checked if I am a pro user

 

ProUser.JPG

 

 

 

 

 

And tried to open a ticket here

BISU.JPG

 

 

 

 

 

 

 

 

Once I clicked and try to login I got the following screen

per.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Am I not a pro user? Or there is something else I did wrong?

Highlighted
pari1234 Frequent Visitor
Frequent Visitor

gta v money hack

These cheats for ps3 and xbox gta v money hack can be used easily.