Forum Discussion
vindev
Sep 16, 2020Copper Contributor
MS Excel Error: “The certificate chain was issued by an authority that is not trusted”
I am getting below error with Excel files which is retreving data from SQL Server. DataSource.Error:Microsoft SQL: A connection was successfully established with the server, but then an error oc...
lmsparkle
Copper Contributor
for the DBA's searching, this was all fixed within excel, server/database permissions and certificates were not the issue.
DanielLanstone
May 03, 2024Copper Contributor
lmsparkle was it solved by one of the solution here or did the user have to do something else?
- lmsparkleMay 03, 2024Copper ContributorSolved by going into Power Query like in the solution from Micael_Carlsson.