We are migrating from older Window 2003 servers to New Windows 2012 Std. Edition servers. We have a large quantity of "Scheduled Tasks" scripts that output M/S Office formatted files, mainly reports that save to Excel files. These have run correctly for some time on the 2003 servers but do not run from scheduled task on the Windows 2012 servers. I can run the batch file by themselves or from a command line and there are no problems. It's only when task scheduler tries to run it there's a problem. We've also tried checking the box to "run with highest privileges" and as Local Administrative accounts and Domain Admin accounts but it doesn't make a difference.
We have found that if we modify the scripts to output as a .CSV file then they all run successfully, we also found that we can run .exe files, or copy file scripts all fine through the scheduler but appears anything that deals with M/S office formats will not run.
We have installed M/S Office 2010 on the servers we are trying to run scripts from so that it should have any necessary Office files that it would need. Does anyone know what needs to be done to make theses scripts run from the Windows Scheduler in Server 2012?