[Help] SQL server jobs and permissions
From: Kenneth (kenneth_at_cybermind.com.hk)
Date: 05/27/04
- Previous message: DaveK: "RE: How do people use SQL in Win authenticated mode only?"
- Next in thread: Jasper Smith: "Re: [Help] SQL server jobs and permissions"
- Reply: Jasper Smith: "Re: [Help] SQL server jobs and permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: 27 May 2004 08:45:34 -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
- Previous message: DaveK: "RE: How do people use SQL in Win authenticated mode only?"
- Next in thread: Jasper Smith: "Re: [Help] SQL server jobs and permissions"
- Reply: Jasper Smith: "Re: [Help] SQL server jobs and permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
