SQL database server requirements

Item	Requirement	Notes
Hard Drive	750 GB
Processor type	Quad Core, Quad Proc
RAM	16 GB
Operating System type	64-bit
Operating System	Windows 2008 R2 +SP1 - 64 bit(Standard or Enterprise) Windows 2012 - 64 bit(Datacenter or Standard) Windows 2012 R2 - 64 bit(Datacenter or Standard) Windows 2016 - 64 bit ( Standard)
SQL Server	Enterprise or Standard SQL 2008 R2 SP3 - 64 bit SQL 2012 SP1/SP2/SP3/SP4 - 64-bit SQL 2014 SP1/SP2/SP3 - 64-bit SQL 2016 SP1/SP2 - 64-bit Note: For Clustered support, you must use the SQL 2016 SP1 Enterprise Edition 64 bit. SQL Server 2017 CU20 - 64 bit SQL Server 2019 CU4 -64 bit Note: A separate reporting services installer is available for SQL 2017 and 2019.	The following features need to be installed: Instance Features Database Engine Services Reporting Services - Required for Reporting Server Shared Features SQL Server Data Tools [2014] (`http://www.microsoft.com/en-us/down-load/details.aspx?id=42313`) SQL Server Data Tools [2012] Business Intelligence Development Studio [2008 R2] Client Tools Connectivity Client Tools Backward Compatibility Client Tools SDK Documentation Components Management Tools - Basic Management Tools - Complete SQL Client Connectivity SDK Collation Collation set to the default value at install: Dictionary order, case-insensitive, for use with 1252 character Set, which equals the SQL_Latin1_General_CP1_CI_AS Mode Native Mode / Compatibility Level (level120)[2014] Native Mode / Compatibility Level (level 110) [2012] Native Mode / Compatibility Level (level 100) [2008 R2] Size The recommended initial size for Certification Manager database is - Certification Manager database data file (mdf): 20GB Certification Manager database log file (ldf) : 2GB. ldf, 10% auto growth and recovery model as simple Note: The Certification Manager database size is set by default during Certification Manager installation tempdb Minimum requirement for SQL tempdb: 8 GB Minimum Requirement for ldf: 2GB. ldf, 25% auto growth for data file and 20% for log files with recovery model as simple.

Hard Drive

750 GB

Processor type

Quad Core, Quad Proc

RAM

16 GB

Operating System type

64-bit

Operating System

Windows 2008 R2 +SP1 - 64 bit(Standard or Enterprise)

Windows 2012 - 64 bit(Datacenter or Standard)

Windows 2012 R2 - 64 bit(Datacenter or Standard)

Windows 2016 - 64 bit

( Standard)

SQL Server

Enterprise or Standard

SQL 2008 R2 SP3 - 64 bit
SQL 2012 SP1/SP2/SP3/SP4 - 64-bit
SQL 2014 SP1/SP2/SP3 - 64-bit
SQL 2016 SP1/SP2 - 64-bit
Note: For Clustered support, you must use the SQL 2016 SP1 Enterprise Edition 64 bit.
SQL Server 2017 CU20 - 64 bit
SQL Server 2019 CU4 -64 bit

Note: A separate reporting services installer is available for SQL 2017 and 2019.

The following features need to be installed:

Instance Features

Database Engine Services
Reporting Services - Required for Reporting Server

Shared Features

SQL Server Data Tools [2014] (http://www.microsoft.com/en-us/down-load/details.aspx?id=42313)
SQL Server Data Tools [2012]
Business Intelligence Development Studio [2008 R2]
Client Tools Connectivity
Client Tools Backward Compatibility
Client Tools SDK
Documentation Components
Management Tools - Basic
- Management Tools - Complete
SQL Client Connectivity SDK

Collation

Collation set to the default value at install: Dictionary order, case-insensitive, for use with 1252 character Set, which equals the SQL_Latin1_General_CP1_CI_AS

Mode

Native Mode / Compatibility Level (level120)[2014]
Native Mode / Compatibility Level (level 110) [2012]
Native Mode / Compatibility Level (level 100) [2008 R2]

Size

The recommended initial size for Certification Manager database is -
- Certification Manager database data file (mdf): 20GB
- Certification Manager database log file (ldf) : 2GB. ldf, 10% auto growth and recovery model as simple

Note: The Certification Manager database size is set by default during Certification Manager installation

tempdb

Minimum requirement for SQL tempdb: 8 GB
Minimum Requirement for ldf: 2GB. ldf, 25% auto growth for data file and 20% for log files with recovery model as simple.