Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

Alteryx Alumni (Retired)

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


The password was updated on the Database side.


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.
idea Skyscrapers


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__".

8 - Asteroid

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