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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-04-14 : 08:23:24
|
| I've got an SQL job which looks for files in a folder and imports them into SQL.It's running fine on one server, while another server is getting denials on folder access.I checked the installation that is operating properly and the Job's "owner" is a SQL Login, not a windows login.I'd like to understand the user/role/folder permissions of SQL jobs better. Are SQL jobs run under a "system" windows login, or are file system permissions assigned to SQL Logins? |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-04-14 : 08:46:03
|
| Bonus kudos to first respondent with the solution. |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-04-14 : 10:04:39
|
| to make this work, I would change the job owner to the account that the SQL Server Agent is running under if this account is a domain user account and then I would make sure this domain user account has the proper folder permissions.Sean Roussy |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-04-14 : 15:22:10
|
| It depends on how your job is attempting to access the file:XP_CMDSHELL, DTS, VB Script, SP_OA with file system object, BCP, Bulk Insert, etc.It also depends on the accounts that SQL Server, Agent, or Proxy are setup to use. It also depends on the permissions on the share or directory you are using. It also depends on how the SQL Server login you are using for the job is setup.Since you haven't supplied any specifics, it's tough to guess.CODO ERGO SUM |
|
|
|
|
|
|
|
|
SQL Job owner