SharePoint 2010 Office Web Apps on a single server SharePoint Foundation –> Issues and Fixes

I finally found some time to get the Office Web Apps working on one of my servers running SharePoint Foundation 2010 beta

This is the server that I had upgraded from WSS 3.0 etc. As you may recall, I had completely uninstalled my SharePoint 2010 Foundation and WSS 3.0 after successfully having upgraded my WSS 3.0 site collection to SharePoint 2010. This enabled me to have a “clean” installation of Foundation. After all that,  I decided to give Office Web Apps a try. The installation went smoothly and after running psconfig, all service applications were up and running.

So I gave it a try and as expected it did not work….bummer … That was some weeks ago. I finally found the time to get this fixed. I googled around a bit and found an article by Kylie Richardson.

She had run into the same issue I had, where the Word Viewer refused to render the document. Apparently this is an issue if you are running SharePoint Foundation on a Domain Controller. The system I am running is running so much more than that :)

In my case the solution did not work. I got error messages in the eventlogs stating that my Excel services and Word Services were not properly registered in the Config database.

Finally I decided to follow Kiley’s article all the way where she installed Foundatation and Office Web Apps before running the SharePoint 2010 Products and Configuration Wizard to create the farm.

The steps I took:

  • took a backup of my site collection
  • uninstalled Office Web Apps
  • then uninstalled SharePoint Foundation 2010
  • reinstalled SharePoint Foundation 2010 without running SharePoint 2010 Products and Configuration Wizard
  • reinstalled Office Web Apps
  • ran SharePoint 2010 Products and Configuration Wizard
  • restored my site collection
  • executed the suggested commands by Kylie:

$e = Get-SPServiceApplication | where {$_.TypeName.Equals(“Word Viewing Service Application”)}
$e.WordServerIsSandboxed = $false
$e.WordServerIsSandboxed

#(Please use the below script for PowerPointServiceApplication – You need to enter “Y” for the answer of each cmd)
Get-SPPowerPointServiceApplication | Set-SPPowerPointServiceApplication -EnableSandboxedViewing $false
Get-SPPowerPointServiceApplication | Set-SPPowerPointServiceApplication -EnableSandboxedEditing $false

In the server’s c:\windows\system32\inetsrv\config\applicationHost.config
Add the line below in the end of the dynamicTypes.
<add mimeType=”application/zip” enabled=”false” />

IISRESET

So there I was with my completely reinstalled SharePoint Foundation

Cool. So now Office Web Apps works…..or NOT!

After having doen all these actions, it still didn’t work. I remebered for Excel Services that you need to configure the Trusted File Locations, so I went to the Service Applications, Selected Excel Services and added a trusted file location for my site collection –> No Luck, still didn’t work.

At this point I went back to basic troubleshooting…Eventlog and bam! There was an error indcation that my SharePoint Farm Service account was unable to open my content database, which was not there before having reinstalled everything. As a fix I added my SharePoint Farm Service account in the permissions of my content database and voila, Office Web Apps works!

As it turns out, I am using different accounts for my Application Pools as everyone should and the Excel Services and Word Viewing Service seem to use the default SharePoint Farm Service account for accessing the content.

So again, nice to know, isn’t it ? [:D]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>