Skip to main content

Set New SQL DB Credentials

Follow these steps to reset your SQL DB credentials on Server using the user-managed version of SQL DB.

Set New User-Managed SQL DB Credentials

  1. Stop AlteryxService.

  2. Execute the following command* to update the credentials for your DB connection:

    setsqlconnectioncontroller={value}

    注意

    You will have to re-enter the entire connection string, including the username and password. For more information about the connection string, go to SQL Advanced Connection Strings.

  3. Start AlteryxService.

*Another option how to reset your SQL DB credentials on Server is going back to your Alteryx System Settings and update the values there. For more information go to Server UI and Controller.Controller(控制器)