Excel REST Odata retrieve could not establish trust relationship

I am trying to use Excel to retrieve data using OData and I get an error message:
Odata: Request failed: the underlying connection was closed: could not establish trust relationship for the SSL/TLS secure channel.
image

I am able to get results using just a browser:
https://ermc-sql1/EPICORPILOT/api/v1/BaqSvc/02-ERMCSalesOrders(02)/

However, when i try to connect from Excel i get the trust relationship error.

I went into the Excel Trust Center and added a Catalog to that URL however, i still get the trust relationship error.

Anyone solved this issue before?

I’m not sure if this is a server or client issue?

Any help greatly appreciated.

DaveO

It’s due to Excels high level of trust required on HTTPS Security - above and beyond what Browsers require.

I assume this is a self signed cert to ermc-sql1?
Is the ‘signing cert’ in Trusted Root Certification Authorities?

2 Likes

You’ll need a valid SSL Cert, excel is super picky about certs. Try let’s encrypt for a free / valid SSL cert.

2 Likes

Mr. Bart: Yes this is a self signed Cert on the server - however I am running Excel on a client.

I must admit I am not an expert on “Trusted Root Authorities” - I could not find that reference in the Excel Trust Manager.

I remember setting up a self signed Cert when I did the install - Do I need to reference that?

Or as Jose suggested - am I better off trying to setup a “valid SSL”?

Thanks,
DaveO

Yes and on all your servers and not just the Epicor one. It’s really becoming a best security practice.

Mark W.

Dave,

Check out this thread. It is a really long read, but some of the security stuff is discussed in there.

Lets Encrypt will work if your server does not have internet access for them to verify you have control of it?

No

If this server will only be accessed internally, you can do what @Bart_Elia suggested, add your server self-signed cert to your Active Directories Trusted list so computers in the network will trust the cert.

1 Like

This helped me! REST was working on my workstation but no others. I looked and I had a certificate installed but no one else did. I believe XL Broadcast must have installed one. Thank you very much!!