topic Re: SQL Server connection string with embedded credentials in Alteryx Server Discussions

SQL Server connection string with embedded credentials

mcha54 — Tue, 02 Jul 2019 23:20:24 GMT

Hi there! We're trying to setup a dsn-less connection to SQL server for use with the Alteryx Server.

odbc:Driver={SQL Server Native Client 11.0};Server=server,port;DATABASE=dbname;Uid=username;Pwd=password;Trusted_Connection=yes;

The use case is that people without normal access to the SQL table can still run the workflow. We setup a SQL Server authenticated user and embedded into the connection string.

When people run the workflow though, their own credentials seem to override the embedded connection. Since they don't have access, the workflow fails.

Anyone have suggestions or see what we're doing wrong?

Thanks!

Re: SQL Server connection string with embedded credentials

patrick_digan — Wed, 03 Jul 2019 18:16:06 GMT

@mcha54 Your setup seems like it should accomplish what you're after. Can you provide some more details:

1) Is the person running the workflow on designer or the gallery?

2) Can you paste the error you're receiving? either the error text or a picture would do.

Re: SQL Server connection string with embedded credentials

mcha54 — Mon, 29 Jul 2019 22:47:05 GMT

The person is running the workflow on Gallery.

In the "login failed for user xxx" -- it actually shows the user's credentials.

It looks as though the workflow is replacing the user's own credentials instead of using the embedded credentials in the connection string.

Re: SQL Server connection string with embedded credentials

DaveCarver — Wed, 18 Nov 2020 02:24:49 GMT

i know this is old but the answer is that you need to specify Trusted_Connection=no