• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 607
  • Last Modified:

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
0
sihua
Asked:
sihua
1 Solution
 
dnojcdCommented:
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.
0
 
shambhusingh2004Commented:
Please make sure that your SQL DBusername + password is correct in MSXML configuration.

Warm Regards,

Vipin Gupta
0
 
sihuaAuthor Commented:
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
0
 
shambhusingh2004Commented:
Hi Sihua -

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

Warm Regards,

Vipin Gupta
0
 
DarthModCommented:
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now