execute process task and 'Request Operation Requires Elevation" error

Question

execute process task and 'Request Operation Requires Elevation" error

ManicStar

SSCoach

Points: 17992
More actions
December 13, 2016 at 2:41 pm

#401203

Hi,
Getting the message "[Execute Process Task] Error: An error occurred with the following error message: "The requested operation requires elevation"."
I've tried to date:
1) Calling this 3rd party .exe from a shortcut with 'run as admin' set
2) Wrapping it in Powershell to do basically the same thing.
Either i get a UAC prompt that makes me hit 'Yes' or or get the lovely message i opened the thread with. Anyway to quietly elevate the privilege and execute the .exe?
Anything i can do to UAC to make it trust the .exe?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

Manic Star (12/13/2016)
Hi,
Getting the message "[Execute Process Task] Error: An error occurred with the following error message: "The requested operation requires elevation"."
I've tried to date:
1) Calling this 3rd party .exe from a shortcut with 'run as admin' set
2) Wrapping it in Powershell to do basically the same thing.
Either i get a UAC prompt that makes me hit 'Yes' or or get the lovely message i opened the thread with. Anyway to quietly elevate the privilege and execute the .exe?
Anything i can do to UAC to make it trust the .exe?

There's always the option of turning off UAC, but that's probably not a "good" option. You may need to actually be a local admin on the machine you're running this application on, however, and there may not be any way around it. You should check with the folks that wrote this application and see exactly what it's requirements are. And just for safety's sake, a quick virus scan of it's files wouldn't hurt...

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

ManicStar SSCoach Points: 17992 More actions · Answer 2

I solved my problem by running the necessary .exe through a task scheduler task, and calling the task from SSIS.

Windows really needs a SUDO command 🙂

ManicStar SSCoach Points: 17992 More actions · Answer 3

sgmunson (12/14/2016)
Manic Star (12/13/2016)
Hi,
Getting the message "[Execute Process Task] Error: An error occurred with the following error message: "The requested operation requires elevation"."
I've tried to date:
1) Calling this 3rd party .exe from a shortcut with 'run as admin' set
2) Wrapping it in Powershell to do basically the same thing.
Either i get a UAC prompt that makes me hit 'Yes' or or get the lovely message i opened the thread with. Anyway to quietly elevate the privilege and execute the .exe?
Anything i can do to UAC to make it trust the .exe?
There's always the option of turning off UAC, but that's probably not a "good" option. You may need to actually be a local admin on the machine you're running this application on, however, and there may not be any way around it. You should check with the folks that wrote this application and see exactly what it's requirements are. And just for safety's sake, a quick virus scan of it's files wouldn't hurt...

I know the author of this exe, so what i'm trying to do is pretty safe for this project. The task scheduler solution works w/o doing any mods to the UAC on the server.

richu.thakur2007 SSC Journeyman Points: 79 More actions · Answer 4

sgmunson - Wednesday, December 14, 2016 7:47 AM
Manic Star (12/13/2016)
Hi, Getting the message "[Execute Process Task] Error: An error occurred with the following error message: "The requested operation requires elevation"." I've tried to date: 1) Calling this 3rd party .exe from a shortcut with 'run as admin' set2) Wrapping it in Powershell to do basically the same thing. Either i get a UAC prompt that makes me hit 'Yes' or or get the lovely message i opened the thread with. Anyway to quietly elevate the privilege and execute the .exe? Anything i can do to UAC to make it trust the .exe?
There's always the option of turning off UAC, but that's probably not a "good" option. You may need to actually be a local admin on the machine you're running this application on, however, and there may not be any way around it. You should check with the folks that wrote this application and see exactly what it's requirements are. And just for safety's sake, a quick virus scan of it's files wouldn't hurt...

@manic star: I am also facing the same problem.My SSIS package was created using SQL Server 2008 and the package is upgraded to 2014. So when i am trying to run the package the Execute Process Task fails and throws the error
"The requested operation requires elevation".
Can you help me with the script and steps to handle this error.