The workflow always uses the workflow server service account to connect to the database when creating a data source even though I specify windows authentication in the Configure Data Source Wizard. We do not want the workflow to use that account, instead use another test account. This is also different then how other Laserfiche products work so it was a little confusing. This is a feature request to have the ability to use the account that we specify in the wizard.
Question
Question
Ability to modify the account workflow uses to connect to the database
Replies
Is this a SQL Server data source? What other Laserfiche products are you referring to?
Yes, it is a SQL data source. Below are the Laserfiche products that I am referring to
1. Attaching a repository. I can login with the service account and the use “Windows Authentication” to connect to the database.
2. Forms allows me to enter a different account when attaching to a data source.
Thanks,
Priya
Workflow uses Windows ODBC in order to provide support for more data sources. Forms uses a custom implementation, which, although more permissive when it comes to authentication, it is limited to only supporting SQL Server data sources. Windows ODBC only allows Windows authentication as the user the application is running as (in this case, the Workflow server). You can, however, use a SQL account if a different user is needed.