Prev: executing an SQL Stored procedure from within a function
Next: Outer Join newbe question
From: CSharpcoder on 2 Jul 2008 15:35
I need to run a job under a specific ID and password so it can read a file
on a shared drive. When I change the owner to this ID the job still fails,
how can I use a specific ID and password that has access to this shared
drive on the network?


From: Russell Fields on 2 Jul 2008 17:03
CSharpcode,

If you are using SQL Server 2005 you need to look at SQL Agent Proxies,
which use credentials that are created with a specific login AND password.
Read about those features in the Books Online.

If you are using SQL Server 2000, you have fewer options.

RLF

"CSharpcoder" <whyme(a)ihatespamhowaboutyou.com> wrote in message
news:eXfxPrH3IHA.2064(a)TK2MSFTNGP02.phx.gbl...
>I need to run a job under a specific ID and password so it can read a file
>on a shared drive. When I change the owner to this ID the job still fails,
>how can I use a specific ID and password that has access to this shared
>drive on the network?
>


 | 
Pages: 1
Prev: executing an SQL Stored procedure from within a function
Next: Outer Join newbe question