HI,

my DTS package is using NT-authentication when logging in
to Sql Server. The intention is to have it scheduled, and
kicked off by the Agent Service. The question is: what
kind of credentials will by DTS process have ?

My own feeling is the DTS execution will inherit the
user-ID from the Sql-Server Agent Service. When that
service was started, a password would have been entered,
creating a valid security token.

But I've heard many other answers:
- that the scheduled package executes as the "owner" of
that package in DTS
- that the scheduled package executes as the "owner" of the
Schedule in the "Jobs" management tab

Confused.

from

http://support.microsoft.com/?kbid=269074


The security context in which the job is run is determined by the owner of
the job. If the job is owned by a login that is not a member of the Sysadmin
server role, then the package is run under the context of the account setup
as the SQL Agent Proxy Account, and has the rights and permissions of that
account.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Andrew" <andrew.schonberger (AT) ssmb (DOT) com.au> wrote