Wednesday, 23 November 2011

Unable to Open Excel in Sharepoint 2010 "The workbook cannot be opened" Error

error

I’ve got this error , pretty much the same as everyone else.

WorkBookError

http://blogs.msdn.com/b/jjameson/archive/2010/05/04/the-workbook-cannot-be-opened-error-with-sharepoint-server-2010-and-tfs-2010.aspx

http://geekswithblogs.net/AmanGarg/archive/2011/04/23/unable-to-open-excel-in-sharepoint-2010-the-workbook-cannot.aspx

In the log as described I got the error

   1:  
   2: Insufficient SQL database permissions for user 'Name: BEILUX\svc_spdservice 
   3: SID: S-1-5-21-2123242984-1537360481-1219115889-45643 ImpersonationLevel: None' 
   4: in database 'WSS_Content_8080_DEV1_CORP_d3e5b5ca599743afba85046cee6e5a71' on SQL 



But just running the PowerShell did’nt work

$webApp = Get-SPWebApplication http://myServer

$webApp.GrantAccessToProcessIdentity("MyDomain\svc-spserviceapp
")
So I had to also grant dbo to the service user svc_spdservice. I know in the  jjameson blog it is not needed after the powershell but it was for me.
 

No comments:

Post a Comment