Alteryx Server Setup - user managed SQL DB

[EN6924]

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 Team	SQL Server Access for the team - DBA Team
Alteryx Installation and Configuration Setup - Project Team	Microsoft SQL Server 2019/2022 (upgrade to 2022 and restore config, permissions etc) - Infra Team
Microsoft ODBC Drivers for SQL Server - DBA Team	SQL Server Management Studio - available on W365
SQL Server authentication credentials - DBA Team	SQL 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)?

[AshM]

Hi

Take a look at these articles.

https://help.alteryx.com/current/en/server/configure/database-management/sql-db-management/configure...

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.

[Warcry]

- 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!