none
How to Create an SCCM 2012 Secondary Site Using Pre-Installed SQL Server 2008 R2 SP1 Express RRS feed

  • Question

  • I am looking for some official documentation on how to install a SCCM 2012 Secondary Site onto a server using the "Use an exisiting SQL Server instance" option.

    Because of internal standards I need to install SQL on a drive other than C:\ (OS Drive) which is not possible when installing a Secondary Site using the ConfigMgr console.

    My only option seems to be to pre-install SQL 2008 R2 SP1 Express Edition manually (or using a ConfigurationFile.ini) onto the server that will host the Secondary Site which is fine but I am struggling to find any official documentation on how this should be done and I want to ensure that the install is fully supported and secure.

    I have seen the article http://blog.tyang.org/2012/04/09/installing-sccm-2012-rtm-secondary-site-using-a-pre-installed-sql-express-2008-r2-instance/ which would seem to meet the requirements but I was wondering if anyone knows of any official Microsoft documentation or Blog posts which describe the process so that I can work from that?


    Jonathan Conway | My blog: Conway's IT Blog | Twitter: jonconwayuk | Linkedin: Jonathan Conway

    MCITP: Enterprise Administrator • MCP • MCSE 2003 • MCTS SCCM 2007, Windows 7 Config & Deploying • VCP

    Wednesday, May 30, 2012 1:56 PM

Answers

  • well if you look at the actual commands used to Install SQL Server Express during a Secondary site installation as initiated from the Console on the Primary the following is logged on the secondary site in C:\ConfigMgrSetup.log

    here's the line in question:

    INFO: The SQL Server Express installation command is:<"C:\44N1402S.TMP\SMSSETUP\BIN\X64\SQLEXPR_x64_ENU.exe" /Q /ACTION=install /FEATURES=SQL /INSTANCENAME=CONFIGMGRSEC /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /ADDCURRENTUSERASSQLADMIN="True" /BROWSERSVCSTARTUPTYPE="Automatic" /IAcceptSQLServerLicenseTerms /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS">

    so you could try and manipulate the installation script to install your copy of SQL Server with the desired path, and once done start the secondary site installation

    cheers

    niall



    Step by Step ConfigMgr 2007 Guides | Step by Step ConfigMgr 2012 Guides | I'm on Twitter > ncbrady

    Thursday, June 7, 2012 8:23 AM

All replies

  • This is supported, see http://technet.microsoft.com/en-us/library/gg712681.aspx: "SQL Server Express or a full instance of SQL Server is required. If neither is installed when the site is installed, SQL Server Express is automatically installed."

    Torsten Meringer | http://www.mssccmfaq.de

    Wednesday, May 30, 2012 2:06 PM
  • This is supported, see http://technet.microsoft.com/en-us/library/gg712681.aspx: "SQL Server Express or a full instance of SQL Server is required. If neither is installed when the site is installed, SQL Server Express is automatically installed."

    Torsten Meringer | http://www.mssccmfaq.de

    Hi Torsten,

    I'd already checked the versions which were supported but I was looking for documention on exactly how to install SQL 2008 R2 Express to make sure it was the same as what would be done through the console by the ConfigMgr installer (apart from those items I want to change such as the install directory, administrators etc.).

    I guess I was after a walk-through guide on how to do this that was from Microsoft rather than a third party blogger (no disrespect to Tao who wrote the article linked above of course!).


    Jonathan Conway | My blog: Conway's IT Blog | Twitter: jonconwayuk | Linkedin: Jonathan Conway

    MCITP: Enterprise Administrator • MCP • MCSE 2003 • MCTS SCCM 2007, Windows 7 Config & Deploying • VCP

    Wednesday, May 30, 2012 2:20 PM
  • http://cm12secsitescript.codeplex.com/

    This also doesn't strictly adhere to your "from Microsoft" request (because it's not microsoft.com for an address), but I happen to know that it's a Microsoft ConfigMgr person who started that codeplex project.  So... it's as close to your request as I could think you could get.


    Standardize. Simplify. Automate.

    Wednesday, May 30, 2012 3:32 PM
  • http://cm12secsitescript.codeplex.com/

    This also doesn't strictly adhere to your "from Microsoft" request (because it's not microsoft.com for an address), but I happen to know that it's a Microsoft ConfigMgr person who started that codeplex project.  So... it's as close to your request as I could think you could get.


    Standardize. Simplify. Automate.

    Hi Sherry - thanks for your response.

    That script will be useful for other scenarios however what I'm actually after here is an official walk-through of how to install SQL Server 2008 R2 SP1 manually (so that I can change the install path) which will make sure that it ends up being configured the same as if I had installed it using the ConfigMgr console.


    Jonathan Conway | My blog: Conway's IT Blog | Twitter: jonconwayuk | Linkedin: Jonathan Conway

    MCITP: Enterprise Administrator • MCP • MCSE 2003 • MCTS SCCM 2007, Windows 7 Config & Deploying • VCP

    Thursday, May 31, 2012 9:14 AM
  • well if you look at the actual commands used to Install SQL Server Express during a Secondary site installation as initiated from the Console on the Primary the following is logged on the secondary site in C:\ConfigMgrSetup.log

    here's the line in question:

    INFO: The SQL Server Express installation command is:<"C:\44N1402S.TMP\SMSSETUP\BIN\X64\SQLEXPR_x64_ENU.exe" /Q /ACTION=install /FEATURES=SQL /INSTANCENAME=CONFIGMGRSEC /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /ADDCURRENTUSERASSQLADMIN="True" /BROWSERSVCSTARTUPTYPE="Automatic" /IAcceptSQLServerLicenseTerms /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS">

    so you could try and manipulate the installation script to install your copy of SQL Server with the desired path, and once done start the secondary site installation

    cheers

    niall



    Step by Step ConfigMgr 2007 Guides | Step by Step ConfigMgr 2012 Guides | I'm on Twitter > ncbrady

    Thursday, June 7, 2012 8:23 AM
  • well if you look at the actual commands used to Install SQL Server Express during a Secondary site installation as initiated from the Console on the Primary the following is logged on the secondary site in C:\ConfigMgrSetup.log

    here's the line in question:

    INFO: The SQL Server Express installation command is:<"C:\44N1402S.TMP\SMSSETUP\BIN\X64\SQLEXPR_x64_ENU.exe" /Q /ACTION=install /FEATURES=SQL /INSTANCENAME=CONFIGMGRSEC /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /ADDCURRENTUSERASSQLADMIN="True" /BROWSERSVCSTARTUPTYPE="Automatic" /IAcceptSQLServerLicenseTerms /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS">

    so you could try and manipulate the installation script to install your copy of SQL Server with the desired path, and once done start the secondary site installation

    cheers

    niall



    Step by Step ConfigMgr 2007 Guides | Step by Step ConfigMgr 2012 Guides | I'm on Twitter > ncbrady

    The simple ideas are always the best ones. Spot on Niall - that's exactly what I was after and it's so obvious now you've said it! Thanks for the suggestion.

    Jonathan Conway | My blog: Conway's IT Blog | Twitter: jonconwayuk | Linkedin: Jonathan Conway

    MCITP: Enterprise Administrator • MCP • MCSE 2003 • MCTS SCCM 2007, Windows 7 Config & Deploying • VCP

    Thursday, June 7, 2012 8:26 AM
  • Here is step by step installation of Secondary site server with Pre-configured SQL Express.

    http://fritschetom.blogspot.in/2013/04/step-by-step-configmgr-2012-sp1-cu1.html

    http://blog.tyang.org/2013/01/23/installing-sccm-2012-sp1-secondary-site-with-a-pre-configured-sql-2012-instance/


    Kirpal Singh


    Wednesday, May 1, 2013 9:06 AM