owa and sharepoint integration
TRANSCRIPT
WWW.SPBIZCONF.COM
John Naguib
HP
Twitter : @johnnaguib
LinkedIn: https://eg.linkedin.com/pub/john-
naguib/5/b30/a69
TechNet:
https://social.technet.microsoft.com/profile/
john%20naguib/
Collaboration & SharePoint Consultant and Architect
with deep knowledge in SharePoint, including
architecture, installation, configuration, testing,
maintenance and development. In addition to being
Consultant I have a strong application development
back ground in .NET applications. I am holder of MCP,
MCTS, MCITP, MCPD, MCT and TOGAF 9 Foundation
certificates.
WWW.SPBIZCONF.COM
Agenda
•What OWA is?•OWA History and Design.•OWA Features.•OWA Planning.•Software, Hardware Requirements and Licensing.•Installation and Configuration.•Issues and How to resolve them.•HNSC and OWA•Demo.•Questions.
WWW.SPBIZCONF.COM
What is OWA?
Office Web Apps Server(OWA) provides updated
versions of Word Web App, Excel Web App, PowerPoint
Web App, and OneNote Web App. Users can view and
edit Office documents in SharePoint libraries by using a
supported web browser on computers and on many
mobile devices, such as Windows Phones, iPhones,
iPads, Windows 8 tablets, and Android devices.
WWW.SPBIZCONF.COM
Office Web Apps History• In 2010 Microsoft introduced the Office Web Apps
• Customers deploying Office Web Apps on their own networks did so
by installing Office Web Apps on SharePoint servers.
• Separation of the product was needed.
WWW.SPBIZCONF.COM
OWA Features1. Change Tracking
2. Comments
3. Co-authoring
4. Embedding
5. Ink Support
6. Quick Preview
7. Share by link
WWW.SPBIZCONF.COM
OWA Planning 1• You can install Office Web Apps Server as a single-server Office Web Apps Server farm, or as a multi-server,
load-balanced Office Web Apps Server farm.
• Physical servers or virtual machine can be used.
• You can’t install other server applications (such as SharePoint 2013 or SQL Server) on the same server as
Office Web Apps Server.
• Recommend that you use HTTPS for production environment.
• All servers in the Office Web Apps Server farm must be part of a domain.
WWW.SPBIZCONF.COM
OWA Planning 2
• Don’t install any services or roles that depend on the Web Server (IIS) role on port 80, 443, or 809
• Don’t install any version of Office.
• Make sure the following ports aren’t blocked by firewalls on either the server that runs Office Web Apps
Server or the load balancer:
• Port 443 for HTTPS traffic
• Port 80 for HTTP traffic
• Port 809 for private traffic between the servers that run Office Web Apps Server (if you’re setting up a
multi-server farm)
WWW.SPBIZCONF.COM
OWA Planning 3
• Make sure all SharePoint 2013 web applications use claims-based authentication.
• To enable users to edit (not just read) Office documents in a web browser, you’ll need an editing license.
• If you log on to SharePoint 2013 by using the System Account, you won’t be able to test the connection
between SharePoint 2013 and Office Web Apps Server. Log on with a different account to test the
connection.
• Low memory conditions can cause Office document previews to fail in Office Web Apps.
WWW.SPBIZCONF.COM
Hardware Requirements and Licensing
• RAM: 12GB
• 64 bit, 4 core processors
• 80 GB system drive
Office Web Apps licensing offers two options:
• View-only
• Edit and view
WWW.SPBIZCONF.COM
Supported Operating Systems
• The 64-bit edition of Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, or Datacenter with
the Update for Windows Server 2008 R2 x64 Edition installed
• The 64-bit edition of Windows Server 2012 Standard or Datacenter
• The 64-bit edition of Windows Server 2012 R2. To use this operating system, you must use Office Web Apps
Server Service Pack 1 (SP1).
WWW.SPBIZCONF.COM
Installation Steps
Enable the prerequisites for Office Web Apps 2013 in Windows Server 2012 using PowerShell
System restarts
Run the OWA 2013 installation setup as administrator
Install OWA SP1
Language Packs if needed
WWW.SPBIZCONF.COM
SharePoint Configuration Steps
Open SharePoint 2013 management Shell as Admin
Create Binding Between SharePoint 2013 and OWA
WWW.SPBIZCONF.COM
Issues and How to resolve1. When you select “new document” you are prompted to upload document instead of creating new document
– Make sure web app is using claims.
– Make sure the binding is correct.
2. You receive error “sorry something went wrong”
– Make sure you are not signed in with system account.
3. You receive error “file not found URL is not valid”
– Make sure file size doesn’t exceed 10 MB
4. To disconnect SharePoint from OWA
– Remove-SPWOPIBinding -All:$true
WWW.SPBIZCONF.COM
SSL HNSC and OWA
– If you have SSL HNSC if you created it as http then just added zone for the ssl, OWA will not work.
– In such case you will need to create the HNSC from the begging as https
New-SPSite 'https://site.company.com/departments/marketing' -HostHeaderWebApplication 'http://<servername>' -Name 'Marketing' -Description 'Portal' -OwnerAlias 'domain\administrator' -Template 'STS#0'
WWW.SPBIZCONF.COM
Tools: Fiddlerhttp://www.telerik.com/download/fiddler/fiddler4
http://blogs.msdn.com/b/fiddler/archive/2011/12/10/fiddler-windows-8-apps-enable-loopback-network-isolation-exemption.aspx
WWW.SPBIZCONF.COM
Tools SPSFarm ReportDocument your Farm
http://spsfarmreport.codeplex.com/
Run Powershell script
[Environment]::CurrentDirectory
Copy the generated file with the xslt
WWW.SPBIZCONF.COM
My TechNet Articles• SharePoint Tools and Codes
• SharePoint Vanity URLs
• SharePoint Sites are not deleted
• Remove WFE Role from Farm
• SharePoint 2013 HNSC
• Configure OWA with Certificates
• AAM and SharePoint 2013 SSL web applications
• Create Self Signed Certificates
• SharePoint 2013 and Kerberos
• SharePoint 2013 Capacity Management
• Workflow Manager Disaster Recovery
WWW.SPBIZCONF.COM
My TechNet Gallery Sharing's• SharePoint 2013 Performance
• Add IIS Response Header
• Get SharePoint Site Permissions
• Workflow Manager Disaster Recovery
WWW.SPBIZCONF.COM
My HP Official Blogs• Are you Hot, Cold or Warm
• SharePoint Capacity Management
• Efficient and Effective Communication with SharePoint