- A dedicated SQL server or Instance for each site with Configmgr 2012.
- The instance of the SQL Server at each site must use the following collation: SQL_Latin1_General_CP1_CI_AS.
- For SQL 2008 R2 SP1 Cumulative Update 6 is needed. (You can run the installer with CU4 actually..) NOT Supported though!
- Set the memory requirements.
23 February 2013
SCCM 2012 – ConfigMgr on a SQL Server Named Instance
When you install ConfigMgr 2012 on a separate box with a separate SQL 2008 R2 Server in a named instance remember that ConfigMgr cannot handle Dynamic Ports used by SQL! Furthermore note the prerequisites needed for SQL on a ConfigMgr installation: