Answered by:
CAS and Primary databases on same instance?

Question
-
Can the CAS and Primary site databases exist in the same SQL instance?
- Moved by Stan White [MSFT]Microsoft employee Friday, April 20, 2012 11:28 PM Moving to correct forum category for the topic (From:Configuration Manager 2012 - General)
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
- Edited by Bechir Gharbi Thursday, April 19, 2012 3:37 PM
- Proposed as answer by Moiz Rassiwala[MSFT]Microsoft employee Thursday, April 19, 2012 4:38 PM
- Marked as answer by Eddie Thrace Thursday, April 19, 2012 5:45 PM
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 wellThanks
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
- Edited by Bechir Gharbi Thursday, April 19, 2012 3:37 PM
- Proposed as answer by Moiz Rassiwala[MSFT]Microsoft employee Thursday, April 19, 2012 4:38 PM
- Marked as answer by Eddie Thrace Thursday, April 19, 2012 5:45 PM
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