RSS

Monthly Archives: March 2013

Installing OpsMgr 2012 SP1 using a SQL 2012 AlwaysOn Availability Group: does it work or not?

In my previous blogpost I attempted to installed ConfigMgr 2012 SP1 on an AlwaysOn Availability Group, which failed…

In my lab environment I’ve decided to use the same AlwaysOn Availability Group to check if I’m able to install OpsMgr 2012 SP1 databases on this configuration and see if it works…

On the following TechNet page, I don’t find any relevant information if this is supported or not:

http://technet.microsoft.com/en-us/library/jj656654.aspx#BKMK_RBF_OperationsDatabase

The installation of OpsMgr 2012 SP1 requires 2 databases. I’ve decided to install them on the same group.

During setup I selected the hostname of the Availability Group Listener, setup immediately found the paths where the databases are going to be installed.

After that, setup went smoothly and the console starts without any problems.

I noticed a few things though:

  • The databases were created but I had to configure them for AlwaysOn replication. This means the recovery model of both databases had to be set to ‘full’ and backup jobs had to be executed
  • SQL Reporting is not cluster aware and high availability is not possible. I installed OpsMgr Reporting on the Primary node of the AlwaysOn Availability Group (I could not select the host name of the Group Listener.

So yes it works…

As usual, feel free to test this yourself in a test environment to familiarize yourself with this before putting it in a production environment.

UPDATE: after some digging on TechNet I found the following link which gives an overview which System Center 2012 SP1 products support AlwaysOn:

http://technet.microsoft.com/en-us/library/jj628198.aspx

Here’s a clear statement that only ConfigMgr and DPM are not supported…

Advertisements
 

Installing ConfigMgr 2012 SP1 using a SQL 2012 AlwaysOn Availability Group: does it work or not?

High availability of a ConfigMgr 2012 SP1 Site is something that is regularly required by customers who ask for my assistance in deploying it.

One major item of deploying high availability is having the site database highly available.

The supported configurations are available at the following location:

http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig

However, I notice that nothing is mentioned if AlwaysOn availability groups are supported by ConfigMgr 2012 SP1 or not. I can’t really get a clear statement from Microsoft either if this is supported or not. So I’ve decided to find out myself.

First, I built an SQL 2012 Availability Group using the following steps:

  1. I installed 2 Windows Server 2012 machines, each with a single NIC
  2. I created a 2 node cluster without using shared storage
  3. On both machines, I installed a stand-alone SQL 2012 instance which match the ConfigMgr 2012 SP1 SQL requirements. I used the default instance on both machines. I used a user account to start the SQL Services and I made sure firewall ports TCP 1433 and TCP 5022 are allowed (honestly I disabled to firewall completely to keep my test simple, it’s a lab environment anyway)
  4. I created a dummy database to establish the AlwaysOn cluster (database is of the ‘full’ type model), I also made a backup of this database
  5. I created the AlwaysOn group and the AlwaysOn listener. I also provided a network share on a separate machine for facilitatin the AlwaysOn replicas. One SQL server is the Primary machine, the other one is the secondary
  6. I setup the database for full synchronization
  7. After this step I the Availability Group is created successfully

I have 3 names I could provide during ConfigMgr 2012 SP1 setup:

  1. The FQDN of the Windows cluster
  2. The FQDN of the Listener
  3. The FQDN of the Primary SQL server of the AlwaysOn Availability Group

Option 1 didn’t work. While ConfigMgr Setup allowed me to continue until the Prerequisite Check, I received an error message:

The failing prerequisite is “Primary FQDN” (Configuration Manager only supports the use of primary FQDN’s, where the DNS hostname (first label in the FQDN) matches the NetBIOS hostname of the computer.  The FQDN provided for this site system does not meet this requirement and cannot be used.  Correct the FQDN and try again.).

Option 2 didn’t work either. I immediately received an error message:

The Network Path is not valid.

Option 3 worked but that is not a HA solution.

To me this means it’s not possible to install ConfigMgr 2012 SP1 using a SQL 2012 AlwaysOn Availability Group, it doesn’t work.

I learned that you can successfully create an AlwaysOn Availability Group on a cluster with shared storage. To be honest, I don’t see the added value for ConfigMgr 2012 SP1. ConfigMgr 2012 SP1 has a lot of functionalities by itself regarding the Site Database so don’t really need to use the functionality SQL 2012 provides.

To provide high availability for the Site database, you have the following options:

  • Use a cluster with shared storage
  • When using virtual machines, provide failover facilities on the hypervisor level by having a hypervisor cluster or use a replica server that Hyper-V 3.0 offers…

I also need to verify with Microsoft if AlwaysOn is actually supported since TechNet doesn’t state anything about this.

UPDATE: after some digging on TechNet I found the following link which gives an overview which System Center 2012 SP1 products support AlwaysOn:

http://technet.microsoft.com/en-us/library/jj628198.aspx

Here’s a clear statement that only ConfigMgr and DPM are not supported…

 

 
 
Steve Thompson [MVP]

The automation specialist

Boudewijn Plomp

Cloud and related stuff...

Anything about IT

by Alex Verboon

MDTGuy.WordPress.com

Deployment Made Simple

Modern Workplace

Azure, Hybrid Identity & Enterprise Mobility + Security

Daan Weda

This WordPress.com site is all about System Center and PowerShell

IT And Management by Abheek

Microsoft certified Trainer -Abheek

Heading To The Clouds

by Marthijn van Rheenen