Upgrading W2K3 Server to MSXML SP2

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

Overview of Problem:
I'm experiencing some timeout issues that seem to be caused somewhere
between the IIS request to SQL and the response back to IIS. The issue seems
to me almost like a memory leak where the request responses get worse with
time. A restart of IIS seems to clear up the issue. Our NW admin ran an IP
trace and said that the request was getting to sql but the page never
renders. Upon further investigation, we found that our Db Server is running
MSXML sp2 while our web servers are running sp1. The DBA says that could
definately cause issues, possibly memory leaks, especially since we do have
stored procedures using the XML EXPLICIT clause.

Resolution:
I've been tasked with upgrading the web servers to SP2. After some
investigating, I find that we avoided upgrading in August of 2003 because we
had some issues that came about while trying to upgrade. I made the upgrade
on one of our development servers and ran into the same issue immediately.

Issue 1:
No data is available for the requested resource.
this is one of the lines of code that's erroring
doc.load(Request)
where doc = Server.CreateObject("MSXML2.DOMDocument.4.0")
async = false
setProperty "ServerHTTPRequest", true
validateOnParse = true

Upon scouring the internet a found that I could set the resolveExternals
property to false which seems to fix the download error but then the document
is not validated against my xsd file which then produces the xsi:nil
attribute invalid error message. I can then set the validateOnParse property
to false to stop that error. However, this obviously is not the correct
solution as I am seeking help.

Issue 2:
One of the asp pages accepts an incoming request as XML, disects the XML,
and creates a request to one of our partners using the ServerXMLHTTP object.
DIM http
SET http = Server.CreateObject ("MSXML2.ServerXMLHTTP")
http.open "POST", Application("site"), false
http.send (inputData)

the send method returns this to the page
<p>msxml4.dll</font> <font face="Arial" size=2>error '80070005'</font>
<p>
<font face="Arial" size=2>Access is denied.

Thanks for the help,
Trent
.

Relevant Pages

  • RE: Microsoft Security Advisory MS 03-007
    ... announcement covers IIS 5.1 but not IIS 6, ... > You say "IIS servers are actively being compromised already, ... -- permissions are checked on httpext.dll to see if Anonymous request ... CONFIGURATIONS OF THE IIS LOCKDOWN TOOL DO LEAVE WEBDAV ...
    (Bugtraq)
  • Re: Microsoft Security Advisory MS 03-007
    ... announcement covers IIS 5.1 but not IIS 6, ... > You say "IIS servers are actively being compromised already, ... -- permissions are checked on httpext.dll to see if Anonymous request ... CONFIGURATIONS OF THE IIS LOCKDOWN TOOL DO LEAVE WEBDAV ...
    (Bugtraq)
  • Re: Client IP behind Load Balancer
    ... request had to be NATed. ... So we will try to move servers into the same DMZ as the F5, ... > If requests are done through the public IP, then they go through the load ... and I only see the virtual private IP in the logs. ...
    (microsoft.public.inetserver.iis)
  • RE: Upgrading W2K3 Server to MSXML SP2
    ... "Trent USTA" wrote: ... > between the IIS request to SQL and the response back to IIS. ... > I've been tasked with upgrading the web servers to SP2. ...
    (microsoft.public.inetserver.asp.db)
  • Cannot generate a certificate using the Administrator template = no RADIUS!
    ... the request just hangs and an error shows in Active X like: ... posts, it could have been when SP3 was added, or when IE was updated. ... lockdown tool and restored the original settings (once we knew that CA ... have re-applied Q323172 on both the CA servers and clients ...
    (microsoft.public.win2000.security)