You are browsing the archive for SQL Cluster.

KB2688247: SQL Server cumulative updates must be manually installed on secondary System Center 2012 Configuration Manager sites that use SQL Server Express

10:21 am in ConfigMgr, ConfigMgr 2012, ConfigMgr 2012 SP1, ConfigMgr V.next, SCCM 2012, SCCM 2012 SP1, SQL, SQL Cluster, SQL Reporting services by Kenny Buntinx [MVP]

 

System Center 2012 Configuration Manager: The original RTM version of Microsoft System Center 2012 Configuration Manager installs Microsoft SQL Server Express 2008 R2 Service Pack 1 (SP1) when you deploy a new secondary site. The minimum supported SQL Server version is Cumulative Update 4 for SQL Server 2008 R2 Service Pack 1 (SP1).

System Center 2012 Configuration Manager Service Pack 1:  System Center 2012 Configuration Manager SP1 requires Cumulative Update 6 for SQL Server 2008 R2 Service Pack 1 (or SQL Server 2008 R2 SP2).

You must manually install the Cumulative Update for SQL Server 2008 R2 SP1 on the new secondary site after the site is installed. More information here : http://support.microsoft.com/kb/2688247

Hope it Helps ,

Kenny Buntinx

Configmgr 2012 RTM / SP1 and remote management points not healthy when running Configmgr DB on a SQL cluster.

7:01 pm in ConfigMgr 2012, ConfigMgr 2012 SP1, SCCM 2012, SCCM 2012 SP1, SQL, SQL Cluster by Kenny Buntinx [MVP]

 

This week I needed to upgrade our TAP customer Configuration Manager 2012 infrastructure from RTM to SP1 beta. Our SQL Server 2008 R2 environment is clustered.

A bit of background information :

At the time I installed this customers Configuration Manager 2012 RTM’s infrastructure , I ran into this issue : http://scug.be/sccm/2012/05/24/issue-configmgr-2012-secondary-sites-or-remote-dp-s-failing-to-serve-as-pxe-service-point and the solution here was to removing the SQL Server 2008 R2 Native client and installing the SQL Server 2008 Native client as we have seen some issues with a SQL 2008 R2 Native Client talking to a cluster on the SQL technet forums.

My SQL Database server is a two-node SQL Cluster, with SC-SCCM-CLUSTER as the name. In addition to the primary site DB, SC-SCCM-CLUSTER also hosts the WSUS database (WSUS is set up on the primary site server as it will have a SUP). The SQL cluster is Windows 2008 R2 SP1, and the SQL Cluster is a 2-node SQL Cluster 2008 R2 SP1 with CU6 (required for SP1).

Now the upgrade and the MP issues :

A fairly simple task but you need to keep a couple of things in mind when upgrading from Configuration Manager 2012 RTM to SP1 . In my environment I have 1 Primary site server and 35 remote sites ( Remote DP with PXE ) where 7 of them have a Management Point installed .

After the upgrade suddenly the Remote Management Points became unhealthy and throwing errors with status code 500 in the mpcontrol.log file  .

*** [08001][-2146893019][Microsoft][SQL Server Native Client 10.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.
*** [08001][-2146893019][Microsoft][SQL Server Native Client 10.0]Client unable to establish connection
*** Failed to connect to the SQL Server, connection type: MP_CONTROL_ACCESS.
Failed to get connection to the configured SQL database.

image

The solution :

The way we resolved the issue was to make the SQL Server certificate trusted. Go to the SQL cluster server and pick a node .

Here are the screenshots of SQL server certificate which you need to export and import to “Trusted Root Certification Authorities” list. You may need to repeat the steps on both SQL nodes and all REMOTE Management Point servers

image

Export the certificate and import it over here . When successful you should see this :

image

When it is done , reboot your server or reboot your Configmgr services and go into the MPcontrol.log . You will see the server talking correctly

image

image

The management point finds it database and can connect to it thanks to the certificate import . You can also verify and look into Certmgr.log at the primary site .

Hope it Helps ,

Kenny Buntinx