[Help] SQL server jobs and permissions
From: Kenneth (kenneth_at_cybermind.com.hk)
Date: 05/27/04
- Next message: Kevin3NF: "Re: @@Identity & Server Farm"
- Previous message: Rick Allison: "@@Identity & Server Farm"
- Next in thread: JDP_at_Work: "Re: [Help] SQL server jobs and permissions"
- Reply: JDP_at_Work: "Re: [Help] SQL server jobs and permissions"
- Messages sorted by: [ date ] [ thread ]
Date: 27 May 2004 08:46:30 -0700
Dear all,
I have created a CmdExec job step that call cscript.exe to run a WSF
script. The task is owned by a user not in the SysAdmin group. When I
start the job, it fails with something like this:
CScript error: Unable to load configuration. (Access denied)
It works if I change its owner to "sa". I tried to grant the EXEC
permission on xp_cmdshell (is it relevant?) to that user but it
doesn't help.
If anyone knows please help me. Thank you very much.
Ken
- Next message: Kevin3NF: "Re: @@Identity & Server Farm"
- Previous message: Rick Allison: "@@Identity & Server Farm"
- Next in thread: JDP_at_Work: "Re: [Help] SQL server jobs and permissions"
- Reply: JDP_at_Work: "Re: [Help] SQL server jobs and permissions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
