Primary Controller Configuration
The first step is to configure your primary controller if it has not already been configured.
Run the Alteryx System Settings console as an administrator.
For the Environment > Setup Type, select Custom > Enable Controller.
From the Controller > General section, copy the Token for later use. If this is a new server configuration, you need to complete the setup to generate a Token.
In the Controller > Persistence section, set the Database Type to User-managed MongoDB or User-managed SQL DB.
If you have selected User-managed MongoDB: In the Controller > Persistence > Database section enter the Host, Database name, Username and Admin Password.
If you have selected User-managed SQL DB: In the Controller > Persistence > Database section enter the SQL Connection string. Go to SQL DB Advanced Connection Strings for tips and examples on specifying connection strings.
Complete the remaining Controller configuration steps and select Finish to apply the settings and start the AlteryxService with the latest configuration.