![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I've shceduled a job under sa account (I've changed the password though ),this job access local folder of the box running SQL server.I haveadded sa to the sysadmin role and it dose have access to the local folder .How is it possible as *sa* is a sql server account and how it has the enough permissions to access local file system? Thanks a lot |
#3
| |||
| |||
|
|
It's executing under the security context of the SQL Agent service account. It's explained in the following article: http://support.microsoft.com/?id=269074 -Sue On Mon, 8 Aug 2005 16:24:44 -0700, "J-T" <J-T (AT) nospam (DOT) com wrote: I've shceduled a job under sa account (I've changed the password though ),this job access local folder of the box running SQL server.Ihave added sa to the sysadmin role and it dose have access to the local folder .How is it possible as *sa* is a sql server account and how it has the enough permissions to access local file system? Thanks a lot |
![]() |
| Thread Tools | |
| Display Modes | |
| |