Configure Windows Authentication for Workflow
You can configure Workflow to use Windows authentication to connect to a remote SQL Server instance.
About this task
To configure Workflow to use Windows authentication, you must use the Windows Credential Manager to create a credential specifying the Windows username and password that the Workflow server should use to connect to the database.
The credential on the Workflow server machine must identify the remote SQL Server by IP or fully-qualified domain name (FQDN) and may need to explicitly specify the port depending on the SQL Server configuration.
During the installation of the Workflow server, you will have the opportunity to specify the hostname and port exactly as it was specified in the credential. Use a comma to separate the hostname and port number per the SQL Server connection string syntax.
Procedure
- Click .
-
Select Windows
Credentials, and then click
Add a Windows
credential.
The Credentials dialog box appears.
-
Enter values into the fields, as follows:
- Enter the hostname in the Internet or network address field. (e.g., sql2016server:49785)
- Enter the username that Workflow should use to connect to the database into the User Name field.
- Enter the password associated with the username you entered into the Password field.
- Click OK.
-
In the Database
Configuration section during the
installation of the Workflow server, do the
following:
- Enter the hostname and port number in the Server field, just as you did for the credential. (e.g., sql2016server,49785)
- Enter the database name in the Database field.
- Select Windows Authentication from the Authentication drop-down list.
- Click Save.