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

  1. Click Start > Control Panel > All Control Panel Items > Credential Manager.
  2. Select Windows Credentials, and then click Add a Windows credential.
    The Credentials dialog box appears.
  3. 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.
  4. 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.

Results

Workflow is now configured to use Windows authentication to connect to a SQL Server.