Fix SQL Server SSL Certificate Errors in Excel Power Query
Question details
The user needs to connect Excel Power Query to SQL Server when certificate validation fails during login.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- Connecting to a SQL Server database from Excel Power Query over an encrypted connection.
- Observed behavior
- The connection reaches SQL Server but login fails because the server certificate or its issuing chain is not trusted.
Record the full error message and the SQL Server name entered in Power Query. Ask your database administrator to check the certificate presented by that server.
Verify the SQL Server certificate and trust chain
Use this approach to restore a secure connection when the server certificate is untrusted or its chain is incomplete.
In Excel, open Data > Get Data > From Database > From SQL Server Database and check the server name you enter. Give that name to your database administrator so they can verify it matches the certificate.
Ask the database administrator to inspect the certificate configured for SQL Server and confirm that it is valid, unexpired, and issued for the server name used in Excel.
Ask the administrator to install the required intermediate certificates on the server and ensure the client computer trusts the issuing certificate authority. The administrator should follow your organization's certificate policies.
In Excel, return to Data > Get Data > From Database > From SQL Server Database, enter the server and database details, and try connecting again.

Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel file compatibility for an easy transition. It does not repair SQL Server certificate trust or the Excel Power Query connection.

Frequently Asked Questions
Why can Excel reach SQL Server but fail during login?
The network connection may succeed while certificate validation fails. An untrusted issuing authority, missing intermediate certificate, expired certificate, or server name mismatch can prevent the encrypted login from completing.
How do I check which server name Power Query uses?
In Excel, open Data > Get Data > From Database > From SQL Server Database and check the server name entered for the connection. Ask the administrator to confirm that it matches the server certificate.
Should I bypass certificate validation to connect?
If your connector offers that option, use it only for temporary testing. The permanent fix is to use a valid server certificate with a complete chain that the client trusts.
Who should install the missing certificates?
Ask your database or IT administrator to check the SQL Server certificate and its intermediate chain, and to configure client trust for the issuing authority according to your organization's policies.




