Help needed to create a data connection

EN6924 — Thu, 06 Jun 2024 11:35:22 GMT

Hi Experts,

We received below request from a user to create Gallery Data Connection -

ODBC connection r/w

Name: COD_RPA_DB
Server: EUGSX-WSQL1200

The connection will be used by the user and his team only, which is a windows user group. They're using a service account which has access to the Database.

While creating the User DSN, user selected - 'Integrated windows authentication' as his local connection.

-------------------------------

We tried to create the System DSN from Server and received errors (Screenshots attached)

Even we tried by configuring DSN less and failed.

odbc:DRIVER={ODBC Driver 17 for SQL Server};Server=EUGSX-WSQL1200;UserID=svc_alteryx_tst;Password=hKupLN9Lux13aFKVZ8dVDV#q;

odbc:DRIVER={ODBC Driver 17 for SQL Server};UID=SVC_ALTERYX_TST;PWD={hKupLN9Lux13aFKVZ8dVDV#q};SERVER=EUGSX-WSQL1200;Integrated Security=SSPI;

-----------------

I don't know how to properly configure System DSN or DSN less connections. Need to create the Gallery Data connection as soon as possible. Someone please help me here.

Re: Help needed to create a data connection

fmvizcaino — Thu, 06 Jun 2024 14:10:39 GMT

Hi @EN6924 ,

Here you can find everything related to DNS-less strings.

https://knowledge.alteryx.com/index/s/article/How-To-format-common-ODBC-DSN-less-connection-strings-1583461565318

http://connectionstrings.com/

Best,

Fernando Vizcaino

topic Re: Help needed to create a data connection in Alteryx Server Discussions

Help needed to create a data connection

Re: Help needed to create a data connection