#StackBounty: #excel #postgresql #certificate Excel2016: Cannot query PostgresSQL database: Server certificate not accepted

Bounty: 50

I want to import some data to Excel2016 from a postgresSQL table. I have tried it by clicking “new query” and selecting From Database -> From PostgresSQL Database:

enter image description here

But then I receive the following error:

Details: “TlsClientStream.ClientAlertException: CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.
. The specified hostname was not present in the certificate.
at TlsClientStream.TlsClientStream.ParseCertificateMessage(Byte[] buf, Int32& pos)
at TlsClientStream.TlsClientStream.TraverseHandshakeMessages()
at TlsClientStream.TlsClientStream.GetInitialHandshakeMessages(Boolean allowApplicationData)
at TlsClientStream.TlsClientStream.PerformInitialHandshake(String hostName, X509CertificateCollection clientCertificates, RemoteCertificateValidationCallback remoteCertificateValidationCallback, Boolean checkCertificateRevocation)”

Any suggestions on how to solve this? Thank you so much in advance!

Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.