ConfigMgr 1702: Adding a new Secondary Replica to an existing SQL AO AG

Hello everyone, Our colleague Umair Kahn has a helpful post on his blog where he and Sean Mahoney walk through adding a new secondary replica node to an existing SQL Server Always On availability group for a primary site server. This process involves several steps Adding the new server as a secondary replica. Stopping the… Read more

Support Tip: Running TestDBUpgrade does not complete and logs “Failed to create process of SetupWpf.exe” error

~ Rafid Ali Hello Everyone, Rafid Ali here with another Configuration Manager support tip for you. I recently came across a scenario where a TestDbUpgrade was failing due to a custom database table which was created after adding custom hardware inventory classes in Configuration Manager 2012 R2 Service Pack 1. It was failing to execute… Read more

Recreating the SUSDB and WSUS Content folder for a Windows Server 2012 based WSUS computer

Author: Meghan Stewart | Support Escalation Engineer Occasionally you may find that you want to start over in WSUS with a fresh database (SUSDB). There can be any number of reasons for this, but typically I see people doing this if their SUSDB is rather old, has a ton of unneeded updates in it, and… Read more

How to implement a shared SUSDB for Configuration Manager Software Update Points

If you have read the Best Practices for Software Updates in Configuration Manager, you may have noticed that we recommend sharing the SUSDB for Software Update Points (SUPs) off the same Configuration Manager site server. A shared SUSDB setup is becoming increasingly common place, however it can be a bit confusing navigating exactly how to… Read more

New KB: SQL query times out or console slow for certain Microsoft Configuration Manager database queries

Hi everyone, I just wanted to take a minute and let you know that we have a new KB article out for an issue where SQL queries may time out, or the admin console may be slow when running certain Configuration Manager database queries. Note that this issue is specific to environments running Microsoft SQL… Read more

Support Tip: Avoiding sync problems when WSUS computers share SUSDB

Hi everyone, my name is Bindusar Kushwaha and I’m a Support Escalation Engineer on the Configuration Manager team. I ran into an interesting case the other day so I thought I’d take a minute to share it with you in case you happen to see it in your environment. The Problem Let’s say you’re running… Read more

Troubleshooting the Database Replication Service in Microsoft Configuration Manager

Hi everyone, just a quick note to let you know we have a new guide available that helps you troubleshoot the Database Replication Service in Microsoft Configuration Manager. The guide helps determine the type of DRS problem you are experiencing, explains how the processes work, and offers troubleshooting suggestions for some of the more common… Read more

Tips on monitoring database replication efficiency in Microsoft Configuration Manager

Microsoft’s own Rob York just published a great post over on The Manageability Guys blog that takes a look at DRS replication within System Center 2012 Configuration Manager and discusses some of the impacts that you might see in a busy site.  If you are running a single site environment then this article is not… Read more

HOTFIX: Restore fails when the site database uses SQL Server 2014 on a server that is running ConfigMgr 2012

The Microsoft System Center 2012 R2 Configuration Manager (ConfigMgr 2012 R2) Setup Wizard may fail when you try to restore a database on a site that has Microsoft SQL Server 2014 installed. In this scenario you may also receive the following error logged in the Configuration Manager Setup log: The SQL Server is not… Read more