SSIS Login failed for user error

• GonnaCatchIT

  SSCrazy

  Points: 2797

  More actions

  August 29, 2015 at 3:35 am

  #307230

  Hi Team,

  I have below configuration:

  SSIS Server : SQL Server 2008 r2. Packages stored in msdb.

  Windows server 2008 r2 64 bit

  I execute the SSIS package via windows application which is on another server. It connects to SSIS server and executes the package.

  When running the package using dtexec directly on SSIS server it runs fine, but when executing via windows app I get below error.

  SSIS is set to DontSaveSensitive , using dtsconfig file.

  Error message:

  MessageDetails: SSIS package 'TestPackage' execution failed due to some system exception:SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

  Error code: 0x80040E4D.

  An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user ''.".

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  August 29, 2015 at 3:28 pm

  #1823227

  Hi

  Is the another server (where your windows app reside) under same domain as the SQL?

  Best regards

  Mike