SCCM - Failed to validate content hash on Distribution Point. Yellow Warning

In SCCM when there are many Distribution Points with different published Software, it may happen that there are validation failures and that WMI repository is inconsistent. The events are represented as in the following table:

 

SCCM by default does not have any tools that allow you to resynchronize the entire WMI repository without removing the Distribution Point Role and adding it again. Let's see how to get around this.

Capture Image for SCCM - WDS - MDT using DISM and WinPE

We often want to capture machines with SCCM using the ISO capture and we have very strange errors, namely because of sysprep, Windows 10 applications or even permissions. One of the easiest ways to accomplish this capture is to not use SCCM's ISO and let us capture the image at a low level. To do this, just use the ADK tools already installed on the SCCM server.

In this Post I will show you the steps to accomplish this task!

Changing SQL Server Collation After Installation and in Production

 

 

In some scenarios we can find different SQL Server collations between the server instance and its databases. Sometimes the collation is fixed in some table columns or inside stored procedures to solve some of relationship problems with columns that have different collations. The most common technique to have a consistent collation for the instance and all it databases has a lot of steps and can sometimes be problematic.

 

A classic example is that when you want to reuse a SQL Server for System Center components and the Collation is not SQL_Latin1_General_CP1_CI_AS (required for the installation)

 

To correct the collations in a few steps is outlined in this Post. It is recommended to create a backup of all databases (including system databases) before take administrative actions on a SQL Server instance. It is important to ensure that there is no fixed collation logic in columns or inside stored procedures, triggers, etc., otherwise the command below may report problems.
In this post I will change  "Latin1_General_CI_AS" collation to "SQL_Latin1_General_CP1_CI_AI"

Upgrade In-Place SCCM 2012 R2 - WIndows Server 2008 R2 to 2012 R2

Today, in the post I will show you how to migrate SCCM operating system from Windows Server 2008 R2 to Windows Server 2012 R2 in-place. I had some problems and that is what I will try to describe in more detail. You can do a in-place upgrade from:

• Windows Server 2012 R2 to Windows Server 2016
• Windows Server 2012 to Windows Server 2012 R2
• Windows Server 2008 R2 to Windows Server 2012 R2 (SCCM 1602 or higher)
 
You cannot go from Server 2008 R2 to Server 2016, Windows Server 2008 to Windows Server 2012 or Windows Server 2008 R2 to Windows Server 2012!

 

The key reason for this change is that most installations of SCCM 2012 R2 are based on Windows Server 2008 R2. And if the SCCM evolves, the operating system also has to evolve. Another possible approach would be to install a Windows Server 2012 R2 from scratch and do a restore of the SCCM and database (keeping the same name and IP). I think the first approach is simpler and I will describe it.

 

SCCM 2012 Error 0x8007000F & 0x80070490

I have installed several SCCM (2007, 2012) and in all of them I have to troubleshoot something :) Yeah! In this case it was an error 0x8007000F \ 0x80070490 when I deployed an image to some Computers that already had an image deployed previously.

SCCM 2012 Troubleshooting Tools

I have installed and configured, for many years, one of the most useful tools of Microsoft, SCCM 2012 (Microsoft System Center Configurations Manager 2012) and the Troubleshooting is not so easy. So in this post I'll reference some of the best apps to do it. You can download the Trial Version of SCCM from here: https://www.microsoft.com/en-us/evalcenter/evaluate-system-center-2012-r2-configuration-manager-and-endpoint-protection

The Management Console has many options to control all the Servers, Clients and Mobile Phones, but there are some other tools that can help the Administrators to achive that objective, and most important is that they are free! I will name some of them.