Office Online Server (OOS) and SharePoint Server 2019 On-Premise

Muhammad Mustafa 10 Reputation points
2023-09-21T04:06:46.33+00:00

Who can help here, in issue of opening documnet in office online server browser, sharepoint 2019 on premise integrated with Azure AD MFA

  1. Office Online server installed
  2. SSL installed
  3. SSL exported
  4. Exported SSL used in SharePoint All Servers with Web applicaiton foundation service application running
  5. SharePoint site HTTPS://MYSHAREPOINTSITE.COM is accessible from OOS Server
  6. HTTPS://WACSERVERDOMAIN/hosting/discover is accessible from all SharePoint Servers
  7. HTTPS://WACSERVERDOMAIN/hosting/discovery is working fine on all servers including the OOS
  8. SharePoint site Configured with MFA with Azure AD Trust
  9. Login with AzureAD account and AzureCP are working fine
  10. Documents are accessible to download, to upload, to access in office applicatin e.g. word, excel etc.
  11. Documents showing exception in browser when open in office online browsers. errors are shown in follwoing images

User's image

User's image

User's image

Microsoft 365 and Office | SharePoint Server | For business
Microsoft 365 and Office | Office Online Server
Microsoft 365 and Office | SharePoint | For business | Windows
{count} votes

4 answers

Sort by: Most helpful
  1. Muhammad Mustafa 10 Reputation points
    2023-09-21T04:15:32.3233333+00:00

    I have checked with fiddler and following image has some telemetry request 408 issues.

    I tested all settings with domain account and it works fine. but whenever we test with AzureAD account it throughs the errors. so i think OnPremise Sharepoint with AzureAD account (MFA) is NOTE SUPPORTED or NOT WORKABLE to open document in browser for office online integrationUser's image

    1 person found this answer helpful.
    0 comments No comments

  2. Muhammad Mustafa 10 Reputation points
    2023-10-04T10:22:32.8533333+00:00

    I have successfully resolved my own problem that is explained in above question.

    Here are the steps for SharePoint Server Any one:

    1. Open SharePoint PowerShell
    1. Remove all WOPI bindings from SharePoint Farm with PowerShell command

    Remove-SPWOPIBinding -All:$true;

    1. Remove all WOPI Farm Properties with PowerShell command

    $gmtFarm = Get-SPFarm; $gmtFarm.Properties.Remove("WopiLegacySoapSupport");

    1. Create New WOPI bindings with PowerShell command

    $gmtExternalHTTPSoosURL = "owa.YOURDOMAIN.com" or "oos.YOURDOMAIN.com" or "any.any.any"; New-SPWOPIBinding -ServerName $gmtExternalHTTPSoosURL -AllowHTTP

    1. Set the WOPI Zone external with PowerShell command

    Set-SPWOPIZone -zone "external-https"

    1. Change the AllowOAuthOverHttp setting in SharePoint 2016 to True with PowerShell Command

    $gmtConfig = (Get-SPSecurityTokenServiceConfig) $gmtConfig.AllowOAuthOverHttp = $true $gmtConfig.Update()

    1. Confirm the config status with PowerShell command

    (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp;

    1. Enable SOAP API for Excel with PowerShell command

    $gmtExternalHTTPSoosURL = "owa.YOURDOMAIN.com" or "oos.YOURDOMAIN.com" or "any.any.any" $gmtExternalHTTPSoosURL = "HTTPS://" + $gmtExternalHTTPSoosURL + "/x/_vti_bin/ExcelServiceInternal.asmx"; $gmtFarm = Get-SPFarm $gmtFarm.Properties.Add("WopiLegacySoapSupport", $gmtExternalHTTPSoosURL); $gmtFarm.Update();

    1. OPTIONAL: You can also follow this Microsoft URL, read carefully each line and adopt. URL: https://learn.microsoft.com/en-us/officeonlineserver/configure-office-online-server-for-sharepoint-server-2016/configure-office-online-server-for-sharepoint-server-2016
    2. OPTIONAL: If you are using SSL on the server instead of F5 or load balancer then you can follow this URL: https://learn.microsoft.com/en-us/officeonlineserver/configure-office-online-server-for-sharepoint-server-2016/configure-server-to-server-authentication-between-office-online-server-and-share

    Here are the steps for Office Online Server (OOS):

    1. Follow this Microsoft URL to install the OOS URL: https://learn.microsoft.com/en-us/officeonlineserver/deploy-office-online-server
      1. Run this PowerShell command to create new office online server farm (OOS Farm) $gmtExternalHTTPSoosURL = "owa.YOURDOMAIN.com" or "oos.YOURDOMAIN.com" or "any.any.any"; New-OfficeWebAppsFarm -InternalUrl "HTTP://LOCALserverNAME.localDOMAIN" -ExternalUrl ("HTTPS://" + $gmtExternalHTTPSoosURL) -SSLOffloaded -EditingEnabled
        1. Now configure our Load Balancer or F5 Load Balancer with SSL that cover your all domain names for external users only
          1. Register your external URL to public IP
            1. Register your external URL of OOS for office online server in DNS server
              1. Enjoy. -----end of solution-----
    1 person found this answer helpful.
    0 comments No comments

  3. Emily Du-MSFT 51,846 Reputation points Microsoft External Staff
    2023-09-21T08:55:09.52+00:00

    Hi, thanks for your question and sharing.

    I have the same point as you. Currently, SharePoint 2019 with Azure AD account (MFA) is not supported to open documents in the browser through OOS integration.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.


  4. Emily Du-MSFT 51,846 Reputation points Microsoft External Staff
    2023-10-05T06:37:17.6866667+00:00

    I'm glad to hear that the issue is solved and thanks for your sharing. To close the thread, I would make a brief summary of this thread.

    [Office Online Server (OOS) and SharePoint Server 2019 On-Premises]

    Issue Symptom:

    Office Online server installed, SSL installed, SSL exported, Exported SSL used in SharePoint All Servers with Web application foundation service application running, SharePoint site HTTPS://MYSHAREPOINTSITE.COM is accessible from OOS Server, HTTPS://WACSERVERDOMAIN/hosting/discover is accessible from all SharePoint Servers, HTTPS://WACSERVERDOMAIN/hosting/discovery is working fine on all servers including th e OOS, SharePoint site Configured with MFA with Azure AD Trust, Login with Azure AD account and AzureCP are working fine, Documents are accessible to download, to upload, to access in office application e.g. word, excel etc.

    Documents showing exception in browser when open in office online browsers. errors are shown in following images.

    1

    2

    3

    Current status:

    Here are steps for SharePoint Server:

    1.Open SharePoint PowerShell.

    2.Remove all WOPI bindings from SharePoint Farm with PowerShell command.

    Remove-SPWOPIBinding -All:$true;

    3.Remove all WOPI Farm Properties with PowerShell command.

    $gmtFarm = Get-SPFarm; $gmtFarm.Properties.Remove("WopiLegacySoapSupport");

    4.Create New WOPI bindings with PowerShell command.

    $gmtExternalHTTPSoosURL = "owa.YOURDOMAIN.com" or "oos.YOURDOMAIN.com" or "any.any.any"; New-SPWOPIBinding -ServerName $gmtExternalHTTPSoosURL -AllowHTTP

    5.Set the WOPI Zone external with PowerShell command.

    Set-SPWOPIZone -zone "external-https"

    6.Change the AllowOAuthOverHttp setting in SharePoint 2016 to True with PowerShell Command

    $gmtConfig = (Get-SPSecurityTokenServiceConfig) $gmtConfig.AllowOAuthOverHttp = $true $gmtConfig.Update()

    7.Confirm the config status with PowerShell command.

    (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp;

    8.Enable SOAP API for Excel with PowerShell command.

    $gmtExternalHTTPSoosURL = "owa.YOURDOMAIN.com" or "oos.YOURDOMAIN.com" or "any.any.any" $gmtExternalHTTPSoosURL = "HTTPS://" + $gmtExternalHTTPSoosURL + "/x/_vti_bin/ExcelServiceInternal.asmx"; $gmtFarm = Get-SPFarm $gmtFarm.Properties.Add("WopiLegacySoapSupport", $gmtExternalHTTPSoosURL); $gmtFarm.Update();

    OPTIONAL1: You can also follow this Microsoft URL, read carefully each line and adopt. URL: https://learn.microsoft.com/en-us/officeonlineserver/configure-office-online-server-for-sharepoint-server-2016/configure-office-online-server-for-sharepoint-server-2016

    OPTIONAL2: If you are using SSL on the server instead of F5 or load balancer then you can follow this URL:

    https://learn.microsoft.com/en-us/officeonlineserver/configure-office-online-server-for-sharepoint-server-2016/configure-server-to-server-authentication-between-office-online-server-and-share

    Here are steps for Office Online Server (OOS):

    1.Follow this Microsoft URL to install the OOS: https://learn.microsoft.com/en-us/officeonlineserver/deploy-office-online-server

    2.Run this PowerShell command to create new office online server farm (OOS Farm).

    $gmtExternalHTTPSoosURL = "owa.YOURDOMAIN.com" or "oos.YOURDOMAIN.com" or "any.any.any"; New-OfficeWebAppsFarm -InternalUrl "HTTP://LOCALserverNAME.localDOMAIN" -ExternalUrl ("HTTPS://" + $gmtExternalHTTPSoosURL) -SSLOffloaded -EditingEnabled

    3.Configure our Load Balancer or F5 Load Balancer with SSL that cover your all domain names for external users only.

    4.Register your external URL to public IP.

    5.Register your external URL of OOS for office online server in DNS server.

    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.".

    You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community member's to see the useful information when reading this thread. Thanks for your understanding!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.