How do I run Excel 2016 from a Service Account, on a Server.

Matthew Siple 0 Reputation points
2024-05-08T21:05:04.5366667+00:00

I have written an automation in Python that calls a VBA script in an Excel Sheet. Everything works fine until I try to execute them on a server. When I am logged into the server everything works fine also. But, as soon as I am logged out of the server the excel sheet stops running. I get the following error:

"(-2147467238, 'The server process could not be started because the configured identity is incorrect. Check the username and password.', None, None)"

  • I have searched for this error and the web says I have a corrupt file somewhere. (I don't, I have run the scan and fix and it found nothing.
  • I have tried different modules in Python it did not work.
  • I have tried using PowerShell to call the VBA script. Again, it works fine with my Account but not when it is run under the service account when I am not logged in.
  • At first I had some problems running it under the Service Account, but we read up on it and there were a few tweaks we needed to make to the Com objects etc.. and go it to work. ( Well work when I am logged in.)
  • I have tried running it from a batch file, from the command line and from Python. No dice.

I understand this is not supported by MS, but my Boss insists that it can be done. If my Boss says it can be done, then I am obliged to make it happen. ( I am sure I am not alone in this.) Does anyone have any clue on how to do this.

Thanks,

-matt

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,366 questions
0 comments No comments
{count} votes