Forum Discussion
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...
This was the solution of my problem with excelconnection to SQL Server:
http://www.thesqlreport.com/?p=2050
Micael_Carlsson This solved my problem, Thanks
- for the DBA's searching, this was all fixed within excel, server/database permissions and certificates were not the issue.
lmsparkle was it solved by one of the solution here or did the user have to do something else?
- Solved by going into Power Query like in the solution from Micael_Carlsson.
