XML error: Access to the specified file path is denied

Posted on 2006-06-05
Last Modified: 2012-08-14
Hello, Experts,

One of  my xml file stopped working today, the message I got when trying to browse it is like below, i typed in at a browser server's ip)/PandCXML/ProjectStartDate.xml. Can someone tell me what the problem could be? I checked its properties on IIS Virtual Directory Management for SQL Server, the login it uses is valid.

ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: Access to the specified file path is denied.


Question by:sihua
    LVL 10

    Expert Comment

    have you changed any permissions recently of the physical folder where you xml files resides?

    you can also try this.  try running filemon from while you  attempt to browse the xml file. If its an acl's issue you will see that show up as an Access Denied in filemon. It should also tell you on what  file or directory and what user was denied rights.
    LVL 6

    Expert Comment

    Please make sure that your SQL DBusername + password is correct in MSXML configuration.

    Warm Regards,

    Vipin Gupta

    Author Comment

    The work around is...I deleted the one that is not working from SQLXML, and created a new one with same name and all the settings, and it works now......But I still don't understand why with the previous one, the configurations are same, but it just didn't work....

    Thanks for all your kind comments.

    LVL 6

    Expert Comment

    Hi Sihua -

    There may possible that someone try to change SQLXML configuration like change SQL server name,username & pasword.

    Warm Regards,

    Vipin Gupta
    LVL 1

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Logparser is the smartest tool I have ever used in parsing IIS log files and there are many interesting things I wanted to share with everyone one of the  real-world  scenario from my current project. Let's get started with  scenario - How do w…
    What is an ISAPI filter?   •      It's an assembly (.dll file) that can add or change the way IIS works.   •      They can be enabled globally for your web server or on a site-by-site basis.   When the IIS server receives a request, enabling the ISAPI fi…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now