title: Sql Server Agent Job Fails
body: <p>I job that executes the package located on server. The package has logging set up. When I disable that logging it executes fine as expected but when I run that with logging it throws an error.</p>
  
  <p>Information:</p>
  
  <ol>
  <li>Job and Package is located on same server.</li>
  <li>User have permission to execute the job.</li>
  <li>Logging connections are coming from the different server.</li>
  </ol>
  
  <p>Error:</p>
  
  <pre><code>Executed as user: VHRDEVLHQ3379\SYSTEM. ....50.2500.0 for 64-bit  
  Copyright (C) Microsoft Corporation 2010. 
  All rights reserved.    
  Started:  5:10:13 PM
  
  Error: 2013-11-25 17:10:14.61     
  Code: 0xC0202009     
  Source: Package Connection manager "HRPConfig"     
  Description: 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 'USER'.".  
  End Error  
  
  Error: 2013-11-25 17:10:14.69     
  Code: 0xC0202009     
  Source: Package Connection manager "Logging"     
  Description: 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 'USER'.".  
  End Error  
  
  Error: 2013-11-25 17:10:14.69     
  Code: 0xC020801C     
  Source: Package Log provider "SSIS log provider for SQL Server"     
  Description: SSIS 
  Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  
  The AcquireConnection method call to the connection manager "Logging" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  COM error object information is available.
  Source: "Package"  error code: 0xC0202009  
  Description: "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 'USER'.".  ".  
  End Error  
  
  Error: 2013-11-25 17:10:14.71     
  Code: 0xC0202009     
  Source: Package Connection manager "HRPConfig"     
  Description: 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 'USER'.".  
  End Error  
  
  Error: 2013-11-25 17:10:14.79     
  Code: 0xC0202009     
  Source: Package Connection manager "Logging"     
  Description: 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 'USER'.".  
  End Error  
  
  Error: 2013-11-25 17:10:14.79     
  Code: 0xC020801C     
  Source: Package Log provider "SSIS log provider for SQL Server"     
  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Logging" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  COM error object information is available.  Source: "Package"  error code: 0xC0202009  Description: "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 'USER'.".  ".  
  End Error  
  
  Error: 2013-11-25 17:10:18.21     
  Code: 0xC0202009     
  Source: Package Connection manager "Logging"     
  Description: 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 'USER'.".  
  End Error  
  
  Error: 2013-11-25 17:10:18.27     
  Code: 0xC0202009     
  Source: Package Connection manager "Logging"     
  Description: SSIS Error Code DTS_E_OLED...  The package execution fa...  The step failed.
  </code></pre>