Power BI Gateway Server Error - target principal name incorrect

[rgupta25]

Hello All,

I am having an issue in Power BI gateway connection to only SQL Server connections, it seems they appear as OFFLINE on the portal but on the back end the users are able to refresh their dataset, however this is the error I get when trying to fix and get the connection ONLINE: 

PBI PROD03 Gateway: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.

I can connect to the SQL database with the same credentials locally via SSMS. This issue just started today and I am not sure of the fix, Please help!!!!

Thanks,
Renu

[SaiTejaTalasila]

Hi @rgupta25 ,

Please refer this -

https://medium.com/microsoft-power-bi/resolving-the-sql-server-ssl-certificate-error-in-power-bi-60c...

https://community.fabric.microsoft.com/t5/Power-Query/certificate-chain-was-issued-by-an-authority-P...

I hope it will be helpful.

Thanks,

Sai Teja 

[Anonymous]

Thanks for lbendlin's concern about this issue.

Hi, @rgupta25 

First make sure that the server name provided in the connection string matches the name in the SSL certificate. If it does not match, you will need to update the connection string or reconfigure the certificate.Also make sure that SSL/TLS is enabled.

You can also see if you can fix the problem by editing the data source settings in Power BI Desktop.

Sometimes installing a new version of the gateway may also resolve the potential issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

I can connect to the SQL database with the same credentials locally via SSMS.

But - can you do that with encryption?

[rgupta25]

No in SSMS, I have to enable Trust server certificate and Enable Always Ecrypted, but not sure how to set these configurations on the Power BI On-premise gateway server. The server does not have SSMS installed on it. All our SQL server gateway connections show OFFLINE on the portal however, users are able to refresh their semantic model in Power BI service using those gateway connections, successfully.

Do you know where and how to set this configuration on the server?

Thanks,

Renu

[powerapps_tec]

Hello Renu,
We are facing the exact same problem as the one you describe, and the problem also started suddenly. Could you please share whether you were able to fix this issue? Did you have to install a new version of the gateway?
Many thanks.

[rgupta25]

You have to whitelist the sql servers in the config file.

[powerapps_tec]

Thank you, Renu. Yes, we discovered the solution, but thank you for following up.
I posted the details in another thread earlier this month.
https://community.fabric.microsoft.com/t5/Service/SQL-Server-connections-offline/m-p/4400437#M264758