Forum Discussion
Kudo CommanderSQL Server SSL Certificate Mismatch in Power BI Gateway – DM_GWPipeline_Gateway_InvalidConnectionCre
SQL Server SSL Certificate Mismatch in Power BI Gateway – DM_GWPipeline_Gateway_InvalidConnectionCredentials Error
Hi everyone,
I’m encountering a **"DM_GWPipeline_Gateway_InvalidConnectionCredentials"** error when trying to connect Power BI to an AWS RDS SQL Server instance. The full error message is below:
```
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.
```
Has anyone encountered a similar issue or have suggestions on how to fix this SSL certificate mismatch error? Any guidance would be appreciated!
Thanks in advance!
3 Replies
- lbendlin
Super User
You can choose to ignore that by modifying the gateway
On-premises data gateway September 2024 Release | Microsoft Power BI Blog | Microsoft Power BI
What a mess. Updating the SqlTrustedServers setting in the config is no option for us as we have tens if not hundreds of connections per gateway and manually having to keep track of SQL servers in a config file is a no go (and using wildcard entries aren't ideal either).
So this means our users will simply have to live with this refresh exception?
We are also seeing this exception for connections to Databricks since we upgraded the data gateway.
Received error payload from gateway service with ID 1397099: ODBC: <ccon>ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed.</ccon>.
