Just wanted to update with additional information about what we discovered over the weekend -- calls to SharePoint web methods from an IP browser form fail in your environment. We tested with CheckOutFile -- verified the query worked correctly in client, admin approved the template and opened it and tried the query in the browser and had a failure. The log contained similar info to the previously posted log:
05/28/2011 11:52:51.88 w3wp.exe (0x2060) 0x23F8 SharePoint Foundation General 8e2s Medium Unknown SPRequest error occurred. More information: 0x80070005 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.89 w3wp.exe (0x2060) 0x23F8 SharePoint Foundation General avfx High SOAP exception: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.SharePoint.Utilities.SPUtilityInternal.SendResponse(HttpContext context, Int32 code, String strBody) at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(HttpContext context) at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(Exception ex) at Microsoft.SharePoint.Library.SPRequest.GetFileAndFolderProperties(String bstrUrl, String bstrStartUrl, ListDocsFlags ListDocsFlags, Boolean bThrowException, Int32& phrStatus, Object& pvarFiles, Object& pvarDirs, UInt32& pdwNumberOfFiles, UInt32& pdwNumberOfDirs) at Microsoft.ShareP... 7e3795ea-040e-40e2-84f4-83ec3c32cf1e