We are trying to call the Excel Services web service using SOAP with a Sharepoint/domain admin account.

I see 401.2 errors in the IIS logs. There is no user name specified there. We are using NTLM authentication.

Has anyone been able to connect to the web service and open a workbook successfully? Any ideas on my authentication woes?

Thank you in advance!

  • Are you using Claims Authentication? I am having a similar problem when I use mixed authentication. Aug 4, 2010 at 19:57

1 Answer 1


Had a situation which sounds similar to this a few months ago. One of the config features that I was using changed the order of the httpHandlers section of the config file. Try checking that the element appear before all the "add" elements.

  • In the HttpHandlers section i have: <remove verb="GET,HEAD,POST" path="" /> <add verb="GET,HEAD,POST" path="" type="Microsoft.SharePoint.ApplicationRuntime.SPHttpHandler, Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add verb.. Type=Microsoft.SharePoint.ApplicationRuntime.SPHttpHandler
    – Anonymous
    Apr 14, 2010 at 13:24
  • do you have <add verb="" path=".asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />? Apr 20, 2010 at 6:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.