What database does SCCM use?
Microsoft SQL Server (MSSQL)
Note: SCCM utilizes a normalized Microsoft SQL Server (MSSQL) database (data is spread across many tables).
Which edition of Database Server is supported by SCCM?
Supported SQL Server versions for SCCM Current Branch
| SQL Server Versions | CAS | SECONDARY |
|---|---|---|
| SQL Server 2012 SP3 (Standard, Enterprise) | YES | YES |
| SQL Server 2012 SP2 (Standard, Enterprise) | YES | YES |
| SQL Server 2012 Express SP3 | NO | YES |
| SQL Server 2012 Express SP2 | NO | YES |
Does SCCM require SQL?
Does SCCM require SQL Server? Yes, Configuration Manager requires a 64-bit version of SQL Server to host the site database.
What is the minimum hard disk capacity requirements for installing the SCCM?
Hardware
| Servers | Processor (min) | Hard drive space (min) |
|---|---|---|
| Service Manager Console | 2-Core 2 GHz CPU | 10 GB |
| Service Manager Self-Service Portal (standalone) | 4-Core 2.66 GHz CPU | 80 GB |
| Service Manager Self-Service Portal + Secondary Management Server (Recommended) | 8-Core 2.66 GHz CPU | 80 GB |
Does SCCM include SQL license?
The SQL Server license is covered here in System Center licensing guide, it covers Configuration Manager CB as well. “No additional licenses are needed for the management server or SQL Server runtime (SQL Server Standard Edition). “
What is SCCM data?
Microsoft System Center Configuration Manager (SCCM) is a Windows product that enables the management, deployment and security of devices and applications across an enterprise. Amongst other potential uses, administrators will commonly use SCCM for endpoint protection, patch management and software distribution.
What versions of SQL are supported?
Lifecycle dates
| Version | Release year | Extended Support end year |
|---|---|---|
| SQL Server 2014 | 2014 | 2024 |
| SQL Server 2012 | 2012 | 2022 |
| SQL Server 2008 R2 | 2010 | 2019 |
| SQL Server 2008 | 2008 | 2019 |
What are the prerequisites of SCCM?
SCCM 2016 prerequisites
- SQL server (it’s free for System center usage) with collation SQL_Latin_General_CP1_CI_AS.
- Windows Roles. BITS. .Net. WSUS, After you finished to install SQL. IIS. Common HTTP Features. Static Content. Default Document. Directory Browsing. HTTP Errors. HTTP Redirection. Health and Diagnostics. HTTP logging.
Does SCCM require Active Directory?
Answers. The Active Directory service is a requirement. However you do not need to have domain admin rights to install and configure the different features in CM2007.
What are prerequisites for SCCM?
The required SCCM prerequisites are as follows: Extending the Active Directory schema. Configuring the System Management container in Active Directory. Adding Windows roles and features on Site Servers….
- Windows Server 2008 64-bit SP2 or Windows Server 2008 R2 operating system.
- Windows Active Directory domain.
- .
- .
What are the prerequisites for SCCM installation?
SCCM 2016 prerequisites
- BITS.
- .Net.
- WSUS, After you finished to install SQL.
- IIS.
- Common HTTP Features. Static Content. Default Document. Directory Browsing.
- Health and Diagnostics. HTTP logging. Logging tools.
- Performance. Static Content Compression. Dynamic Content Compression.
- Security. Basic Authentication. Windows Authentication.