title: Connection may not be configured correctly or you may not have the right permissions on this connection
body: <p>I have a package in SSIS and it only contains an Execute SQL Task with a connection to Netezza. So the provider to connect to Netezza that I use is NZOLEDB. When I run it locally on my machine, it runs smoothly and without error. However, when I deploy it in SQL Server and execute it with a Server Agent, I get 2 errors:</p>
  
  <p>1) <strong>Failed to acquire connection "Connection name". Connection may not be configured correctly or you may not have the right permissions on this connection</strong></p>
  
  <p>2)  <strong>SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Netezza OLE DB Provider" Hresult: 0x80004005 Description: "Client unable to establish connection".</strong></p>
  
  <p>In the job step, I went to Configuration > Connection Managers and manually added in the value for the password to connect to Netezza. That still didn't help.</p>
  
  <p>Any help would be great, thanks!</p>