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!

link|improve this question
feedback

2 Answers

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.

link|improve this answer
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=12.0.0.0, 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=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />? – Clayton Firth Apr 20 '10 at 6:14
feedback

Are you using Claims Authentication? I am having a similar problem when I use mixed authentication.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown