Forum Discussion
Solved
Certificate Chain Not Trusted Error Effecting PowerBI Only
Hi, In a SQL query that I have run several times before I am not receiving the following error: Message=A connection was successfully established with the server, but then an error occurred ...
This ended up being a fairly easy solution, in order to work around this issue I ended up just having to switch the connection type from MSFT account to Windows for any who encounter this issue in the future.
Issue:
This issue occurs due to mismatches between the versions of Power BI and SQL Server. To resolve it, please follow the steps below, how to install SSL Certificate from your local machine which is available from sql server installed machine.
Steps to Resolve:
Export the Certificate:
- On the server where SQL Server is installed, open MMC (Microsoft Management Console).
- Load the Certificates snap-in for the Computer account.
- Navigate to the certificate being used for SQL Server (typically found under Personal > Certificates).
- Right-click the certificate and select All Tasks > Export.
- Export the certificate without the private key in .cer format.
Install the Certificate on the Client:
- Copy the exported .cer file to the client machine.
- On the client machine, open MMC and add the Certificates snap-in for the Computer account.
- Import the .cer file into the Trusted Root Certification Authorities store.
Restart SQL Server Service:
- After the certificate is trusted, restart your SQL Server service and retry the connection.