Close Menu
    Trending

    Installing SQL Server 2008 R2 for SCCM 2012

    2
    By on Uncategorized

    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

    My name is Ronni Pedersen and I'm currently working as a Cloud Architect at APENTO in Denmark. My primary focus is Enterprise Client Management solutions, based on technologies like AzureAD, Intune, EMS and System Center Configuration Manager. I'm is also a Microsoft Certified Trainer and Microsoft MVP in Enterprise Mobility.

    Related Posts

    2 Comments

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

    2. Paul McLatchie on

      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

      Reply
    Leave A Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.