Scheduled Tasks which generate M/S Office output files will not run in Windows Server 2012 that did run in Windows2003 Scheduled Tasks

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?
PSERS BITNetworkAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lionel MMSmall Business IT ConsultantCommented:
What errors are been generated when you run these scheduled tasks? In the history tab what are the outputs there? Can you add logging to your script to output what is happening? And specifically which office formats are you wanting?
David Johnson, CD, MVPOwnerCommented:
these items probably require a logged on user.
PSERS BITNetworkAuthor Commented:
We found the following article from Microsoft which states running Office Application are not supported and should not be run via automation functions and should only be run under an interactive desktop session.

https://support.microsoft.com/en-us/kb/257757

"Interactivity with the desktop: Office applications assume that they are being run under an interactive desktop. In some circumstances, applications may need to be made visible for certain Automation functions to work correctly. If an unexpected error occurs, or if an unspecified parameter is needed to complete a function, Office is designed to prompt the user with a modal dialog box that asks the user what the user wants to do. A modal dialog box on a non-interactive desktop cannot be dismissed. Therefore, that thread stops responding (hangs) indefinitely. Although certain coding practices can help reduce the likelihood of this issue, these practices cannot prevent the issue entirely. This fact alone makes running Office Applications from a server-side environment risky and unsupported"

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PSERS BITNetworkAuthor Commented:
Found Microsoft article stating running Office Applications in the Scheduler is an unsupported configuration.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.