NT Authentication Issue

From: Jill (anonymous_at_discussions.microsoft.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 15:31:17 -0700

I suspect that I am running into an NT authentication
issue here and I have no clue what to do about it.

I have a DTS package that selects data from a SQL Server
database and imports it into Oracle. I can run the
package just fine. My backup developer can run the
package from her machine just fine. However, the user can
not run it. She gets the following error message:

Error: -2147217843 <80040E4D>; Provider Error: 18456
<4818>

Error string: Login failed for user 'MYDOMAIN\USERNAME'
Error source: Microsoft OLE DB Provider for SQL Server

If I log in as myself on the user's machine, I can run the
DTS package (I have it being executed from a batch file).
The DTS package use NT Authentication to connect to SQL
Server.

I have no idea where to start looking for NT permission
issues.

Help!!

Relevant Pages

  • Scheduled DTS Package
    ... I have a DTS package that is schedule to run daily. ... created and made the connection to the SQLServer using Windows ... changes, even though the scheduled DTS is using Windows authentication, the ...
    (microsoft.public.sqlserver.dts)
  • Re: NT Authentication Issue
    ... She is running the DTS package from a SQL ... Server application called Maximo. ... >>The DTS package use NT Authentication to connect to SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Re: export access to sql server
    ... i followed article from sql server books MSDN. ... Running a DTS Package Saved as a Visual Basic File ... Actually my software will support access ... If the app needs to dynamically recreate the ...
    (microsoft.public.vb.general.discussion)
  • Executing a DTS package from a Web application.
    ... Can a SQL Server 2000 DTS Package be run from a Web application? ... The SQL Server database is not local. ... Package Execution Lineage: ...
    (microsoft.public.sqlserver.dts)