locked
sccm 2012 rtm CAS & primary RRS feed

  • Question

  • for a production environment i have to implement CAS server & a primary server. So i have some queries to be cleared.

    Can we make a Sql instance for CAS and use or should we install Sql locally along with CAS ?

    OR can we have a SQl server seperate and with 2 Sql instance 1 for CAS & other 1 for primary can we connect to SQL server ?

    please do reply for this ?

    Thursday, June 28, 2012 10:47 AM

Answers

  • Why have you decided to install a CAS?
    It does not make sense to place the database for a CAS and a primary on the same SQL server. There will be too much load on it and you are introducing a single point of failure.

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

    Thursday, June 28, 2012 11:26 AM
  • You can have a remote SQL instance, it doesn't have to be local. You can also host the multiple site databases on the same SQL as long as they are in a seperate instance. Having said all of this, why have a CAS when you only have a single primary site?

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

    Thursday, June 28, 2012 11:37 AM

All replies

  • Why have you decided to install a CAS?
    It does not make sense to place the database for a CAS and a primary on the same SQL server. There will be too much load on it and you are introducing a single point of failure.

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

    Thursday, June 28, 2012 11:26 AM
  • You can have a remote SQL instance, it doesn't have to be local. You can also host the multiple site databases on the same SQL as long as they are in a seperate instance. Having said all of this, why have a CAS when you only have a single primary site?

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

    Thursday, June 28, 2012 11:37 AM