ExcelService, You donot have permission to open this file

Hi All,

I was getting this error from 3-4 days, and it was becoming frustrating, since the error is resolved I want to share my experience with all of you. The error from ULS log is-

1.       From ULS log the error is -            w3wp.exe (0x1EC0)                       0x21B4  SharePoint Server                           Logging Correlation Data               xmnv     Medium               Result=Id=OpenWorkbookAccessDenied; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: You do not have permissions to open this file. ---> Microsoft.Office.Excel.Server.Host.HostFileException     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.b__2()     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action)

• In my case ClaimsToWindows was set correctly,
• file  was under trusted file location
• App Pool account was added as owner in comtentDB

So nothing was helping me. Lastly I run the configwizard, which ended up in running farm config wizard (I did farm config earlier, noting helped). I cross varified web.config and what helped is -

IIS authentication settings :) The site and sharePoint web services both should run with "Windows Authentication" and it was resolved.
Some times we miss very simple point and that hurts badly :)

Keep programmig...