none
How to Install Office Online Server for SharePoint 2016 RRS feed

  • Question

  • Install Office Online Server (OOS) on different machine and link to SharePoint 2016 machine and SQL Server Analysis Service
    Tuesday, November 14, 2017 10:11 AM

Answers

  • Installation of Office Online Server for SharePoint 2016

     

    Hardware and software requirement:

    • OOS (Office Online Server) can be installed on physical or virtual Servers.
    • OOS (Office Online Server) hardware requirement is almost same as SharePoint Server.

    12 GB

    · 64-bit, 4 cores

    · 80 GB for system drive

    · 80 GB for second drive

    • As of now, OOS is supported on Windows Sever 2012 R2 (64Bit) or later
    • There is no requirement for SQL Server as no database for OOS.
    • Windows Server 2012 should be updated or have at least following KB installed.
    • Office Online Server should be in the same forest as SharePoint.

    Ports:

    • Port 443 for HTTPS traffic.
    • Port 80 for HTTP traffic.
    • Port 809 for private traffic between the Servers that runs Office Online Server (if you’re setting up a multi-Server farm).

    Dedicated Requirement:

    • Make sure that no other Office Application or Server Application (SharePoint, exchange etc) is installed on the Server where OOS is going to be installed.
    • As SharePoint installation is not supported on the domain controller, the same is true for OOS.
    • SharePoint should be configured for the Claim based authentication. OOS does not support the classic authentication.
    • Always install Office Online Server on the dedicated Servers.

    Checklist:

    Item

    Description

    Value

    Server

    Name of Servers where OOS will install

    KF-OOS

    Installation Account

    Service account under which OOS will install (should be local admin)

    -

    Ports

    Make sure that the ports are open

    80,443,809

    SSL Certificate

    If SSL is being used, then what is the name of the certificate

    -

    FQDN Internal

    OOS Internal URL

    KF-OOS.krossfarm.com

    FQDN External

    OOS external URL

    KF-ext-OOS.krossfarm.com

    Internet Access

    Make sure that internet access is enabled on the Server

    -

    Bits location

    Location, where the installation files are copied

    -

    Installation Location of OOS

    Installation location, if you don’t want to use the default location

    -

    OOS logs location

    Location for OOS logs

    -

     

     

     

     

    Installation Order:

    Before you configure SharePoint Server to use Office Online Server

    A few things to check before getting started:

    1.        Install SharePoint Server 2016. See Install and configure SharePoint Server 2016 for guidance.
    2.        Make sure all SharePoint Server 2016 web applications use claims-based authentication. Office Online rendering and editing won’t work on SharePoint Server 2016 web applications that use classic mode authentication.

    To convert a SharePoint 2016 web application Clasic to claims-based authentication

    $WebAppName = "http://URL/"

    $wa = get-SPWebApplication $WebAppName

    $wa.UseClaimsAuthentication = $true

    $wa.Update()

    1.        To enable users to edit (not just read) Office documents in a web browser, you’ll need an editing license. Also, you’ll need to enable editing on the Office Online Server farm.
    2.        If you log on to SharePoint Server 2016 by using the System Account, you won’t be able to test the connection between SharePoint Server 2016 and Office Online Server. Log on with a different account to test the connection.
    3.        Low memory conditions can cause Office document previews to fail in Office Online.

    Please perform the installation in the order given below.

        ü  Install prerequisite software for Office Online Server

        ü  Connect Office Online Server Farm

        ü  Configure Office Online Server in Analysis Services

        ü  Configure Excel Online BI Server

        ü  Configure Claims to Windows Token Service for Office Online Server

        ü  Register Office Online Server in the SharePoint 2016 Farm

        ü  Verify basic Excel Online Configuration for BI

        ü  Testing Office Online Server Configuration

        ü  Updates and PowerShell

        ü  Reference URLs

     

    Step1: Install prerequisite software for Office Online Server

    To install Office Online Server

    1.        Open the Windows PowerShell prompt as an administrator and run this command to install the required roles and services.

    Windows Server 2012 R2:

    Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices,NET-Framework-Features,NET-Framework-Core,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45,Windows-Identity-Foundation,Server-Media-Foundation

    Windows Server 2016:

    Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,NET-Framework-Features,NET-Framework-45-Features,NET-Framework-Core,NET-Framework-45-Core,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45,Windows-Identity-Foundation,Server-Media-Foundation

    If prompted, restart the server.

    1.        Install the following software:

    Step2: Install Office Online Server

    Next, we'll install Office Online Server.

    If you plan to use any Excel Online features that utilize external data access (such as Data Models, Power Pivot, or Power View), note that Office Online Server must reside in the same Active Directory forest as its users as well as any external data sources that you plan to access using Windows-based authentication.

    Complete these steps on any servers that will run Office Online Server.

    To install Office Online Server

    1.        Download Office Online Server from the Volume Licensing Service Center (VLSC). The download is located under those Office products on the VLSC portal.
    2.        Run Setup.exe.
    3.        On the Read the Microsoft Software License Terms page, select I accept the terms of this agreement and click Continue.
    4.        On the Choose a file location page, select the folder where you want the Office Online Server files to be installed (for example, C:\Program Files\Microsoft Office Web Apps) and select Install Now. If the folder you specified doesn’t exist, Setup creates it for you.

    We recommend that you install Office Online Server on the system drive.

    1.        When Setup finishes installing Office Online Server, choose Close.
    2.        If you're planning to use Kerberos Constrained Delegation with Excel Online, then, in Services, set the Claims to Windows Token Service to start automatically on this server.

    If you plan to use Kerberos Constrained Delegation with Excel Online, be sure to add each server in the Office Online Server farm to the Active Directory Domain Services delegation list.

    Step3: Connect Office Online Server Farm

    1.        Log on to Office Online Server as SPAdmin.
    2.        Right-click on the Windows PowerShell icon in the taskbar, and click on Run as Administrator.
    3.        If a User Account Control window is displayed, click Yes.
    4.        Once you’re in Windows PowerShell, run the following commands. Make sure if you use different computer names to replace http://ComputerName accordingly:

    New-OfficeWebAppsFarm -InternalURL "http://dc-sp-bp-02" -AllowHttp -TranslationEnabled -EditingEnabled -ExcelWorkbookSizeMax 2000 -AllowHttpSecureStoreConnections –Verbose

    Set-OfficeWebAppsFarm -PicturePasteDisabled:$False -OpenFromUrlEnabled:$True -OnlinePictureEnabled:$True

    1.        A message will appear to inform you that you should only set EditingEnabled to TRUE if licenses permit online editing. Acknowledge this message by pressing Y for Yes.
    2. Browse http://<Server name>/hosting/discovery
    3.        It is recommended that you copy & paste the resulting output into a document to keep a reference of the Office Online Server configuration.
    4.        Also, note that the New-OfficeWebAppsFarm cmdlet creates a new firewall rule called Microsoft Office Web Apps to open TCP ports 80, 443, and 809 for inbound traffic.

    Step4: Configure Office Online Server in Analysis Services

    1.        Log on to SQL Server Machine (Which we installed Analysis Service with PowerPivot mode) as Farm Admin Account and start SQL Server Management Studio.
    2.        Connect to the <MachineName>\SP2016PP instance of Analysis Services.
    3.        Right-click the instance name in Object Explorer and click Properties.
    4.        Click Security in the Select a Page pane, then click Add.
    5.        In the Select Users or Groups dialog, click
    6.        Select Entire directory and click OK.
    7.        Click Object Types, select the Computers check box, and click OK.
    8.        In the Enter the object names to select textbox, type the name of the computer, such as <Office Online Server Name>, and then click Check Names to verify the computer account is found.
    9.        Click OK twice to apply the changes and close the Analysis Server Properties dialog box.


    Step5: Configure Excel Online BI Server

    1.        Login to Office Online Server with Farm Account.
    2.        Right-click on the Windows PowerShell icon in the taskbar, and then click on Run as Administrator.
    3.        If a User Account Control window is displayed, click Yes.
    4.        From the Windows PowerShell command prompt, run the following command:

    New-OfficeWebAppsExcelBIServer -ServerID <SQL Server Name>\SP2016PP


    Step6: Configure Claims to Windows Token Service for Office Online Server:

    1.        From the Windows PowerShell command prompt, run the following command to open the configuration file of the Claims to Windows Token Service (C2WTS) in Notepad.exe:

    Notepad "C:\Program Files\Windows Identity Foundation\v3.5\c2wtshost.exe.config"

    1.        Remove the comment tags (<!– and –>) from the NT AUTHORITY\Network Service line and save the changes.


    1.        From Computer Management, set Startup type to Automatic and start Claims to Windows Token Service:


    Step7: Register Office Online Server in the SharePoint 2016 Farm:

    1.        Log on to SharePoint Application Server as farm administrator Account, and then on the Desktop, right-click on the SharePoint 2016 Management Shell, and then click Run as administrator.
    2.        If a User Account Control window is displayed, click Yes.
    3.        From the SharePoint 2016 Management Shell, run the following commands to update the SharePoint farm properties for Excel Services SOAP API support. This will provide the basis for Analysis Services client libraries to communicate with Excel Online:

    $farm = Get-SPFarm

    $farm.Properties.Add("WopiLeagcySoapSupport" , "http://<URL>/x/_vti_bin/ExcelServiceInternal.asmx");

    $farm.Update();


    1.        From the SharePoint 2016 Management Shell, run the following commands to register a new WOPI Binding for the Office Online Server and allow authentication over HTTP connections:

    New-SPWOPIBinding -ServerName <Office Online Server FQDN> -AllowHTTP

    Set-SPWOPIZone -zone internal-http

    Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp

    $config = (Get-SPSecurityTokenServiceConfig)

    $config.AllowOAuthoverHttp = $true

    $config.Update()

    Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp


    1.        Close the SharePoint 2016 Management Shell.

    Step8: Verify basic Excel Online Configuration for BI

    1.        Visit the BI Root Site at http://SP2016FE as a SP User.
    2.        Open the Documents library and then click on Upload. You’ll need to Upload an Excel workbook with a PowerPivot data model. Sample PowerPivot workbooks can be downloaded from the Microsoft Download Center.
    3.        Following the upload, click on the workbook to open it in the browser. Note that the workbook renders in Excel Online.
    4.        Interact with the data by clicking on a slicer. This will ensure Excel Online loads the data model on the Analysis Services instance.
    5.        Log on to SQL Server Analysis Machine as SQLAdmin and start Microsoft SQL Server Management Studio.
    6.        In the Connect to Server dialog box, under Server type, select Analysis Server. Under Server name, type ServerName\SHAREPOINT. Click Connect.
    7.        Expand the Databases node and verify that the workbooks data model is listed.

    Microsoft SQL Server Management Studio

    Step9: Testing Office Online Server Configuration

    1.        Office Online Server cannot be tested via System account. You need a user account to test it.
    2.        After successful installation, you can test OOS via http://OOS Server/hosting/discovery.
    3.        Browse to SharePoint Site and open any Office document, if it is open in Office Online (Browser), then your configuration is correct.
    4.        Go to Search center and search for Office document, Hover the mouse on the URL & you will see the Document Preview in Popup Window.
      • Always monitor Office Online Server, at least for the memory usage, if the Servers run out of memory, then it can fail.
      • To disconnect Office Online Farm from SharePoint 2016, run the command given below.

     

    Remove-SPWOPIBinding -All:$true

    Step9: Updates and PowerShell

    • By default, Windows PowerShell includes Office Online Server module but for reference here module is to be used to import all OOS PowerShell commands
      • Import-Module -Name OfficeWebApps.

    To apply the updates to Office online Server, you have to remove the Server first, then apply the updates.

    • Remove-OfficeWebAppsMachine.
      • Once Server is upgraded, then add the Server into Farm by running new command.
        • New-OfficeWebAppsFarm (please use the same parameters which you used initially when OOS farm was set up)
      • Some handy PowerShell commands are given below.

    $OOS = Get-OfficeWebAppsFarm

    $OOS.Machine #this command will return all the machine in OOS farm with its status.

    $OOS.LogLocation # this command will return the location of log files.

    $OOS.AllowHttp #this command will return true if allowed http is enabled.

    $OOS.InternalURL #this command will return the Internal URL.

    $OOS.ExternalURL #this command will return the Internal URL.

    Step9: Reference URLs

    https://www.fmtconsultants.com/how-to-install-and-configure-bi-features-on-sharepoint-2016-and-sql-server-2016/#heading2

    https://technet.microsoft.com/library/jj219456(v=office.16).aspx

    https://technet.microsoft.com/en-us/library/ff431687(v=office.16).aspx


    • Marked as answer by Balu-Admin Tuesday, November 14, 2017 10:22 AM
    • Edited by Balu-Admin Tuesday, March 13, 2018 10:02 AM
    Tuesday, November 14, 2017 10:22 AM

All replies

  • Installation of Office Online Server for SharePoint 2016

     

    Hardware and software requirement:

    • OOS (Office Online Server) can be installed on physical or virtual Servers.
    • OOS (Office Online Server) hardware requirement is almost same as SharePoint Server.

    12 GB

    · 64-bit, 4 cores

    · 80 GB for system drive

    · 80 GB for second drive

    • As of now, OOS is supported on Windows Sever 2012 R2 (64Bit) or later
    • There is no requirement for SQL Server as no database for OOS.
    • Windows Server 2012 should be updated or have at least following KB installed.
    • Office Online Server should be in the same forest as SharePoint.

    Ports:

    • Port 443 for HTTPS traffic.
    • Port 80 for HTTP traffic.
    • Port 809 for private traffic between the Servers that runs Office Online Server (if you’re setting up a multi-Server farm).

    Dedicated Requirement:

    • Make sure that no other Office Application or Server Application (SharePoint, exchange etc) is installed on the Server where OOS is going to be installed.
    • As SharePoint installation is not supported on the domain controller, the same is true for OOS.
    • SharePoint should be configured for the Claim based authentication. OOS does not support the classic authentication.
    • Always install Office Online Server on the dedicated Servers.

    Checklist:

    Item

    Description

    Value

    Server

    Name of Servers where OOS will install

    KF-OOS

    Installation Account

    Service account under which OOS will install (should be local admin)

    -

    Ports

    Make sure that the ports are open

    80,443,809

    SSL Certificate

    If SSL is being used, then what is the name of the certificate

    -

    FQDN Internal

    OOS Internal URL

    KF-OOS.krossfarm.com

    FQDN External

    OOS external URL

    KF-ext-OOS.krossfarm.com

    Internet Access

    Make sure that internet access is enabled on the Server

    -

    Bits location

    Location, where the installation files are copied

    -

    Installation Location of OOS

    Installation location, if you don’t want to use the default location

    -

    OOS logs location

    Location for OOS logs

    -

     

     

     

     

    Installation Order:

    Before you configure SharePoint Server to use Office Online Server

    A few things to check before getting started:

    1.        Install SharePoint Server 2016. See Install and configure SharePoint Server 2016 for guidance.
    2.        Make sure all SharePoint Server 2016 web applications use claims-based authentication. Office Online rendering and editing won’t work on SharePoint Server 2016 web applications that use classic mode authentication.

    To convert a SharePoint 2016 web application Clasic to claims-based authentication

    $WebAppName = "http://URL/"

    $wa = get-SPWebApplication $WebAppName

    $wa.UseClaimsAuthentication = $true

    $wa.Update()

    1.        To enable users to edit (not just read) Office documents in a web browser, you’ll need an editing license. Also, you’ll need to enable editing on the Office Online Server farm.
    2.        If you log on to SharePoint Server 2016 by using the System Account, you won’t be able to test the connection between SharePoint Server 2016 and Office Online Server. Log on with a different account to test the connection.
    3.        Low memory conditions can cause Office document previews to fail in Office Online.

    Please perform the installation in the order given below.

        ü  Install prerequisite software for Office Online Server

        ü  Connect Office Online Server Farm

        ü  Configure Office Online Server in Analysis Services

        ü  Configure Excel Online BI Server

        ü  Configure Claims to Windows Token Service for Office Online Server

        ü  Register Office Online Server in the SharePoint 2016 Farm

        ü  Verify basic Excel Online Configuration for BI

        ü  Testing Office Online Server Configuration

        ü  Updates and PowerShell

        ü  Reference URLs

     

    Step1: Install prerequisite software for Office Online Server

    To install Office Online Server

    1.        Open the Windows PowerShell prompt as an administrator and run this command to install the required roles and services.

    Windows Server 2012 R2:

    Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices,NET-Framework-Features,NET-Framework-Core,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45,Windows-Identity-Foundation,Server-Media-Foundation

    Windows Server 2016:

    Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,NET-Framework-Features,NET-Framework-45-Features,NET-Framework-Core,NET-Framework-45-Core,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45,Windows-Identity-Foundation,Server-Media-Foundation

    If prompted, restart the server.

    1.        Install the following software:

    Step2: Install Office Online Server

    Next, we'll install Office Online Server.

    If you plan to use any Excel Online features that utilize external data access (such as Data Models, Power Pivot, or Power View), note that Office Online Server must reside in the same Active Directory forest as its users as well as any external data sources that you plan to access using Windows-based authentication.

    Complete these steps on any servers that will run Office Online Server.

    To install Office Online Server

    1.        Download Office Online Server from the Volume Licensing Service Center (VLSC). The download is located under those Office products on the VLSC portal.
    2.        Run Setup.exe.
    3.        On the Read the Microsoft Software License Terms page, select I accept the terms of this agreement and click Continue.
    4.        On the Choose a file location page, select the folder where you want the Office Online Server files to be installed (for example, C:\Program Files\Microsoft Office Web Apps) and select Install Now. If the folder you specified doesn’t exist, Setup creates it for you.

    We recommend that you install Office Online Server on the system drive.

    1.        When Setup finishes installing Office Online Server, choose Close.
    2.        If you're planning to use Kerberos Constrained Delegation with Excel Online, then, in Services, set the Claims to Windows Token Service to start automatically on this server.

    If you plan to use Kerberos Constrained Delegation with Excel Online, be sure to add each server in the Office Online Server farm to the Active Directory Domain Services delegation list.

    Step3: Connect Office Online Server Farm

    1.        Log on to Office Online Server as SPAdmin.
    2.        Right-click on the Windows PowerShell icon in the taskbar, and click on Run as Administrator.
    3.        If a User Account Control window is displayed, click Yes.
    4.        Once you’re in Windows PowerShell, run the following commands. Make sure if you use different computer names to replace http://ComputerName accordingly:

    New-OfficeWebAppsFarm -InternalURL "http://dc-sp-bp-02" -AllowHttp -TranslationEnabled -EditingEnabled -ExcelWorkbookSizeMax 2000 -AllowHttpSecureStoreConnections –Verbose

    Set-OfficeWebAppsFarm -PicturePasteDisabled:$False -OpenFromUrlEnabled:$True -OnlinePictureEnabled:$True

    1.        A message will appear to inform you that you should only set EditingEnabled to TRUE if licenses permit online editing. Acknowledge this message by pressing Y for Yes.
    2. Browse http://<Server name>/hosting/discovery
    3.        It is recommended that you copy & paste the resulting output into a document to keep a reference of the Office Online Server configuration.
    4.        Also, note that the New-OfficeWebAppsFarm cmdlet creates a new firewall rule called Microsoft Office Web Apps to open TCP ports 80, 443, and 809 for inbound traffic.

    Step4: Configure Office Online Server in Analysis Services

    1.        Log on to SQL Server Machine (Which we installed Analysis Service with PowerPivot mode) as Farm Admin Account and start SQL Server Management Studio.
    2.        Connect to the <MachineName>\SP2016PP instance of Analysis Services.
    3.        Right-click the instance name in Object Explorer and click Properties.
    4.        Click Security in the Select a Page pane, then click Add.
    5.        In the Select Users or Groups dialog, click
    6.        Select Entire directory and click OK.
    7.        Click Object Types, select the Computers check box, and click OK.
    8.        In the Enter the object names to select textbox, type the name of the computer, such as <Office Online Server Name>, and then click Check Names to verify the computer account is found.
    9.        Click OK twice to apply the changes and close the Analysis Server Properties dialog box.


    Step5: Configure Excel Online BI Server

    1.        Login to Office Online Server with Farm Account.
    2.        Right-click on the Windows PowerShell icon in the taskbar, and then click on Run as Administrator.
    3.        If a User Account Control window is displayed, click Yes.
    4.        From the Windows PowerShell command prompt, run the following command:

    New-OfficeWebAppsExcelBIServer -ServerID <SQL Server Name>\SP2016PP


    Step6: Configure Claims to Windows Token Service for Office Online Server:

    1.        From the Windows PowerShell command prompt, run the following command to open the configuration file of the Claims to Windows Token Service (C2WTS) in Notepad.exe:

    Notepad "C:\Program Files\Windows Identity Foundation\v3.5\c2wtshost.exe.config"

    1.        Remove the comment tags (<!– and –>) from the NT AUTHORITY\Network Service line and save the changes.


    1.        From Computer Management, set Startup type to Automatic and start Claims to Windows Token Service:


    Step7: Register Office Online Server in the SharePoint 2016 Farm:

    1.        Log on to SharePoint Application Server as farm administrator Account, and then on the Desktop, right-click on the SharePoint 2016 Management Shell, and then click Run as administrator.
    2.        If a User Account Control window is displayed, click Yes.
    3.        From the SharePoint 2016 Management Shell, run the following commands to update the SharePoint farm properties for Excel Services SOAP API support. This will provide the basis for Analysis Services client libraries to communicate with Excel Online:

    $farm = Get-SPFarm

    $farm.Properties.Add("WopiLeagcySoapSupport" , "http://<URL>/x/_vti_bin/ExcelServiceInternal.asmx");

    $farm.Update();


    1.        From the SharePoint 2016 Management Shell, run the following commands to register a new WOPI Binding for the Office Online Server and allow authentication over HTTP connections:

    New-SPWOPIBinding -ServerName <Office Online Server FQDN> -AllowHTTP

    Set-SPWOPIZone -zone internal-http

    Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp

    $config = (Get-SPSecurityTokenServiceConfig)

    $config.AllowOAuthoverHttp = $true

    $config.Update()

    Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp


    1.        Close the SharePoint 2016 Management Shell.

    Step8: Verify basic Excel Online Configuration for BI

    1.        Visit the BI Root Site at http://SP2016FE as a SP User.
    2.        Open the Documents library and then click on Upload. You’ll need to Upload an Excel workbook with a PowerPivot data model. Sample PowerPivot workbooks can be downloaded from the Microsoft Download Center.
    3.        Following the upload, click on the workbook to open it in the browser. Note that the workbook renders in Excel Online.
    4.        Interact with the data by clicking on a slicer. This will ensure Excel Online loads the data model on the Analysis Services instance.
    5.        Log on to SQL Server Analysis Machine as SQLAdmin and start Microsoft SQL Server Management Studio.
    6.        In the Connect to Server dialog box, under Server type, select Analysis Server. Under Server name, type ServerName\SHAREPOINT. Click Connect.
    7.        Expand the Databases node and verify that the workbooks data model is listed.

    Microsoft SQL Server Management Studio

    Step9: Testing Office Online Server Configuration

    1.        Office Online Server cannot be tested via System account. You need a user account to test it.
    2.        After successful installation, you can test OOS via http://OOS Server/hosting/discovery.
    3.        Browse to SharePoint Site and open any Office document, if it is open in Office Online (Browser), then your configuration is correct.
    4.        Go to Search center and search for Office document, Hover the mouse on the URL & you will see the Document Preview in Popup Window.
      • Always monitor Office Online Server, at least for the memory usage, if the Servers run out of memory, then it can fail.
      • To disconnect Office Online Farm from SharePoint 2016, run the command given below.

     

    Remove-SPWOPIBinding -All:$true

    Step9: Updates and PowerShell

    • By default, Windows PowerShell includes Office Online Server module but for reference here module is to be used to import all OOS PowerShell commands
      • Import-Module -Name OfficeWebApps.

    To apply the updates to Office online Server, you have to remove the Server first, then apply the updates.

    • Remove-OfficeWebAppsMachine.
      • Once Server is upgraded, then add the Server into Farm by running new command.
        • New-OfficeWebAppsFarm (please use the same parameters which you used initially when OOS farm was set up)
      • Some handy PowerShell commands are given below.

    $OOS = Get-OfficeWebAppsFarm

    $OOS.Machine #this command will return all the machine in OOS farm with its status.

    $OOS.LogLocation # this command will return the location of log files.

    $OOS.AllowHttp #this command will return true if allowed http is enabled.

    $OOS.InternalURL #this command will return the Internal URL.

    $OOS.ExternalURL #this command will return the Internal URL.

    Step9: Reference URLs

    https://www.fmtconsultants.com/how-to-install-and-configure-bi-features-on-sharepoint-2016-and-sql-server-2016/#heading2

    https://technet.microsoft.com/library/jj219456(v=office.16).aspx

    https://technet.microsoft.com/en-us/library/ff431687(v=office.16).aspx


    • Marked as answer by Balu-Admin Tuesday, November 14, 2017 10:22 AM
    • Edited by Balu-Admin Tuesday, March 13, 2018 10:02 AM
    Tuesday, November 14, 2017 10:22 AM
  • Hi,

    Thanks for your sharing! It will benefit with others in the community who meet the similar requirement in the future.

    Thanks,

    Wendy


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Wednesday, November 15, 2017 2:19 AM
    Moderator