DSN-Less SQL Server Connection

lwolfie

I'm trying to get a database connection to work on server without having IT setup the database connection AND without the Server Account having access to the database.  From what I've read I am trying to use a DSN-Less connection.  The connection works on desktop.  I've tried many routes and many different combinations of the following steps, but basically it's:

1. Create the DSN-Less Connection.

2. Synchronize with Server.

3. Create my workflow with said connection. 

4. Save the workflow to Server.

5. Run the workflow.

Upon running the workflow, I get an error that it can't find the connection.  If my IT Server Admin, goes onto the server and creates the DSN-Less connection through File-Manage Connections and creates it as a System connection, then it works.  The problem here is that IT is involved.  

I have verified the same drivers are on the server.  I've also been on the phone with Alteryx Support and they haven't been able to come up with a solution.  

Is the only way for database connections to work, is to have IT set it up on that side?  

jrgo

I suspected that was the case. Long story short, when creating your In-DB connection, you need to create it as a file as opposed to a user or system (if running as admin) connection. When you publish your workflow, you'll want to include that .indbc file you created as an asset.

Reason, In-DB connections, while compatible with DCM, store the connection details in a separate config file. The ID that's references the DCM connection is stored in that file, which - if you created a user or system connection - only exists on your own machine, not the server. Creating and including the .indbc file with your workflow will provide Server/Gallery with what it needs for establishing your connection and avoid your IT from creating the connection on the server directly.

Hope this helps!