Ronni Pedersen

Installing SQL Server 2008 R2 for SCCM 2012

The current supported configuration of SQL Server for System Center 2012 Configuration Manager (SCCM), is Microsoft SQL Server 2008 R2 with Service Pack 1 and Cumulative Update 4. I always use unattended installation of SQL (and anything else if possible). Here are the command lines I uses to setup SQL for ConfigMgr 2012:

SQL Server 2008 R2 RTM Setup: 

setup.exe /q /ACTION=Install /ERRORREPORTING="False" /FEATURES=SQLENGINE,RS,AS,IS,SSMS,TOOLS,BIDS,ADV_SSMS,CONN /INSTANCENAME=MSSQLSERVER /INSTANCEDIR=D:MSSQL /SQLSVCACCOUNT="NT AUTHORITYSystem" /SQLSYSADMINACCOUNTS="BUILTINADMINISTRATORS" /SQLSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITYSYSTEM" /AGTSVCSTARTUPTYPE=Automatic /RSSVCACCOUNT="NT AUTHORITYSystem" /RSSVCSTARTUPTYPE=Automatic /ASSVCACCOUNT="NT AUTHORITYSystem" /ASSVCSTARTUPTYPE=Disabled /ASSYSADMINACCOUNTS="BUILTINADMINISTRATORS" /ISSVCACCOUNT="NT AUTHORITYSystem" /ISSVCSTARTUPTYPE=Disabled /ASCOLLATION="Latin1_General_CI_AS" /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" /TCPENABLED="1" /NPENABLED="1" /IAcceptSQLServerLicenseTerms

 

 

SQL Server 2008 R2 SP1 Setup:

 

SQLServer2008R2SP1-KB2528583-x64-ENU.exe /Action=Patch /IAcceptSQLServerLicenseTerms /AllInstances /Quiet

 

SQL Server 2008 R2 SP1 CU4 Setup:

 

SQLServer2008R2-KB2633146-x64.exe /Action=Patch /IAcceptSQLServerLicenseTerms /AllInstances /Quiet

 

SP1 and CU4 downloads links:

SQL Server 2008 R8 Service Pack 1:

http://www.microsoft.com/download/en/details.aspx?id=26727

Cumulative Update 4 for SQL Server 2008 R2 SP1:

http://support.microsoft.com/kb/2633146

,

Get new posts by email

Practical articles on Intune, Windows and endpoint security, plus Workplace Ninja meetups. No spam, unsubscribe anytime.

2 responses to “Installing SQL Server 2008 R2 for SCCM 2012”

  1. Eswar Koneti's Blog » Blog Archive » Installation of ConfigMgr(SCCM) 2012 RC2

    […] lines to install SQL server 2008 including SQL server 2008 R2 SP1 and cumulative update 4 from https://www.ronnipedersen.com/2012/01/installing-sql-server-2008-r2-for-configmgr-2012/ (The current supported configuration of SQL Server for System Center 2012 Configuration Manager, is […]

  2. Paul McLatchie

    Hi Ronnie, this was extremely usefull and saved me a ton of time , my thanks.

    I installed on a 2008 R2 host: Some edits I had to make in order for it to fully process are shown below, this was mainly missing back slashes around NT AUTHORITYSYSTEM and BUILTINADMINISTRATORS. Full edit below, which ran like a charm. Would not have got that far if it wasnt for this post however, cheers!

    setup.exe /q /ACTION=Install /ERRORREPORTING=”False” /FEATURES=SQLENGINE,RS,AS,IS,SSMS,TOOLS,BIDS,ADV_SSMS,CONN /INSTANCENAME=MSSQLSERVER /INSTANCEDIR=C:MSSQL /SQLSVCACCOUNT=”NT AUTHORITYSystem” /SQLSYSADMINACCOUNTS=”BUILTINADMINISTRATORS” /SQLSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT=”NT AUTHORITYSYSTEM” /AGTSVCSTARTUPTYPE=Automatic /RSSVCACCOUNT=”NT AUTHORITYSystem” /RSSVCSTARTUPTYPE=Automatic /ASSVCACCOUNT=”NT AUTHORITYSystem” /ASSVCSTARTUPTYPE=Disabled /ASSYSADMINACCOUNTS=”BUILTINADMINISTRATORS” /ISSVCACCOUNT=”NT AUTHORITYSystem” /ISSVCSTARTUPTYPE=Disabled /ASCOLLATION=”Latin1_General_CI_AS” /SQLCOLLATION=”SQL_Latin1_General_CP1_CI_AS” /TCPENABLED=”1″ /NPENABLED=”1″ /IAcceptSQLServerLicenseTerms