Note: example, use the latest supported SP and CU!
Install SQL Server Service Pack and latest Cumulative Update Set SQL Server Agent service startup type to Automatic. Note: there may be some variation for groups based on client requirements.
ĭefault security – Windows Authentication, add \Administrators & \Domain Admins for Sysadmin permissions.
Instance Configuration – take the Default Instance option.Ĭhange the Instance Root directory location (assuming you’ve followed the drive suggestions) to:Ĭollation – default should be correct, however, verify that ‘SQL_Latin1_General_CP1_CI_AS’ is selected. Only key dialogs will be shown for this installation.įeature selection – choose the above options. Browse to SQL Server 2012 Sp1 install media, right click setup.exe, run as administrator. Note: example is from SQL Server 2012, however, SQL Server 2014 is very similar. NET 3.5 framework (required for SQL install) Install SQL Server 2012 or SQL Server 2014 Server 2012 platform – Install File Services &. SQL Server Installationĭrives dedicated for SQL Server data files or log files, such as TempDB should be formatted to NTFS 64KB block size. Using the estimator to calculate the number and size of the data files, begin the SQL Server Installation process. Shown is an example of the Database sizing worksheet, based on estimated client counts:Īnthony has documented this approach as follows: One challenge, determining the correct size for the databases. Prior to installing ConfigMgr 2012, It is recommended to pre-create the ConfigMgr 2012 database and pre-size the TempDB databases. Ø 8GB memory (minimum) Distribution Point Drive configuration guidelines: Logical DriveĬonfigMgr 2012 R2 Database Sizing Estimator ConfigMgr Distribution Point Specifications The following server Physical or Virtual platform specifications are indicated. It is recommended that a separate server be installed to provide the Distribution Point and Management Point roles. *Note: Optional configuration for higher performance and/or higher client counts SCCM Content OS images, app packages, etc. Ø 32GB memory (minimum) Site Server Drive configuration guidelines: Logical Drive If you need some background on why installing ConfigMgr 2012 on a remote SQL Server is a really bad idea, please read the following.įor a smaller ConfigMgr 2012 site, with perhaps less than 5,000 clients, the following server Physical or Virtual platform specifications will perform well.
You will want to install SQL Server on the same server that you plan on installing ConfigMgr 2012. Post ConfigMgr 2012 R2 Installation Tasks. Pre-create the ConfigMgr 2012 R2 database. Install SQL Server 2012 Sp2 CU4 (latest cumulative update). Install SQL Server Service Pack and latest Cumulative Update. Installing and configuring SQL Server for Configuration Manager.ĬonfigMgr 2012 R2 Database Sizing Estimator. Too many make the mistake of miss-configuring SQL Server, then need to spend a LOT of time later, correcting it. This guide is intended to assist administration in properly configuring SQL Server prior to installing Configuration Manager.