Hi,
I have set up various DTS packages and want to give various other staff members access to run them on demand. I have tried to run them as a job but get the following error 'Non_sysadmins have been denied permission to run cmdexe job steps. The step failed' Eventhough I am running from my administrator account. How can I run them or allow for cmdexe jobs?
Secondly, is it possible for workstations to invoke dts packages that do not run sql? Maybe through excel or asp?
I would greatly appreciate any help. Kind regards. Brett
I have set up various DTS packages and want to give various other staff members access to run them on demand. I have tried to run them as a job but get the following error 'Non_sysadmins have been denied permission to run cmdexe job steps. The step failed' Eventhough I am running from my administrator account. How can I run them or allow for cmdexe jobs?
Secondly, is it possible for workstations to invoke dts packages that do not run sql? Maybe through excel or asp?
I would greatly appreciate any help. Kind regards. Brett