1/26/12

SCCM 2012 RC2 on separate instances on the same SQL Server

My SCCM 2012 RC2 environment consists of one CAS and one Primary site.
To make this work in a common SQL hotel with seperate instances you need to make shure that they don't communicate with the database on the same ports.

During the SCCM 2012 site installation you need to set:
On the CAS-Server "SSB Port" = 4022
On the P01-Server "SSB Port" = 4023

To configure this, go to the SQL Server:
Start SQL Server Configuration Manager
Go to SQL Server Network Configuration
Protocols for CAS-Instance - TCP/IP - Properties - IP Addresses - Set TCP Port = 1433 on all
Protocols for P01-Instance - TCP/IP - Properties - IP Addresses - Set TCP Port = 1434 on all

Done
Posted by at

8 comments:

  1. AnonymousApril 15, 2012 at 9:48 PM

    Hello Henrik,

    I have similar SQL setup (except mine is clustered) but I receive ERROR: Failed to get SQL Server connection to CAS myclustername (instancename\CM_CAS).
    Here's the post link on myITForum:
    http://www.myitforum.com/forums/m235435.aspx

    Please help.

    Thanks

    ReplyDelete
    Replies
    1. Henrik AntinApril 16, 2012 at 3:40 PM

      Hi Kris!

      Have you done all port configurstion above? No firewalls that stops them from communicating?
      Is this your first server that is installed in the hierachy? Are there already other SQL instances on that SQL cluster?

      Best regards
      Henrik

      Delete
    2. Stephan van der PlasJune 19, 2012 at 6:29 PM

      Since Kris doesn't answer and I'm having the same issue, I'll answer your questions:

      The config steps above are followed (the SQL server instance on the cluster which should be used as SCCM 2012 site database is listening on port 1434, which has been confirmed by a telnet from the siteserver-to-be.
      Because I have no CAS, only a primary site, I leave the SSB port on 4022. The firewall has also been opened on this port.
      What can still be going wrong?

      Regards,
      Stephan van der Plas

      Delete
    3. Henrik AntinJune 20, 2012 at 10:33 AM

      Have you set the "TCP Dynamic Ports" to 0 in SQL Server Configuration Manager?

      Regards
      Henrik

      Delete
    4. Stephan van der PlasJune 20, 2012 at 1:47 PM

      Well, yes, I tried. But after restarting the server, or the SQL service, the tcpDynamicPorts is set on a value somewhere in the 50000 range again. How can I make this behavior stop?

      Delete
    5. Henrik AntinJune 20, 2012 at 2:41 PM

      I might have been wrong about the Dynamic ports, I now see that mine is set to Blank..

      Also make sure that you use the correct Cumulutive Updates.
      For the RTM these are:
      http://configurationmanager2012.blogspot.se/2012/05/sccm-2012-rtm-supported-sql-versions.html

      Delete
  2. Stephan van der PlasJune 22, 2012 at 10:08 AM

    Henrik,

    I found the issue. It was a firewall issue, because (temporarily) setting to allow all incoming traffic on the SQL servers firewall solved it.

    THanks for your help.

    ReplyDelete
  3. rmouniakJuly 6, 2018 at 2:52 PM

    Great post thanks for sharing for more update at
    Sql server DBA Online Training Hyderabad

    ReplyDelete

Subscribe to: Post Comments (Atom)