Skip to main content

Application Catalog Database Server

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

ItemDescription
Platform32-bit or 64-bit processor at 2 GHz or greater
RAM4 GB or greater (8 GB preferred)
Hard Disk Space80 GB or greater
Operating SystemWindows Server 2016 or later (Windows Server 2016 or later preferred)
Database SoftwareSQL Server 2008 R2 or later databases, including SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, and SQL Server 2022.
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.
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