Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naushi
Starting Member
10 Posts |
 Posted - 2009-01-29 : 16:28:13
|
| I am trying to run a job from sql server 2005 - the job runs a batch file (which resides on an app server 6064) which reads a file which also resides on app server 6064 and loads it to a table in the database using bcp command. when i run the job from the database server 1644 i used a mapped drive to map to the folder where the file is, it does not find the file. I then tried to use the full path of the app server 6064 to read the file i get an error 'access denied' - I can run the job wihtout an issue manually from 6064. How can I make it work form the database server 1644.naushi hussain |
|
|
tonymorell10
Yak Posting Veteran
90 Posts |
Posted - 2009-01-29 : 16:31:54
|
| The job on 1644 is running under the security context of the SQL Agent. My guess is that he NT acount SQL Agent is running under does not have permissions to the folder on server 6064. |
 |
|
|
naushi
Starting Member
10 Posts |
Posted - 2009-01-29 : 16:46:22
|
| thanks Tony - the accout that owns the job has administrative rights on the 6064 server. when we run it manually it works but not when oyu schedule it so your hunch may be right. How do we figure out what NT account is that agent usingnaushi hussain |
|
|
|
|
|
|
sql server jobs