Cannot update passwords in the Input Data or the Output Data tool

[gtorres8]

Environment Details

After a password update on the database side and after updating the DSN with the new password, those changes do not seem to apply to workflows connected to the same DSN connection. Neither the Input Data or Output Data configuration will take the new password.
 

• Alteryx Designer
  • All Versions
• Input Data Tool
• Output Data Tool
• Policy to update database password

Cause

The password was updated on the Database side.

Resolution

Manually update the password within the connection string in the Input Data tool properties:

1. Click the Input Data tool within the workflow.
2. Locate the connection string on the left.
3. If the username has not changed, the only thing to replace is the "__EncPWD__" section and replace it with the new password.

Note: At this moment only, the new password will show as plain text, but as soon as the workflow runs, the connection string will be encrypted again with "__EncPWD__".

[ashokkumar1]

Hi @gtorres8 

I have tried as per your suggestion i updated the password but still workflow showing the below error

I have attached the snapshot please check let me know

Thank you