Friday, May 8, 2009

How to access network file in SQL

How can I access network XML file from SQL server store procedure?

A procedure which is accessing local file "C:\xyzConfig\xyz.xml" as one of the string parameter.

Now my SQL instance is changed to different server but XML location is same.

I tried "\\SERVER100\c$\xyzConfig\xyz.xml" but It won't work.

Error throw as

"....... could not be opened. Operating system error code 5(Access is denied.)."


here how I resolve with your help,

1) I have a web application on Server100 with IIS & etc..
2) SQL instance is a cluster on Server400 which doesn’t have IIS & etc..
3) make share folder on Server400, Drive X, then I can access file from SQL as local file. Share with read & write permission for domain users
4) but no IIS on Server400 so, it is not allow me to set Web Sharing folder.
5) So, From web app. i have to set up

6) after all I can access file from both process.

No comments: