Thinking about it, Would this be of issue, as our Data Source is setup via
ODBC with the credentials in there, so whether the job was scheduled or not,
I would have thought that the user running the actual job would only make a
difference on the database the data is being imported to, not where it's
coming from, as that's taken care of by ODBC?

-----Original Message-----
From: Wooton, Geoffrey (NESL-IT) [mailto:Geoffrey.Wooton@npower.com]
Sent: 25 April 2006 11:07
To: 'Steve'; info-ingres@cariboulake.com
Subject: RE: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails

Check the SQL Server Agent account has permission to access your database.
Running from enterprise manager could run using a different user context to
scheduling via SQL Agent depending on the accounts configured to run the SQL
Server Service and that of the SQL Agent..

Geoff

-----Original Message-----
From: Steve [mailto:SMaxwell@NationalExpress.com]
Sent: Tuesday, April 25, 2006 10:45 AM
To: info-ingres@cariboulake.com
Subject: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails

Hi All,

I have a DTS job to pull data out of an ingres database. When I run
this job manually through enterprise manager, it runs perfectly, when I
schedule it, it fails.

I've found a Microsoft KB on a similar problem that didnt help.

Has anyone had this before? What did you do to resolve this?

Cheers,

Steve

Technical Bumf:

Intel Ingres II running on Windows 2003 Server, SQL Server 2000, SP3.

_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres

**********************************************************************

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.
   
If you have any queries, please contact the IT Service Desk on 1870
(01384-275454).
   
postmaster@npower.com

**********************************************************************

**********************************************************************

This e-mail is provided for general information purposes only and does not
constitute investment or transactional advice. For  the avoidance of doubt
the contents of this email are subject to contract and will not constitute a
legally binding contract.

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.
   
If you have received this e-mail in error, please notify
postmaster@npower.com (UK 01384 275454) and delete it immediately from your
system.
   
Neither Npower nor any of the other companies in the RWE Npower group from
whom this e-mail originates accept any responsibility for losses or damage
as a result of any viruses and it is your responsibility to check
attachments (if any) for viruses.
Npower Limited Registered office: Windmill Hill Business Park, Whitehill
Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277.  This
e-mail may be sent on behalf of a member of the RWE Npower group of
companies.

**********************************************************************