SQL Server Options

SQL Server options apply to all servers that utilize Workflow.

Note:
  • The Workflow project is installed into this SQL Server database. SQL Server can be installed on a different computer that is also on the domain or workgroup; however, you must ensure that network configurations allow appropriate machine communication.
  • For security reasons, we recommend that SQL Server be configured with Windows authentication, but Mixed Mode authentication is also supported.

The following SQL Server systems are supported:

  • Microsoft® SQL Server 2022
    Note: If you are upgrading your database to SQL Server 2022, you must first upgrade Workflow to v2.6 SP2 or greater, and then upgrade SQL Server.
    Note: When installing Workflow Reporting on SQL 2022, you must manually install SQL Server 2012 Native Client. You can download the latest SQL Server 2012 Native Client version from the following URL: https://www.microsoft.com/en-us/download/details.aspx?id=50402.
  • Microsoft® SQL Server 2019
    Note: If you are upgrading your database to SQL Server 2019, you must first upgrade Workflow to v2.6 SP1 or greater, and then upgrade SQL Server.
  • Microsoft® SQL Server 2017
  • Microsoft® SQL Server 2016
  • Microsoft® SQL Server 2014 (32- or 64-bit)
  • Microsoft® SQL Server 2012 Enterprise (32- or 64-bit)
  • Microsoft® SQL Server 2012 Business Intelligence (32- or 64-bit)
  • Microsoft® SQL Server 2012 Standard (32- or 64-bit)
  • Microsoft® Windows® Server 2012 Essentials
    Note: In order for Workflow to connect to any edition of Microsoft® SQL Server 2012 or later, you must configure SQL Server to enable the sysadmin role for the applicable login account. For more information, see Enable Connection between Workflow and SQL Server 2012.
  • Microsoft® SQL Server 2008 R2 with the latest service pack
  • Microsoft® SQL Server 2008 Standard or Enterprise Edition (32- or 64-bit)
  • Microsoft® SQL Server 2008 Express
    Note: If you are using SQL Server Express with the Workflow application server, you cannot use the Reporting Database.

The Workflow installation automatically selects the default SQL Server instance. If SQL Server 2012 and SQL Server 2008 are both installed, SQL Server 2008 may be the default instance. In this scenario, if you want to use SQL Server 2012 instead, you must select this instance as the default as part of manually configuring your SQL Server settings.

For more information, see the topic corresponding to the type of installation you will be performing.