01 diciembre 2008

Troubleshooting Excel Services

I got an "Access denied. You do not have permission to perform this action
or access this resource" while trying to render an Excel in Web Browser
mode. After one hour carefully examining logs I found the problem. The
Shared Services Application Pool was configured with anonymous
authentication in IIS, which lead to an authentication problem.

Excel Services logs, at 12 hive showed the authentication problem:
ExcelService.ProcessRequestIdentity: IIS didn't pass us an authenticated
user, Check that the virtual folder is set to authenticate using
WindowsIntegrated
A user attempted to access Excel Services, but was denied because they do
not have a domain or local machine identity. [User: ]
Access denied. You do not have permission to perform this action or access
this resource. At (..)

IIS logs showed no user was passed to application:
2008-12-01 17:50:24 W3SVC1720207907 VMSHPP 127.0.0.1 POST
/SharedServices1/ExcelCalculationServer/ExcelService.asmx - 56737
VMSHPP\Administrator 127.0.0.1 HTTP/1.1
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+2.0.50727
.3053) - - vmshpp:56737 200 0 0 27634 1207 78

Hope this helps...