OOS External connection in excel list sharepoint 2013

Question

Hi, i have a SP2013 farm, that opened by http And OOS 2016 with all https zones.
WOPI from SP to OOS created by https.
But when i'm triyng to open excel book, that connect to database i see error, that i cannot connect with secure store to this databse, because option AllowHttpSecureStoreConnections is "False". If i'll turn it to True, then i'll update connections in excel book successfully. My question is - why if i'm using https in OOS i still get error about untrusted connection(like through HTTP)

Answer 1

using https is secured way to configure your OOS farm. since, your SharePoint Farm doesn't have SSL configured that the reason you were not able to connect secure store.

-AllowHttpSecureStoreConnections - Indicates that secure store connections can be made by using non-SSL connections (such as HTTP). The default is False.

Use AllowHTTPSecureStoreConnections only in environments where all computers require IPSEC (full encryption) or in test environments that do not contain sensitive files.

https://learn.microsoft.com/en-us/powershell/module/officewebapps/set-officewebappsfarm?view=officewebapps-ps

Thanks & Regards,

Answer 2

@Dmitriy Orlov

By default, the HTTP protocol is used on the browser, so it will not automatically jump to HTTPS. However, some browser that support dual protocols will automatically redirect.

You can try the following solutions:

1.Change other browser to test, such as IE browser.

2.You should import Https certificate to IIS.
a. Log in machine with SharePoint Server 2013 >> Export https cert in the IIS
b. Go to machine with OWA server >> Import https cert in the IIS, and add “https 443 port” Binding

Thanks,
Echo Du

================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.