This article is not part of the System Center Cloud series but we will use the final product to host System Center database instances.

Install .NET Framework 3.5 SP1 on SCSM servers

There is a known bug that SQL Server installer is not able to install .NET Framework 3.5 and therefore it is good idea to install it before installation of the SQL Server.

  • Install .NET 3.5 from the installation media (offline installation) without the need of downloading it from the Microsoft.
  • Command Prompt
dism.exe /Online /Enable-Feature /FeatureName:NetFX3 /All /Source:D:\Sources\sxs /LimitAccess
  • Do not forget to install .NET 3.5 security updates.

Install Microsoft SQL Server on the second node of the Failover Cluster

  • Add node to a SQL Server failover cluster
  • Check the report. I have only one cluster validation warning caused by a single NIC on othe node.
      • Microsoft Cluster Service (MSCS) cluster verification warnings
  • Choose the instance.
      • SCCM0
  • Confirm the IP address.
  • You cannot change the service accounts but you have to set their passwords.
  • Install
  • Check the results.
  • Instance is now installed in the same directory like in the first node.

Configurations after installation

Configure dependencies in the Failover Cluster Manager

  • When using Mount Points...
    • Cluster Disk - Properties - Dependencies
    • Add Mount Point disk as dependency.

Verify the installation

At this moment your cluster is not in the production so you can trigger failover without worrying that you cause some problem to already connected application.

  • Initiate failover.
  • Dependent resources will follow the SQL Server instance.

Connect to the instance

I recommend to you to install SQL Server Management Studio only on your management server (not on the SQL Server node).

  • Connect using: <SQL Server Network Name (name of the SQL cluster)>\<Instance>
      • contsqlfcic0cm0.ad.contoso.com\SCCM0
« Previous Next »

Part of the series

  1. Building guest (virtual) Failover Cluster on Hyper-V host with Windows Server 2012 R2 - Part 1 - Create virtual machines
  2. Building guest (virtual) Failover Cluster on Hyper-V host with Windows Server 2012 R2 - Part 2 - Install and configure cluster
  3. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 1 - Design
  4. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 2 - Distributed Transaction Coordinator (MSDTC)
  5. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 3 - Configure storage and mount points
  6. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 4 - Install first node
  7. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 6 - Install another instance
  8. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 7 - Manually configure Reporting Services