locked
SQL Hosting 2007 and 2012 Instances. RRS feed

  • Question

  • Microsoft says the only shared site system is the distribution point. How does that affect SQL. If all of our boxes in our SQL cluster are site systems in 2007 will we have to remove the site role from one of the SQL members and put the new 2012 instance on that box?
    Tuesday, October 23, 2012 9:51 PM

Answers

  • Multiple SQL Server instances can exist on a single SQL Server host and within a single SQL Server cluster. These instances don't even have to be the same version.

    Jason | http://blog.configmgrftw.com

    Wednesday, October 24, 2012 2:12 AM
  • You just have to use a different SQL instance for each ConfigMgr site.

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


    Wednesday, October 24, 2012 12:50 PM

All replies

  • Multiple SQL Server instances can exist on a single SQL Server host and within a single SQL Server cluster. These instances don't even have to be the same version.

    Jason | http://blog.configmgrftw.com

    Wednesday, October 24, 2012 2:12 AM
  • Okay, but when point a SCCM site at a SQL server it makes it a site systems for that site. Microsoft says a box can only be a site system in one site. Since all of the boxes in the SQL cluster are site systems for our 2007 site do we have to do anything to use the same cluster for 2012.
    Wednesday, October 24, 2012 12:31 PM
  • You just have to use a different SQL instance for each ConfigMgr site.

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


    Wednesday, October 24, 2012 12:50 PM