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:
2 Comments
Pingback: Eswar Koneti's Blog » Blog Archive » Installation of ConfigMgr(SCCM) 2012 RC2
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