How to connect stage SP server to OOS server

sns 9,236 Reputation points
2020-09-09T06:36:29.08+00:00

We have 4 SP server, 2 WFE and 2 APP
these already connected to OOS production servers ( 2 servers)

We have 4 stage SharePoint server ( 2 WFE and 2 APP)

I would like to connect these stage servers to OOS production servers
how to connect? please help

in case if I need to command, do I need to execute in 4 stage servers to connect OOS prod?
How do I verify after connecting?

Please help

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,935 questions
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,156 Reputation points
    2020-09-09T10:12:31.377+00:00

    Please the following steps:

    1. Configure the host
      a. Create the binding between SharePoint 2019 and Office Web Apps Server
      New-SPWOPIBinding -ServerName <WacServerName>
      b. View the WOPI zone of SharePoint 2019
      Get-SPWOPIZone
      c. If necessary you can change the WOPI zone
      Set-SPWOPIZone -zone "external-https"
    2. Create the Office Web Apps Server farm on the first server
      New-OfficeWebAppsFarm -InternalUrl "https://server.contoso.com" -ExternalUrl "https://wacweb01.contoso.com" -SSLOffloaded –EditingEnabled
    3. Add more servers to the farm
      Run New-OfficeWebAppsMachine command on each server you want to add to the Office Web Apps Server farm
      New-OfficeWebAppsMachine -MachineToJoin "server1.contoso.com"
    4. Check the Office Web Apps Server farm was created successfully
      Access the Office Web Apps Server discovery URL via IE, for example https://server.contoso.com/hosting/discovery
      If the deployment completed properly, you should see a XML file in your web browser that shown as below.
      23463-1.png

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

    @sns
    I have updated my Answer.

    The following answers to your questions:

    1. You just create the binding between SharePoint 2016 and Office Online Server on one of servers.
    2. You could use Get-SPWOPIBinding to view OOS Server name.
    3. You best to choose internal-https. Because in production environments, the more secure HTTPS protocol is the better choice.
    4. The command Get-SPWOPIBinding returns a list of bindings that were created by using New-SPWOPIBinding on the current SharePoint farm. Then, the Get-SPWOPIZone | Get-SPWOPIBinding command returns a list of bindings that were created on the specific WOPI Zone on the current SharePoint farm.
      In other words, the second adds a condition that limit WOPI Zone
    5. When deploying OOS, SharePoint Server default select the internal-https zone as WOPI Zone. Unless you run the following command to change WOPI Zone to the external-https. Set-SPWOPIZone -zone "external-https"

    So, when you executing "Get-SPWOPIZone | Get-SPWOPIBinding" command only shows internal-https.

    Click this link #Get-SPWOPIBinding# to see more usage of Get-SPWOPIBinding command.

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

    @sns

    …………………… Updated Answer ……………………
    You just create one WOPIBinding on SharePoint farm.
    Because you have already built the binding between Stage SP server and OOS production server before. So, you don’t need to run New-SPWOPIBinding -ServerName <WacServerName> command.

    You can follow these steps:
    Ps: Deploy a multi-server, load-balanced Office Online Server farm that uses HTTPS

    Step 1: Create Office Online Server farm on the first server.
    Please run the following command as an admin:

    New-OfficeWebAppsFarm -InternalUrl "https://server.contoso.com" -ExternalUrl "https://wacweb01.contoso.com" - SSLOffloaded -EditingEnabled     
    

    Step 2: Add more servers to the farm
    After the first server is running Office Online Server, run the New-OfficeWebAppsMachine command on each server you want to add to the Office Online Server farm.

    New-OfficeWebAppsMachine -MachineToJoin "server1.contoso.com"  
    

    Step 3: check the Office Online Server farm was created successfully
    Access Office Online Server discovery URL via IE browser, for example: https://server.contoso.com/**hosting/discovery**
    If created successfully, you should see a Web Application Open Platform Interface Protocol (WOPI)-discovery XML file in you page.

    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.


3 additional answers

Sort by: Most helpful
  1. Trevor Seward 11,701 Reputation points
    2020-09-09T15:05:27.863+00:00

    You simply create a new WOPI binding on your stage farm. You only do this on one SharePoint server per farm.


  2. Sharath Kumar Aluri 3,071 Reputation points
    2020-09-09T16:46:08.147+00:00

    Agree with Trevor, To connect your staging environment you need to execute the above three commands, you just need to run the above first 3 commands from any one of the SharePoint Server. To get the OOS Server Name run below commands.

    #This example returns details about the OfficeWebAppsFarm object
    Get-OfficeWebAppsFarm
    
    #This example returns details about the servers that are members of the Office Online Server farm. These details include the health status and roles held by each server
    (Get-OfficeWebAppsFarm).Machines
    

    Thanks & Regards,

    0 comments No comments

  3. sns 9,236 Reputation points
    2020-09-17T08:49:59.477+00:00
    0 comments No comments

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.