title: SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection
body: <p>I'm using MS SQL Server 2016.  I have a SSIS package, with one execute SQL task.  I can execute it fine with Visual Studio.  When I deploy to the SSIS Catalog, I receive the below error:</p>
  
  <blockquote>
    <p>Execute SQL Task: Error:  Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection</p>
  </blockquote>
  
  <p>Likewise, if I try to execute via a SQL Agent job I recieve the below:</p>
  
  <blockquote>
    <p>Description: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.  Source: .Net SqlClient Data Provider  Started:  15:02:11  Finished: 15:02:12  Elapsed:  0.125 seconds.  The package execution failed.  The step failed.</p>
  </blockquote>
  
  <p>What am I missing?  Any help would be greatly appreciated.</p>
  
  <p>The connection manager within SQL server is using ADO.net, not OLEDB</p>