locked
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trus RRS feed

  • Question

  •  

    Hi all

    This Job ran yester day fine,to day It got failed with this error

    any suggestion to troubleshoot problem is appreciated.

     

    DTSRun OnError:  DTSStep_DTSTransferObjectsTask_1, Error = -2147203052 (80044814)

       Error string:  [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

       Error source:  Microsoft SQL-DMO (ODBC SQLState: 28000)

       Help file:  SQLDMO80.hlp

       Help context:  1131

     

    Error Detail Records:

     

    Error:  0 (0); Provider Error:  0 (0)

       Error string:  [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

       Error source:  Microsoft SQL-DMO (ODBC SQLState: 28000)

       Help file:  SQLDMO80.hlp

       Help context:  1131

     

    DTSRun OnFinish:  DTSStep_DTSTransferObjectsTask_1

    DTSRun:  Package execution complete.

     

    Wednesday, May 14, 2008 2:30 AM

Answers

  • I resolved the problem.

    missing authontication information.

     

    Wednesday, May 14, 2008 3:07 AM

All replies

  • I resolved the problem.

    missing authontication information.

     

    Wednesday, May 14, 2008 3:07 AM
  • How were you able to resolve the problem?  I'm running into a similar problem since upgrading to Windows 7. 

     

    Any help would be most appreciated.

     

    Best,

    ~Jack

    Monday, December 12, 2011 10:26 PM