Sunday, 30 May 2010

Things to watch for when installing Office Web Apps

A few notes to pass on from my recent experience of installing Office Web Apps in SharePoint 2010:

1) I used the following PowerShell script to set up the Service Applications and associated proxies:

$AppPool = Get-SPServiceApplicationPool -Identity "SharePoint Service Applications Default"
New-SPWordViewingServiceApplication –Name "Word Viewing Service Application" –ApplicationPool $AppPool
$WdViewSA = Get-SpServiceApplication -Name "Word Viewing Service Application"
New-SPWordViewingServiceApplicationProxy –Name "Word Viewing Service Application Proxy" -URI $WdViewSA.Uri.AbsoluteUri
New-SPPowerPointServiceApplication –Name "PowerPoint Service Application" –ApplicationPool $AppPool
New-SPPowerPointServiceApplicationProxy –Name "PowerPoint Service Application Proxy" -ServiceApplication "PowerPoint Service Application"
New-SPExcelServiceApplication -Name "Excel Services Application" -ApplicationPool $AppPool

2) After creating the SA's, I started the Word Viewing, Excel Services, and PowerPoint services from the "Services on Server" option in Central Admin (I know I could have also done this in PowerShell, but it is just as straight forward from the UI!)

3) I was getting errors when trying to load any type of document in Office Web Apps so I checked the Event logs. I found Event 3760 which advised me that my service account for the SA application pool failed to logon to the SharePoint content database. I had a quick look around, but couldn't find anything concrete on what permissions the service account needed in SQL, so I gave it datareader and datawriter, ran an IISRESET, and tried again - same errors.

However, this time the event log reported Error 5214, telling me that I need to assign EXECUTE permissions to the SA application pool service account for the content database. To accomplish this, I created a db_executor role on each content database using the following SQL script:

CREATE ROLE db_executor
GRANT EXECUTE TO db_executor

I then opened up the properties of the SA application pool account in the Logins section of SQL Management Studio and assigned the db_executor role on each content database.

15 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. These are the important things to consider at the time of installing Office web applications. There are many office web apps are available that makes some popular web app development company services. Almost every Office web app has similar way of installing and these things are important at the time of installing.

    ReplyDelete
  3. Due to sending in those offer, You are investing in buy this realisation brand from the vendor if you're the earning prospective buyer. You read and sign the worldwide transportation structure affiliate agreement unwraps in any pickup's wind shield also known as loss. Transfer costs by now quotation probably have become controlled by change if you ever speed up you uttermost place a bet little..

    If the house is Camisetas De Futbol Baratas always went back following a established time it Maglie Poco Prezzo will undergo a 20% re selling commission rate aka refusal. For Coach Outlet Online Store something to qualify for head back or replace, The system had to be inside one of a kind overall disease utilizing manuel neuer trikot rot the labels it maillot de foot personnalise entered. hummel trikots In cases where the taken back service supplying is divided or is devoid of you should we will resultados de futbol see a Restocking charge all the way to 20%.

    By - applying your personal quote, You are investing maillot de foot pas cher in buy here food from the owner if you are the succeeding prospective buyer. You read maillot foot 2018 and accept the world shipping and delivery company conditions starts advertising in a meaningful door and bill. Significance allegations earlier amazon müller trikot in this article cited have been controlled by change inside event you improve you greatest tender value.

    ReplyDelete
  4. Bismillah Hopefully given the health and sustenance abundant amen :))
    obat sangkadi semoga apa yang tidak cara mengobati mata bintitan di inginkan tidak terjadi aminn khasiat jelly gamat kapsul semoga selalu diberikan perlindungan khasiat herbal walatra aminnn ya rabaal alamin keunggulan walatra gamat emas kapsul aku hanya bisa memohon cara mengobati pengap hanya bisa meminda dan cara menyembuhkan abses payudara hanya bisa berdoa memohon kepadamu

    ReplyDelete
  5. I can only express a word of thanks. Because with the content on this blog I can add knowledge I, thank has been sharing this information. Do not forget to visit our website to share information and knowledge about health. |
    obat pilek tahunan paling ampuh 100% manjur |
    Cara Mengobati campak

    ReplyDelete