locked
Does SCCM 2012 CAS support the installation of the site database on a remote stretched SQL cluster? RRS feed

  • Question

  • Does SCCM 2012 CAS support the installation of the site database on a remote stretched SQL cluster and can someone point me in the right direction in terms of technet / official microsoft documentation. It does for a primary as per technet documentation but i cannot see this configuration anywhere for a CAS?

    Thanks

    Andrew


    A.G.Heron


    • Edited by andrewH147 Friday, May 18, 2012 9:25 AM
    Friday, May 18, 2012 9:23 AM

Answers

  • At a central administration site and at primary sites, you can co-locate the database server on the site server, or place it on a remote server.

    If you use a remote database server computer, ensure the intervening network connection is a high-availability, high-bandwidth network connection. This is because the site server and some site system roles must constantly communicate with the SQL Server that is hosting the site database.

    Consider the following when you select a remote database server location:

    • The amount of bandwidth required for communications to the database server depends upon a combination of many different site and client configurations; therefore, the actual bandwidth required cannot be adequately predicted.
    • Each computer that runs the SMS Provider and that connects to the site database increases network bandwidth requirements.
    • The computer that runs SQL Server must be located in a domain that has a two-way trust with the site server and all computers running the SMS Provider.
    • You cannot use a clustered SQL Server for the site database server when the site database is co-located with the site server.

    http://technet.microsoft.com/en-us/library/gg682041


    Nicolai

    • Marked as answer by andrewH147 Friday, May 18, 2012 11:54 AM
    Friday, May 18, 2012 11:21 AM