Mrbaseball34
Programmer
In their infinate wisdom, M$ has deemed that some
processes are only allowed to be killed by users if
they were not started by the SYSTEM account.
We have several processes that may be started by
SQLSERVERAGENT service and they are started using the
SYSTEM account and we need to kill them in order to
install new versions. Let me say that we have tried the
Replace In-Use Files option and it doesn't work because we
also want rollback capabilities; we attempt to rename the
directory that these utilites are in so we may rollback in
case of errors.
Now, the rename isn't happening because of the in-use file
(s) and we need to kill these processes if they are
running but none of the Kill Process scripts from the
script library work. I have stepped throught them and
found that the error returned when trying to open the
process to get the process handle is "Access denied".
BTW, I am able to kill it using Task Manager because TM
runs in the SYSTEM account.
Any thoughts on a solution or how to impersonate the
SYSTEM account to kill these processes?
processes are only allowed to be killed by users if
they were not started by the SYSTEM account.
We have several processes that may be started by
SQLSERVERAGENT service and they are started using the
SYSTEM account and we need to kill them in order to
install new versions. Let me say that we have tried the
Replace In-Use Files option and it doesn't work because we
also want rollback capabilities; we attempt to rename the
directory that these utilites are in so we may rollback in
case of errors.
Now, the rename isn't happening because of the in-use file
(s) and we need to kill these processes if they are
running but none of the Kill Process scripts from the
script library work. I have stepped throught them and
found that the error returned when trying to open the
process to get the process handle is "Access denied".
BTW, I am able to kill it using Task Manager because TM
runs in the SYSTEM account.
Any thoughts on a solution or how to impersonate the
SYSTEM account to kill these processes?