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.
