asked on

XML error: Access to the specified file path is denied

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 https://x.x.xxx.xxx(my 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.

Thanks.

Sihua

dnojcd

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

you can also try this. try running filemon from www.sysinternals.com 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.

shambhusingh2004

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

Warm Regards,

Vipin Gupta

sihua

ASKER

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.

Sihua

shambhusingh2004

Hi Sihua -

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

Warm Regards,

Vipin Gupta

ASKER CERTIFIED SOLUTION

DarthMod

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial