locked
SCCM 2012 R2 Standalone primary site installation. RRS feed

  • Question

  • Hi All,

    I am planning to build standalone primary site(SCCM 2012 R2). 

    Total clients around 20,000 in my hierarchy and having good NW speed between the sites. Is there any difference placing the SQL DB on the remote server or we can place the SQL DB on the same site server?

    Couple of Technet blogs specified there is no difference if we install either Standard or enterprise edition of SQL for standalone primary site and supports 1,00,000 clients for standalone primary site

    If we install SQL 2012 standard version on same site server, is it required to pay any additional licence for SQL 2012 server?

    what are the Hardware and network configuration required for primary and secondary sites?

    TIA

    Bhavani


    Bhavani Y

    Tuesday, November 17, 2015 7:20 AM

Answers

All replies

  • SQL license is included in the System Center license. I'd install SQL locally if the hardware can handle the load. 

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

    • Proposed as answer by Frank Dong Tuesday, November 17, 2015 8:53 AM
    • Marked as answer by Frank Dong Monday, December 7, 2015 1:50 AM
    Tuesday, November 17, 2015 7:55 AM
  • what are the Hardware and network configuration required for primary and secondary sites?

    Hardware Configurations :
    https://technet.microsoft.com/en-us/library/hh846235.aspx?f=255&MSPPError=-2147217396

    Supported Configurations:

    https://technet.microsoft.com/en-us/library/gg682077.aspx


    Eswar Koneti | Configmgr Blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: eskonr

    • Proposed as answer by Frank Dong Tuesday, November 17, 2015 8:54 AM
    • Marked as answer by Frank Dong Monday, December 7, 2015 1:50 AM
    Tuesday, November 17, 2015 8:45 AM
  • Thanks for the update Torsten.


    One more thing if i install SQL 2012 server on remote server, do we need to pay additional SQL licence? 


    Bhavani Y



    • Edited by Bhavani Y Tuesday, November 17, 2015 9:43 AM
    Tuesday, November 17, 2015 9:25 AM
  • If i install the SQL 2012 standard on site server. SCCM 2012 R2 primary site will support 1,00,000 clients or 50,000?. --SQL standard will support 50K (on local server) clients ,more than that enterprise would do but it doesn't increase the count if you upgrade to enterprise from Standard after you install SQL Standard.

    One more thing if i install SQL 2012 server on remote server, do we need to pay additional SQL licence?  --> It is recommended  to have SQL server on local instead of remote for several good reasons and license included with system center but Remote, it may add up license cost(I believe) .Why should you consider SQL on local instead of Remote ? https://stevethompsonmvp.wordpress.com/2014/12/20/why-you-should-not-use-remote-sql-server-with-configmgr-2012/


    Eswar Koneti | Configmgr Blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: eskonr



    • Edited by Eswar konetiMVP Tuesday, November 17, 2015 9:48 AM
    • Proposed as answer by Kannan CS Tuesday, November 17, 2015 9:57 AM
    Tuesday, November 17, 2015 9:45 AM
  • Thanks Eswar for the update.

    Following technical article specified "Stand-alone primary site, with a local site database, or a remote site database ' will support 1,00,000 clients.

    https://technet.microsoft.com/en-us/library/gg682077.aspx


    Bhavani Y

    Tuesday, November 17, 2015 10:55 AM
  • Thanks Eswar for the update.

    Following technical article specified "Stand-alone primary site, with a local site database, or a remote site database ' will support 1,00,000 clients.

    https://technet.microsoft.com/en-us/library/gg682077.aspx


    Bhavani Y

    i could not able to find above said information from the link you posted.are you referring to SUP or standalone primary ? can you recheck once again ?

    Eswar Koneti | Configmgr Blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: eskonr

    Tuesday, November 17, 2015 11:18 AM
  • Why you should not use remote SQL Server with ConfigMgr 2012

    Don't install SQL remotely if you can at all avoid it.


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Tuesday, November 17, 2015 12:44 PM
  • Eswar please refer the "Clients per Site" section...

    Bhavani Y

    Tuesday, November 17, 2015 2:02 PM
  • Thanks Jason.

    As per you recommendation can we install SQL on the site server instead of remote?

    we are planning to build Standalone primary site with 5 secondary sites and 25 DP's.

    Total clients : 20,000


    Bhavani Y


    • Edited by Bhavani Y Tuesday, November 17, 2015 2:06 PM update
    Tuesday, November 17, 2015 2:04 PM
  • Thanks Jason.

    As per you recommendation can we install SQL on the site server instead of remote?

    we are planning to build Standalone primary site with 5 secondary sites and 25 DP's.

    Total clients : 20,000


    Bhavani Y


    Sure, as Torsten stated, if your hardware can handle the load the number you are mentioning is fine for a local/standalone installation.

    http://www.systemcenterdudes.com/sccm-2012-r2-installation-guide/


    Benoit Lecours | Blog: System Center Dudes

    Tuesday, November 17, 2015 2:11 PM
  • Not only "can" you, you absolutely *should* do this for the reason Steve gave in the post I linked to.

    Jason | http://blog.configmgrftw.com | @jasonsandys

    Tuesday, November 17, 2015 2:34 PM
  • Eswar please refer the "Clients per Site" section...

    Bhavani Y

    Yes, I see that for standalone Primary site, But looking at your requirement,support of clients are less than 50K and local SQL server would suffice that.

    Eswar Koneti | Configmgr Blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: eskonr

    Wednesday, November 18, 2015 1:18 AM