Application Catalog Database Server

The following table lists the recommended system configuration for a database server to store AdminStudio Application Catalog databases.

Note:While minimum requirements are listed below, the recommended system configuration for a database server is dependent upon the number of users and the number of packages that will be imported into the Application Catalog database.

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 or later preferred)

Database Software

SQL Server 2008 R2 or later databases, including SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019.

• 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