Workflow Manager / AdminStudio Database Server

This following table lists the recommended system configuration for a Workflow Manager/AdminStudio Application Catalog database server:

Workflow Manager / AdminStudio Database Server

Item

Description

Processor

32-bit or 64-bit processor at 2 GHz or greater

RAM

4 GB or greater (8 GB preferred)

Hard Disk Space

80 GB or greater

Operating System

Windows Server 2008 R2 or later (Windows Server 2012 preferred)

Database Software

SQL Server 2008 R2 or later databases, including SQL Server 2012 and SQL Server 2014 (latest version preferred)

• Dictionary sort order—SQL Server must be installed with case-insensitive dictionary sort order 52 on Code Page 1252 for non-Unicode data. For more information, use the sp_helpsort T-SQL command, which returns the following:

Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode data

• Collation setting—SQL_Latin1_General_CP1_CI_AS is the required collation setting for AdminStudio database server. It is the only supported collation.

Note:Before attempting to connect to an existing Microsoft SQL Server, open SQL Server Configuration Manager and make sure that the following three protocols are enabled:

• Shared Memory
• Named Pipes
• TCP/IP