Re: execute a stored job through MS ACCESS 2000

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/03/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 02 Sep 2002 21:28:17 -0600

If the user is not a sysadmin then the user needs to own the
job to execute sp_start_job. The job will run under the
security context of the proxy account. If you haven't
configured the proxy account, the job will fail.
The proxy account is used for the security context when jobs
or commands (e.g. xp_cmdshell) are executed by
non-sysadmins.
You can find more info on the proxy account by search books
online for: xp_sqlagent_proxy_account

-Sue

On Sat, 31 Aug 2002 10:00:37 +0200, "Oskar"
<o_vaia@hotmail.com> wrote:

>hi,
>
>i would like to execute a stored job through MS ACCESS 2000 from a
>client-pc, who is not member of the sysadmin-roule.
>the job execute a DTS package.
>
>here my code in VBA:
>
>----
>----
>dim conn as ADODB.connection
>set conn = new ADODB.connection
>conn.open "Provider=SQLOLEDB;Data Source=SQLSERVER;Initial
>Catalog=salesDB;Integrated Security=SSPI;"
>conn.execute "EXEC msdb.dbo.sp_start_job @job_name = 'salesstat'"
>conn.close
>set conn = nothing
>----
>
>when i try to run the makro then it'll not function.
>
>on the server is running SQL Server 2000 with SP2.
>the server use windows authentication.
>what must i do to run the job with a non sysadmin-member-account?
>
>what is the PROXY ACCOUNT and how is it to use?
>
>thx and bye
>
>Oskar
>
>(sorry, for my english!)
>

Relevant Pages

  • Re: xp_cmdshell
    ... When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed ... which the SQL Server service is running. ... Set the "Non sysadmin job step proxy account ... > I have a user and I want to to give persmission of that user to execute ...
    (microsoft.public.sqlserver.clients)
  • Re: How can I grant user run cmdexec
    ... First you can give grant execute on xp_cmdshell (gtrant execute on ... If they are not a member of the sysadmin role then they execute it under the ... prefix of the SQL Agent Proxy Account. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Agent Proxy Account / XP_CMDSHELL
    ... The proxy account is unrelated to SQL Server object permissions. ... must have xp_cmdshell execute permissions when xp_cmdshell executed ... execute permissions on xp_cmdshell. ...
    (microsoft.public.sqlserver.security)
  • Re: xp_cmdshell default path (system32) problem
    ... I've used the proxy account several times before. ... SQL script that contains the xp_cmdShell is executed while logged in as 'sa' ... - specify the full path in the del command ... I'm use xp_cmdShell to execute "erase" command like ...
    (microsoft.public.sqlserver.programming)
  • Re: How can I grant user run cmdexec
    ... Unable to set the SQL Agent proxy account because of the reason listed ... > First you can give grant execute on xp_cmdshell (gtrant execute on ... >> grant the user have the rights to run this DTS but not ...
    (microsoft.public.sqlserver.security)