Sharepoint > Office Web Apps

How to deploy Microsoft Office Web Apps 2013 in Sharepoint

How to integrate Microsoft Office Web Apps 2013 with Sharepoint 2013


In this section we are going to learn about deployment of Microsoft Office Web Apps 2013 and steps to integrate with SharePoint 2013.

Prerequisites:

  • All servers must be domain joined
  • .Net 4.0 or higher is installed
  • IIS 7.0 (role needs to be turned on through Webserver(IIS) role
  • PowerShell 3.0 is installed
  • Load balancer for multi-machine farms
  • Dedicated server with no applications installed (that are using port 80 or 443)
  • No other software’s such as SharePoint/Domain Controller/ Exchange are not installed on OWA Servers.

Office Web Apps sample URL

http://officewebapps.test.com

General Guidelines for installing: 

  • To minimize the complexity of the deployment install all office web apps roles on each server instead of distributing the roles on servers.
  • Microsoft Office web Apps 2013 does not require SQL database.
  • PowerShell is used to define Office Web Apps topology, by using New-OfficeWebAppsFarm command with the master server (the first server in the farm) and by using New-OfficeWebApps Machine command to join more machines to the farm.
  • Also PowerShell commands are used to connect the SharePoint farm to Office Web Apps farm.
  • In case of installing updates and patches, the Office Web Apps server should be disconnected from the Office Web Apps farm then joined again after finish the patching.
  • SharePoint system account can’t render office web apps (by design for security)

Office Web App Server Pre Requisites Installation on Windows 2012

  • Login to Office Web App 2013 server and run the PowerShell command as administrator. 
runasadmin
  • Run the following command to install the required roles and services.
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


prereq


  • Restart the server

Office Web App Server Installation

  • Mount Office Web Apps 2013 install setup on the OWA server and run the Install
  • On the Read the Microsoft Software License Terms page, select I accept the terms of this agreement and click Continue.
  • On the Choose a file location page, select the folder where you want the Office Web Apps Server files to be installed (for example, C:\Program Files\Microsoft Office Web Apps) and select Install Now.
  • When setup finishes installing Office Web Apps Server, choose Close.
  • Download and install Office Web Apps Server SP1
  • Download and install the Office Web Apps Server 2013 July update

Office Web App Server Configuration

  • Login on to OWA Server
  • Install the Office Web Apps Server update on that server.
Run the below PowerShell command
New-OfficeWebAppsFarm -InternalURL "http://officewebapps.test.com" -AllowHttp –EditingEnabled
config
  • Now open IIS and notice the creation of the new web application
  • A typical and very fast way to verify WOPI is working is to simply navigate to the discovery URL

                http://officewebapps.test.com/hosting/discovery

Office Web App Server integration with SharePoint 2013 Server

  • Login to any one of the SharePoint 2013 Web Front End server.
  • Run SharePoint 2013 Management Shell as Administrator
New-SPWOPIBinding –ServerName “officewebapps.test.com” –AllowHTTP


  • Now you should see a long list application extension registration with the WOPIZone
config
  • To confirm type and test below command to verify that the new zone is internal-http
Get-SPWOPIZone
config
  • Change the AllowOAuthOverHttp setting in SharePoint 2013 to True. Run below command
(Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp
config

  • That means we will need to allow SharePoint to allow OAuth over HTTP by running below commands
$config = (Get-SPSecurityTokenServiceConfig)
$config.AllowOAuthOverHttp = $true
$config.Update()

config

  • Now check one more time the status of OAuth over http
(Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp

config

  • Now once again check the WOPI Zone and as you can see it is still set to internal-https, if yes then set to internal-http using below methods

config

  • Run the following commands to suppress the XLSX extension from view action, because allowed to continue to open excel documents in Excel Services to avail more features.
New-SPWOPISuppressionSetting -Extension "XLSX" -Action "view"


Add servers to the farm

  • After the first server is running Office Web Apps Server, run the following command in OWA2 Server.
New-OfficeWebAppsMachine –MachineToJoin “machine02.test.com"
machine

Get-officeWebAppsFarm
getfarm

Enable the Excel Services & PowerPivot with external data connections.

  • Run the following commands to allow external data connections and secure store connections for Excel Services.

Set-OfficeWebAppsFarm -ExcelAllowExternalData

Set-OfficeWebAppsFarm –AllowHttpSecureStoreConnections


Test Office Web Apps with SP 2013

  • Browse any SharePoint sites as user (OWA does not work for system account)

Load sample Office documents to test in browser mode.


For Removing SPWOPI binding from SharePoint Servers

  • Login to any one of the SharePoint 2013 Web Front End server.
  • Run SharePoint 2013 Management Shell as Administrator
              Remove-SPWOPIBinding -All:$true
 Views: 418 | Post Order: 1


Related Posts

    Write for us






    Hosting Recommendations