Problem with exporting to network location with scheduled server script

[Jon Schlatter]

I am attempting to implement a new script that will export data from a linked SQL table (with server level ODBC) into a csv file (created using an XML export with XSLT).

The process works without issue when I open the file on my client (from the hosted server) and run the script. However, when I try to schedule the same script to run from the server I am getting an '800' error. I tried writing to the local server, different network locations and get the same result.

Hopefully I have provided enough information. I would be glad to add any details needed if I can get to a working result.

Edited September 30, 2009 by Guest

[James Marshall]

Hi Jon,

Are you exporting to the documents folder in the server directory?

- James Marshall

www.soliantconsulting.com

[Steven H. Blackwell]

See this FMF article for information about exports. An OS script would then have to move the exported file. It will need appropriate permissions.

Steven

[Jon Schlatter]

I had tried that before with no success. I just reset it again and was able to get it working this time. I believe it was giving the local service access rights that did the trick.

Seems odd that FM would not set the server to use the account that the service runs under and then allow for using Active Directory accounts and network directories. I do this all the time with scripting and it works like a charm...

Thanks for the help!