DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER - IIS - Could not acquire connection - Are you getting insane with this error?

Hi!

Is Integration information server making you lose your mind because of this error?

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

There are many reasons for this.

First

You named your connection with a fancy name. Example IggyAzaleia.10-78-5_12_WTF.
Solution : Connections must have simple names. No points, no dashes. Example Connection01

Second

You are updating a DTSX package, and suddenly you receive this dammned error. The message says that it is impossible to logging.

In this case there some possibilities
        The user you your using is blocked. There were so many errors that the user you are using in the connection string was blocked.
        When you update the DTSX, the connection you have entered loses the password. Fill the connection string again and don't forget the password. It seems that everything is ok (but IIS IS LYING!)

And that is it.

Good luck!

PS: If you have any doubt, post your comment below.