Share This Post

ConfigMgr 2012 Secondary Sites and SQL Server

One change for ConfigMgr 2012 is that Secondary Sites now require a version of SQL Sever running on them.  Why?  Due to the way ConfigMgr 2012 now utilizes SQL replication instead of of file replication (in most instances), an instance of SQL Server is required so that it can continue to report to the parent primary site.  Having SQL Server on the Secondary site also bumps up the supported number of clients for the server.  See:  ConfigMgr 2012 sounds neat, but can it scale?

Does this mean you’ll need to install SQL Server manually on each Secondary site?  No.  While you can if you desire full SQL functionality and optimum license seats on the box, when you install the Secondary site, setup automatically installs SQL Server Express if SQL Server is not already installed.

Share This Post

A community professional, keynoter, and evangelist who has driven social media and marketing strategies, editorial successes, delivered customer successes and built some of the largest and longest-running online communities. Rod has created, managed and grown small, medium, and mega-sized conferences; run entire editorial teams to deliver record traffic and market leadership; as product manager, directed the success of hundreds of product releases; supported sales and marketing to ensure customer success; developed, run and sold businesses; written thousands of technical articles, white papers, case studies, and technical documentation; hosted and delivered hundreds of attendance shattering webinars and virtual tradeshows; and delivered keynote speeches and sessions at a wide variety of events including conferences, webinars, events, and user groups.

Leave a Reply