Alteryx Server Setup - user managed SQL DB

Question

Hi Team,

We have a new Server where we need to completely setup Alteryx server v2024.1 from scratch and with user managed SQL DB (No MongoDB)

I have a list of steps which need to be followed -

Alteryx Server Access for the team - Infra TeamSQL Server Access for the team - DBA TeamAlteryx Installation and Configuration Setup - Project TeamMicrosoft SQL Server 2019/2022 (upgrade to 2022 and restore config, permissions etc) - Infra Team Microsoft ODBC Drivers for SQL Server - DBA TeamSQL Server Management Studio - available on W365SQL Server authentication credentials - DBA TeamSQL Service Account for Alteryx Server (read/write access) - DBA Team

Columns 1 already completed.

From Alteryx Admin perspective what are steps should I have to perform (Can anyone guide me step by step)?

Warcry · Answer

- Pick the right size VDI

- You'll need firewall rules open to the server and any additional workers.

- More than likely you setup the SQL connection via DNS vs ODBC in the gallery.

- You don't need SSMS on the server.

- The team does not need user account to SQL, they will use the connection created in gallery.

Some of the things on your list should be out of scope and their responsibility or their managers. Hope that helps some!

AshM · Answer

Hi

Take a look at these articles.

https://help.alteryx.com/current/en/server/configure/database-management/sql-db-management/configure-sql-server.html#set-up-instructions-6862335

and you will need to form the controller and gallery connection strings using the sql server host name, username and password from the examples here:
SQL DB Advanced Connection Strings

You can then enter these into system settings.