Azure sql server connections not running in gallery

We are migrating from on prem sql server to azure cloud sql server.

Running a flow with the input from our Azure sql server locally works just fine. But when i push to the gallery it runs in perpertuity

There is SSO enabled with our azure sql server. And ive noticed everytime i click on another in the flow and go back to the input too, the SSO screen flashes again.

So my theory is the SSO is the issue why my flows are running forever in the gallery.

My question is is there a fix? Thank you !!

Publish

Workflow

Gallery

Server

Updates

Accepted answers

All comments

gabrielvilella

Which tool are you using exactly to get data? According to the documentation, for Microsoft Azure SQL Database only Windows Authentication or SQL Server Authentication is supported, depending on how the SQL Server is configured.

https://help.alteryx.com/20231/designer/microsoft-azure-sql-database

peanut89

Just the input tool

gabrielvilella

Have you tried running the workflow with your credentials? You can set it when saving it to the Server.

peanut89

Yes i have, but i think the sso is the blocker. the flow has been running for 4hrs now.

gabrielvilella

The best practice for database connections on the Server is to set it up either using the Data Connections (Server admin creates and shares it with your user) or via DCM (you create and manage your own). Have you tried these options?

peanut89

How do I as server admin set this up?

gabrielvilella

Data Connections:

https://help.alteryx.com/20221/server/data-connections

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Gallery-Data-Connections-FAQ/ta-p/452293

DCM:

https://help.alteryx.com/20221/server/dcm-server

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-to-Set-up-DCM-for-Designer-and-Server/ta-p/1032535

peanut89

Thank you i will try this

SeanAdams

Hey @peanut89 - you may know this already, but when running in the server environment the security context is different, and web based SSO will not work.

Taking this step by step:

- When you're on a desktop machine - the security context is "logged in as me" and SSO can flash up on the screen or pass your credentials over to the DB server

- However - when running on the server - the security context is "logged in as Alteryx Server" - and there is no interactive UI user (it's running as a service, not a user session) so there's no way for Alteryx Server to deal with a login window.

So - you need to use a login method that can pass security credentials directly - and either pass in explicit username & password - or use a way that can pass through a kerberos identity, and permission the Alteryx Server to your SQL server. By far the easiest way is to use a username & pwd which is built into the connection string.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317