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. – Eric Maurer Aug 4 '10 at 19:57

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 '10 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" />? – Clayton Firth Apr 20 '10 at 6:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy