Jump to content


Kevin Dai

Established Members
  • Posts

    4
  • Joined

  • Last visited

Everything posted by Kevin Dai

  1. Hi Rasheedah, I wrote this article refer to some others engineers' when do some testing just like you want to install CAS and Primary sites on SQL cluster. I remembered that I had completed the testing following this article. Just one thing, the reporting services point configuration had not completed. Maybe there are some problem I have not found. Expect you could succeed. The web site from microsoft FYI. https://docs.microsoft.com/en-us/sccm/core/servers/deploy/configure/use-a-sql-server-cluster-for-the-site-database
  2. I installed SCCM 1511 in the default folder "c:\Program Files", update to 1606 and 1606 UR 1. The AdminConsole was installed in "c:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\". So, the file CreateDeviceCollections.ps1 you attached should be changed the line 89 to following. Import-Module $CMDrive'\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin\ConfigurationManager.psd1' I attached the fixed file. Hope it could help someone. CreateDeviceCollections.zip
  3. Each System Center 2012 Configuration Manager site database can be installed on either the default instance or a named instance of a SQL Serverinstallation. The SQL Server instance can be co-located with the site system server, or on a remote computer. In a hierarchy with multiple sites, each site can use a different version of SQL Server to host the site database so long as that version of SQL Server is supported by the version of Configuration Manager that you use. For example, if your hierarchy runs Configuration Manager SP1, it is supported to use SQL Server 2008 R2 with SP1 and cumulative update 6 at the central administration site, and to use SQL Server 2012 with no service pack and cumulative update 2 at a child primary site, or vice versa. When you use a remote SQL Server, the instance of SQL Server used to host the site database can also be configured as a SQL Server failover cluster in a single instance cluster, or a multiple instance configuration. SQL Server cluster configurations that have multiple active nodes are supported for hosting the site database. The site database site system role is the only System Center 2012 Configuration Manager site system role supported on an instance of a Windows Server cluster. If you use a SQL Server cluster for the site database, you must add the computer account of the site server to the Local Administrators group of each Windows Server cluster node computer. Note A SQL Server cluster in a Network Load Balancing (NLB) cluster configuration is not supported. Additionally, SQL Server database mirroring technology and peer-to-peer replication are not supported. For communication to the SQL Server database engine, and for intersite replication, you can use the default SQL Server port configurations or specify custom ports: · Intersite communications use the SQL Server Service Broker, which by default uses port TCP 4022. · Intrasite communication between the SQL Server database engine and various Configuration Manager site system roles by default use port TCP 1433. The following site system roles communicate directly with the SQL Server database: · Management point · SMS Provider computer · Reporting Services point · Site server When a SQL Server hosts a database from more than one site, each database must use a separate instance of SQL Server, and each instance must be configured to use a unique set of ports. Warning Configuration Manager does not support dynamic ports. Because SQL Server named instances by default use dynamic ports for connections to the database engine, when you use a named instance, you must manually configure the static port that you want to use for intrasite communication With the introduction of the Central Administration site (CAS) option, customers will likely implement the CAS and first local Primary site in the same datacenter. The typical thought is the CAS will be used for central administration, while the Primary site will service clients at each location. Since the CAS and local primary site likely are in the same data center, it might additionally be a desire to combine both site server databases on the same SQL server. This may yield undesirable performance depending on many factors; but is a supported configuration. Below are some pointers to assist you through setting up this model: o Make sure you’re using a supported version of SQL server. o Use a domain account to run as the SQL service. o Ensure the SQL service account has been configured with the appropriate SPN(s). o While installing each of the two instances, ensure they use completely different database directory locations. (this is key because of the MS_AgentSigningCertificate file) o Ensure the “SQL Server Browser” service is installed, set to “Automatic” startup and is running. This will be a requirement for the site servers to find their respective SQL instance. o After each instance is installed, disable dynamic ports and define a specific port for each instance using the SQL Server Configuration Manager. 1. Expand “SQL Server Network Configuration” 2. Select the “Protocols for x” (x=instance name) 3. Double-click “TCP/IP” 4. Select the “IP Addresses” tab 5. For every “TCP Dynamic Ports” field, clear all data (field should be completely empty) 6. For every “TCP Port” field, enter “5033” 7. Repeat steps 1-6 for your second SQL instance, this time using port 5034 You should now be ready to install your CAS and first primary ConfigMgr 2012 sites using their respective and dedicated SQL instances on the same SQL server/cluster.
  4. The following words will have you totally make clear your question. Although, 2 years passed. Each System Center 2012 Configuration Manager site database can be installed on either the default instance or a named instance of a SQL Serverinstallation. The SQL Server instance can be co-located with the site system server, or on a remote computer. In a hierarchy with multiple sites, each site can use a different version of SQL Server to host the site database so long as that version of SQL Server is supported by the version of Configuration Manager that you use. For example, if your hierarchy runs Configuration Manager SP1, it is supported to use SQL Server 2008 R2 with SP1 and cumulative update 6 at the central administration site, and to use SQL Server 2012 with no service pack and cumulative update 2 at a child primary site, or vice versa. When you use a remote SQL Server, the instance of SQL Server used to host the site database can also be configured as a SQL Server failover cluster in a single instance cluster, or a multiple instance configuration. SQL Server cluster configurations that have multiple active nodes are supported for hosting the site database. The site database site system role is the only System Center 2012 Configuration Manager site system role supported on an instance of a Windows Server cluster. If you use a SQL Server cluster for the site database, you must add the computer account of the site server to the Local Administrators group of each Windows Server cluster node computer. Note A SQL Server cluster in a Network Load Balancing (NLB) cluster configuration is not supported. Additionally, SQL Server database mirroring technology and peer-to-peer replication are not supported. For communication to the SQL Server database engine, and for intersite replication, you can use the default SQL Server port configurations or specify custom ports: Intersite communications use the SQL Server Service Broker, which by default uses port TCP 4022. Intrasite communication between the SQL Server database engine and various Configuration Manager site system roles by default use port TCP 1433. The following site system roles communicate directly with the SQL Server database: Management point SMS Provider computer Reporting Services point Site server When a SQL Server hosts a database from more than one site, each database must use a separate instance of SQL Server, and each instance must be configured to use a unique set of ports. Warning Configuration Manager does not support dynamic ports. Because SQL Server named instances by default use dynamic ports for connections to the database engine, when you use a named instance, you must manually configure the static port that you want to use for intrasite communication With the introduction of the Central Administration site (CAS) option, customers will likely implement the CAS and first local Primary site in the same datacenter. The typical thought is the CAS will be used for central administration, while the Primary site will service clients at each location. Since the CAS and local primary site likely are in the same data center, it might additionally be a desire to combine both site server databases on the same SQL server. This may yield undesirable performance depending on many factors; but is a supported configuration. Below are some pointers to assist you through setting up this model: o Make sure you’re using a supported version of SQL server. o Use a domain account to run as the SQL service. o Ensure the SQL service account has been configured with the appropriate SPN(s). o While installing each of the two instances, ensure they use completely different database directory locations. (this is key because of the MS_AgentSigningCertificate file) o Ensure the “SQL Server Browser” service is installed, set to “Automatic” startup and is running. This will be a requirement for the site servers to find their respective SQL instance. o After each instance is installed, disable dynamic ports and define a specific port for each instance using the SQL Server Configuration Manager. 1. Expand “SQL Server Network Configuration” 2. Select the “Protocols for x” (x=instance name) 3. Double-click “TCP/IP” 4. Select the “IP Addresses” tab 5. For every “TCP Dynamic Ports” field, clear all data (field should be completely empty) 6. For every “TCP Port” field, enter “5033” 7. Repeat steps 1-6 for your second SQL instance, this time using port 5034 You should now be ready to install your CAS and first primary ConfigMgr 2012 sites using their respective and dedicated SQL instances on the same SQL server/cluster.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.