<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Office Web App server 2013 and Sharepoint 2013 - making them work together.

Published on
14,276 Points
8,176 Views
1 Endorsement
Last Modified:
Approved
Sharepoint 2013 Server and Office Web Apps 2013 Server should work well together, so, what is with : 'Sorry there was a problem word cannot open..' and 'You do not have permission while opening PowerPoint App'. Well, that is what happened in one project, and thought I would share my findings.

The main purpose of this project was to make the office web apps like ‘word, powerpoint, Excel, one note’ to work with sharepoint 2013.  My test environment was working fine where I used ‘http’ to access my sharepoint and office web apps 2013.  For my test environment I followed ‘http://stevemannspath.blogspot.ca/2012/10/installing-office-web-apps-server-for.html‘.  

The day I started to use the SSL with both sharepoint 2013 and Office web apps 2013, I could no longer see my web apps work.  I had followed all the "nice" articles:
 
- http://technet.microsoft.com/en-us/library/ff431687.aspx
- http://blogs.msdn.com/b/sowmyancs/archive/2012/10/29/install-configure-amp-monitor-office-web-apps-2013-for-sp-2013.aspx
 
But, everytime I opened the web app from sharepoint 2013 (documents) I got few Errors namely:
 
- Word ran into problem, can’t open the file, try opening the file with Microsoft word.
- Sorry there was a problem, word can’t open the file.
- While opening power point.  You do not have permissions….
 
I checked the logs from office web apps server under  ‘C:\ProgramData\Microsoft\OfficeWebApps\Data\Logs\ULS’ and found many logs of interest. In particular one message stood out ‘connection was refused ‘localip:80”, also many logs entries complained about my certificate.
 
Points to check:
 
- Make sure the certificate is a UCC certificate.  In my case I installed one certificate which was issued to my office web apps server Example: Generate the request from a physical machine instead of a virtual machine, went into comodo ssl site included the name of the office web apps server and my sharepoint server names in the ‘subject alternative name section and under the main domain name I used ‘officewebappSERVER.mydomain.com’.  import the whole certificate chain your personal store of both servers.  In office web app server do not bind the certificate manually follow the article:
 
http://blogs.msdn.com/b/sowmyancs/archive/2012/10/29/install-configure-amp-monitor-office-web-apps-2013-for-sp-2013.aspx
 
- In my case in sharepoint 2013 I had in alternate access mappings as default = ’http://sharepointservername2013′; and in internet = ’https://sharepointservername2013.  
I had to remove https://sharepoint2013servername from the internet section and had to change the default to https://sharepointservername2013.mydomain.com
 
This fqdn (servername.mydomain.com) made the difference all my web apps started to work.
 
Other Problems:
 
Under the sharepoint 2013 now the links to skydrive, newsfeed and sites still bound to http://sharepointservername and would not work.
 
Solution:
 
On sharepoint 2013 go toCentral Admin – Manage Service Apps – Click your User Profile service app.  In here you will see a link for Setup MySites.  This is where you need to update your URLS for skydrive, newsfeed, sites etc.

Hope some of the above might help you solve or avoid some of the problems I had experienced.
 
******************************************************************************************************
After Upgrade with SP1:

After installing SP1 for Sharepoint 2013 and Office Web Apps 2013.  while you click on the any office document from sharepoint 2013 you get 'sorry there is some problem'

Solution:
In my case the farm was re-created and the link to the certificate was broken.
On Office web apps server 2013 open powershell as an Administrator:
It will give you 'warning farm does not exist'
1) Create farm as:
In my case the internal and external address for office web apps servers is same.
New-OfficeWebAppsFarm -InternalUrl https://OFFICEWEBAPPSSERVER2013.mydomain.com -ExternalUrl https://OFFICEWEBAPPSSERVER2013.mydomain.com -EditingEnabled -AllowHttp:$true
2) PS C:\Users\administrator> import-module OfficeWebApps
PS C:\Users\administrator> Get-OfficeWebAppsFarm
Now there is no CertificateName, set the existing certificate as:
Set-OfficeWebAppsFarm -CertificateName 'UCCNew' (UCCNew is the name of my certificate)
You are all set, restart and wait about 30 min.
-check in sharepoint central administration for any service which needs attention.
Hope that helped.
1
Comment
Author:amanzoor
0 Comments

Featured Post

The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

Join & Write a Comment

Watch this simple and effective video tutorial to extract attachments from Outlook 2007 and try this easy method by yourself. No need to go anywhere, just watch the video and export attachments from Outlook in few simple steps. To know more, click h…
I've published three five-minute Experts Exchange video Micro Tutorials that describe terrific features in an excellent, free PDF product called PDF-XChange Editor: How to rotate pages in a PDF with free software (https://www.experts-exchange.com…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month