A brief overview:
I have a Sharepoint 2010 installation on Windows Server 2008 R2, with Office Web Apps installed. The Central Admin SQL Database in on the local server, but the SQL database that houses the Web Application's data is on a different server. As the title alludes, there is inconsistent behaviour when it comes to opening supported documents within Office Web Apps on the website as any user, including the administrative account.
- Excel spreadsheets(.xlsx) can be opened and edited normally. Users (assuming proper privileges) can view and edit these documents just fine. This has been working fine with no problems.
- Word documents (.docx) when clicked on to be viewed, load the ribbon with "File", "Open in Word", and "Edit in Browser" options. However, where the Word document data should be, it spins on "Loading..." then spits out the "Word Web App cannot open this document because the server is still processing the document. Try later" error with an error id. BUT when I click Edit in Browser, it opens up just fine and allows users to edit and save changes!
- Powerpoint presentations do not allow a user to view or edit. When trying to view, it gives "Either network connectivity has been lost or the server is too busy to service your request." When try to edit, it gives "PowerPoint Web App encountered an error. Please try again."
With all of the above tests, I made dummy documents that are empty to rule out file size or corrupt files being an issue. It's odd that spreadsheets have normal control, but the others don't(and that they have different behaviour. If it were permissions wouldn't they have the same problems?)
What I have tried and checked so far:
Sharepoint and OWA are installed on the server.
OWA is activated for the site collection.
I changed browser file handling from 'Strict' to 'Permissive', with no change. (described here as a potential solution: Office Web Apps - Word Cannot Read, But Can Edit)
Restarted the Powerpoint and Word Viewing services, with no change.
-Checked the Powerpoint service pool; it was on "Web Services Default". Tried making a new pool using Network Service account under the Predefined account, but it didn't work. Even tried the other pools for kicks and no dice.
-Checked the Manage Service Connections under Application Management->Manage Web Applications, and the services were checked. (as recommended on various blogs and other online sources)
After looking at this thread(Office web app error SharePoint 2010), it seems like my issue could be related to the last point SPDoctor mentioned.
How would I check if the service account doesn't have the right permissions to access the content database? What are all the accounts that need permissions on the SQL database(which, as I mentioned at the beginning, is on a different server entirely) and what permissions should they have?
What's interesting is that it doesn't affect Excel, partially affects Word documents, and fully affects Powerpoint. Should I run the Sharepoint products configuration wizard again? Or could reinstalling OWA solve my problem(while keeping all of my documents intact)?
Could I get a nudge in the right direction? What am I doing incorrectly?