Question

Issue with linking external data source to Workflow

Workflow

Updated January 25, 2016

asked on January 25, 2016

I have an external table located inside our repository database that I have successfully linked to our forms server (same server as repository); however, when I am trying to link to that external data source through Workflow (different server), I continue to get login failed errors. Workflow is already connected to the repository server in the Connection Profiles section, and that connection is successful. I don't understand why the same exact login information would fail under external data sources. Is there any reason that Workflow would not be able to connect to an external data source located on another server? Any help you can offer is appreciated!

1 0

Answer

SELECTED ANSWER

replied on January 25, 2016

You seem to be confusing 2 very different things. The connection profile in Workflow connects it to the repository. That needs a Laserfiche user name and password. This connection does not give Workflow access to the external table.

To connect Workflow to the external table, you need a data source. This establishes a connection directly to the SQL server, so it needs either Windows authentication or a SQL username and password. If you choose Windows Authentication, then the connection is made from the perspective of the Workflow Server service. So it would depend on the user specified in the service login. The default is Local System, which does not have rights to connect to remote servers.

2 0

Replies

replied on January 25, 2016

Thank you, I believe the issue is the user specified in the service login. I will address this and see if it resolves my issue.

0 0

You are not allowed to follow up in this post.

Question

Question

Issue with linking external data source to Workflow

Answer

Replies

Sign in to reply to this post.