OOS External connection in excel list sharepoint 2013

Dmitriy Orlov 1 Reputation point
2020-09-08T10:53:17.447+00:00

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)

Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
611 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,881 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sharath Kumar Aluri 3,071 Reputation points
    2020-09-08T14:25:03.84+00:00

    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://video2.skills-academy.com/en-us/powershell/module/officewebapps/set-officewebappsfarm?view=officewebapps-ps

    Thanks & Regards,

  2. Echo Du_MSFT 17,141 Reputation points
    2020-09-09T10:17:27.957+00:00

    @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
    23456-2.jpg
    23522-3.jpg

    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.