title: Failed to acquire connection <Connection Name> If Transaction is enabled
body: <p>In SSIS Package I have a sequence container and I have enabled <strong>TransactionOption - Required</strong>. Within the container I have a execute SQL task that make use of a ADO.Net Connection to SQL Server.</p>
  
  <p>The package throws <strong>[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</strong>.</p>
  
  <p>I face this error only if I set TransactionOption as Required. Another information if I point my ADO.Net connection to my local SQL server it runs perfectly but If I point to the Server then I face this issue.</p>
  
  <p>The Isolation level is Serializable. The Distributed Transaction Coordinator service is running on the local machine as well as server machine.</p>
  
  <p>Please let me know if you require additional details. Thanks in advance</p>
  
  <p>Any idea? Please...</p>