Give option to disable encryption of the Connection
Give a checkbox option to disable encryption of connection string and database password. Or some ways to dynamically change like password from system variables. Because the portable version connections doesn't work by copying x-copying everything to other system in automation.
Thanks Joe, using 'password=xxx' worked in connection string. But you may add this checkbox as well to explicitly give this as an option for users. It worked for me, so the suggestion can be deleted as well.
You can do this by clicking Advanced and under 'Extra connection string parameters', type 'password=...'