2325467 - Exception when using Analysis for Office to connect to HANA with SSL/TLS

When using Analysis for Office to connect to HANA with SSL/TLS, you get this error message:

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

>> General .NET Exception:

The remote certificate is invalid according to the validation procedure.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP Analysis for Microsoft Office

HTTPS, SSL, HANA, Analysis for Office, Analysis for Excel, AO, "The underlying connection was closed", "Could not establish trust relationship for the SSL/TLS secure channel", "The remote certificate is invalid according to the validation procedure" , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , HAN-DB-SEC , SAP HANA Security & User Management , Problem