SQL Server Agent OLE DB provider 'MSDASQL' reported an error
Posted on 2006-06-22
I have a DTS package that retrieves data from a Linked server via an Ingres Connection.
Ingres is running fine, and the packages tests for the service before running, the DTS package will execute fine manually, and I can run the package from a command line, but SQL agent won't execute the package, i simply get the following error.
Error = -2147217900 (80040E14) Error string: OLE DB provider 'MSDASQL' reported an error. Authentication failed. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 7399 (1CE7) Error string: OLE DB provider 'MSDASQL' reported an error. Authentication failed.
This is driving me mad know ! the server agent uses the same administrator account as the SQL server, and the owner of the Job is the administrator as well.
I am at a loss as to why it won't execute, can anyone shed any light on this !!
System is running SQL server 2000 sp4, on a Windows 2000 server