This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 20%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Hello , To enable transactions in SSIS, I did the following
When I run the package, it is throwing the error message - Failed to acquire connection.Connection may not be configured correctly or you may not have right permissions on this connection.
Am I missing anything here ??
Can anyone help in fixing this error,thanks
Am I missing anything here ??
Nearly everything, like providing informations about the connection you use in SSIS package and much more details, which we can't guess.
I am running the package from the visual studio, I have not deployed the solution yet.
After setting the transaction property, it throws the error Failed to acquire connection.Connection may not be configured correctly or you may not have right permissions on this connection.
If change the value from required to supported, everything is working fine.
Only issue is with connection when I change the property to required
Hi @Rahul Polaboina ,
Are you running the package from Visual Studio or SQL agent job?
Please have a check if you could connect to the connection manager successfully.
Also ensure that you have given the necessary permissions to the SQL Agent account if you run in job.
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
I am running the package from the visual studio, I have not deployed the solution yet.
After setting the transaction property, it throws the error Failed to acquire connection.Connection may not be configured correctly or you may not have right permissions on this connection.
If change the value from required to supported, everything is working fine.
Only issue is with connection when I change the property to required
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
This error occurs when DTC is not running or configured correctly.
Please see:
https://stackoverflow.com/questions/15771134/ssis-enabling-transactions-causes-database-connection-to-fail
DTC Is running, When I change from transaction property from Required to supported, all connections string work and the package runs successfully.
Only issue is when I change the package transaction property to Required
Yes, that is because when you use transactions, it tries to connect to DTC and cannot. The error is a DTC problem.