execute a stored job through MS ACCESS 2000

execute a stored job through MS ACCESS 2000

Post by Oska » Sun, 01 Sep 2002 17:00:37



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.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!)

 
 
 

execute a stored job through MS ACCESS 2000

Post by Sue Hoegemeie » Wed, 04 Sep 2002 12:28:17


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"


>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.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!)


 
 
 

execute a stored job through MS ACCESS 2000

Post by Oska » Thu, 05 Sep 2002 00:11:43


hi Sue,

i've read the article xp_sqlagent_proxy_account in the online book.
i've tried many things;
- create new user (for proxy acc.) in AD and assign it to the
administrator-group
- in sql-server i have set the proxy-account

i tried really all, but i can't execute the package from the client-pc.
i don't really know what other i can try.

bye

Oskar



> 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"

> >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.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!)

 
 
 

execute a stored job through MS ACCESS 2000

Post by Sue Hoegemeie » Thu, 05 Sep 2002 11:10:39


Oskar,
Do you receive an error number and error message? Posting
that might help identify what the problem is.

-Sue

On Tue, 3 Sep 2002 17:11:43 +0200, "Oskar"


>hi Sue,

>i've read the article xp_sqlagent_proxy_account in the online book.
>i've tried many things;
>- create new user (for proxy acc.) in AD and assign it to the
>administrator-group
>- in sql-server i have set the proxy-account

>i tried really all, but i can't execute the package from the client-pc.
>i don't really know what other i can try.

>bye

>Oskar



>> 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"

>> >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.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!)

 
 
 

1. execute stored job through MS ACCESS 2000

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.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!)

2. Date format change in DBGrid??? - GULP

3. execute stored procedure from MS Access 2000

4. Dynamic vs Static Stored Procedures

5. Executing a SQL2000 Store Procedure via MS Access 2000

6. Migrate from MSSQL6.5 to MSSQL2000

7. Executing Stored Procedures in Access 2000 VBA

8. Y to Date use in BO

9. Executing a PL/SQL job in MS-ACCESS/Visiual Basic

10. replication between ms access 2000 and ms sql sever 2000

11. Execute a stored querry in MS Access with DAO

12. data environment - stored procedure - ms access 2000 db

13. MS Access 2000 to SQL Server 7 - Stored Procedure