Re: [Help] SQL server jobs and permissions

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 19:51:23 +0100

In order for non sysadmins to run CmdExec jobs you need to configure a proxy
account. Have a look at xp_sqlagent_proxy_account in BOL 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kenneth" <kenneth@cybermind.com.hk> wrote in message
news:2e7d1f14.0405270745.6c9d4@posting.google.com...
> 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

Relevant Pages

  • RE: Extended sps work only for windows sysadmin accounts-sql serv
    ... ALL sysadmins CAN execute xp_cmdshell. ... developed and registered XPs that worked on sql server 2000. ...
    (microsoft.public.sqlserver.server)
  • Re: Job owned by a non-sysadmin fails to run
    ... I have a SQL Server 2000 SP4. ... As advised in many posts I created a Proxy SQL Server Agent account ... I made this account belong to the sysadmins ... I added the account sqlservice to Administrators as advised in the article ...
    (microsoft.public.sqlserver.security)
  • Re: add new user with all rights to all dbases
    ... If it is OK to have sysadmins privileges for the person, just add a login for the person, and make ... > database administrator that could administer all dbases. ... >> Add that new user to the sysadmins SQL Server group inside SQL Server. ... I hope that this is the user account ...
    (microsoft.public.sqlserver.server)
  • Re: Securing a web DB
    ... If your ISP has only one SQL server instance then you can't do much since ... control sysadmins, ...
    (microsoft.public.sqlserver.security)
  • Re: Last TSQL Command Batch view
    ... Obviously you will want to make sure that the security on the ... Certainly don't make them sysadmins just for this:) ... Pro SQL Server 2000 Database Design - ... >> Is there any way to grans access to any user to have access to view the ...
    (microsoft.public.sqlserver.programming)