I have a windows service that will get data from database and create excel spreadsheet on hard drive. now this service is required to run on windows server 2008, however, it failed when call saveas method. the error is "System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC"
However, I also have a test windows form app which use exactly same code, and I can run that app successfully on windows server 2008, create/read the spreadsheet just fine.
I'm wondering if there's some new restriction for windows service? how can i remove the restriction so my service can save the file.