locked
CAS and Primary databases on same instance? RRS feed

  • Question

  • Can the CAS and Primary site databases exist in the same SQL instance?
    Thursday, April 19, 2012 3:07 PM

Answers

  • It is not possible to use the same instance. CAS and PS each one should have its own SQL instance.

    Best Practices: Use a dedicated SQL Server instance for each site and don't install the SQL Server instance for more than one site on a single SQL Server computer.


    Bechir Gharbi | http://myitforum.com/myitforumwp/community/members/bgharbi/ | Time zone : GMT+1


    Thursday, April 19, 2012 3:35 PM

All replies

  • It can be on a same server but it should use different port..

    During the SCCM 2012 site installation you need to set:
    On the CAS-Server "SSB Port" = 4022
    On the Primary-Server "SSB Port" = 4023
    and also you have to configure the same on SQL server config as well

    Thanks

    Sri

    Thursday, April 19, 2012 3:12 PM
  • It is not possible to use the same instance. CAS and PS each one should have its own SQL instance.

    Best Practices: Use a dedicated SQL Server instance for each site and don't install the SQL Server instance for more than one site on a single SQL Server computer.


    Bechir Gharbi | http://myitforum.com/myitforumwp/community/members/bgharbi/ | Time zone : GMT+1


    Thursday, April 19, 2012 3:35 PM
  • Can this be done on a SQL Cluster? Using a different port or a different instance?
    Friday, February 15, 2013 1:46 AM