Re: Error running DTS package on a schedule (only!)
- From: "Tyler" <tylerf(REMOVETHISPART)@bocafed.org>
- Date: Fri, 9 Sep 2005 11:24:13 -0700
--
Tyler
"Philippe" wrote:
>
> "Tyler" <tylerf(REMOVETHISPART)@bocafed.org> wrote in message
> news:A38F5285-9162-4C98-AADD-6F59800BFFCF@xxxxxxxxxxxxxxxx
> |I created a DTS package & CAN run it (successfully) from Enterprise Manager
> | and from a command prompt.
> |
> | When I try to schedule a job for this DTS package under SQL Server Agent
> | Jobs it gets the following error:
> |
> | ATTRIBUTE_TYPES to [ThankYouAcknowledgements].[dbo].[ATTRIBUTE_TYPES] Step
> | DTSRun OnError: Copy Data from ATTRIBUTE_TYPES to
> | [ThankYouAcknowledgements].[dbo].[ATTRIBUTE_TYPES] Step, Error =
> | -2147467259 (80004005) Error string: [Sybase][ODBC Driver]Unable to
> | connect to database server: specified database not found Error
> source:
> | Microsoft OLE DB Provider for ODBC Drivers Help file: Help
> | context: 0 Error Detail Records: Error: -2147467259
> (80004005);
> | Provider Error: 83 (53) Error string: [Sybase][ODBC Driver]Unable
> to
> | conn. The step failed.
> |
> | Why does this package get an error ONLY when it's a scheduled job?
> |
> | Thanks in advance.
> | --
> | Tyler
>
>
> Hi,
>
> This is a problem of security context
>
> - If the package is run from a command prompt by using DTSRun.exe or from
> DTS Designer, the credentials of the currently logged-in Windows NT account
> is used
> - If the package is run as a SQL Server Agent job, then the integrated
> security connection is made using the account you used to start SQL Agent
>
> Notes :
> if the SQL Server was started using the Local System account, the DTS
> package has no permissions outside of the computer that is running SQL
> Server.
>
> SQL Server Agent account must be a sysadmin group member.
>
> So, your schedule package fails because the account you use to start SQL
> Server Agent has NOT enought rights to make a connection to your database
> server from your ODBC DSN
>
> Hope it's help you
> ------
> Philip
>
>
>
"If the package is run as a SQL Server Agent job, then the integrated
security connection is made using the account you used to start SQL Agent"
I am trying to run my DTS packages as a scheduled job. The account for the
SQL Server Agent job is FED\SERVICE which is a domain account & a member of
the SYSADMIN group. I've also given FED\SERVICE it every authority that I
can find.
The problem remains.
.
- Prev by Date: DTS Import/Export Wizard: Missing records/rows on a successful import
- Next by Date: Re: Error running DTS package on a schedule (only!)
- Previous by thread: DTS Import/Export Wizard: Missing records/rows on a successful import
- Next by thread: Re: Error running DTS package on a schedule (only!)
- Index(es):
Relevant Pages
|
Loading
