You are browsing the archive for Software updates.

Upgrading from ConfigMgr 1702 to 1706 gives you “Microsoft SQL Server reported SQL message 2627, severity 14” in your status messages

7:58 am in 1702, 1706, ConfigMgr, ConfigMgr CB, Software updates, SQL, System Center by Kenny Buntinx [MVP]

If you upgraded your ConfigMgr 1702 or earlier environment to Configmgr 1706 and in the status messages after the upgrade you get :

Microsoft SQL Server reported SQL message 2627, severity 14: [23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint ‘SUM_DriverUpdates_PK’. Cannot insert duplicate key in object ‘dbo.SUM_DriverUpdates’. The duplicate key value is (d8483f4f-0390-49db-b251-faf884dd8eaf

Be aware that the Product Group are aware of this issue and are on a working on a fix. The result of this problem is that admins cannot see new Surface driver updates.

Other than that, nothing else is impacted so it can be ignored.

Hope it helps ,

Kenny Buntinx

MVP Enterprise Mobility

HCIDKIDT ever since CM12 R2 SP1 : Software update groups additional data available in the console

6:09 pm in 2012R2, CM12 R2, CM12 R2 SP1, CM12 SP2, SCCM 2012 R2, SCCM 2012 R2 SP1, Software updates by Kenny Buntinx [MVP]


Hello Folks ,

I didn’t realize that one of my personal wishes has been granted in CM12R2 sp1. I always wanted a quick overview at my software group on how much updates it contained , how many expired and to how many collection I deployed it too …and now it is reality . Good work PG !

Non R2 SP1 :


With R2 SP1 :



Hope it Helps ,

Kenny Buntinx

SCCM : Software Updates are hanging.

7:34 am in ConfigMgr, ConfigMgr 2007, ConfigMgr 2007 R2, ConfigMgr SP2, configmgr2007, Installation, sccm, SCCM 2007, SCCM 2007 R2, SCCM 2007 R3, SCCM 2007 SP2, sccm2007, Software updates, wsus by Kenny Buntinx [MVP]

Issue :

A XP client keeps failing on 2 updates that are marked as missing , but no errors could be found in the SCCM client logs , neither in the Windows Update Agent.log. You only get this line in the log file :

Update (Site_308CBE75-86C9-4D9D-AC4E-410079CCF8A2/SUM_5bf6aa01-2591-4966-95a6-afa7b5b6ac68) Progress: Status = ciStateError, PercentComplete = 0, DownloadSize = 0, Result = 0x80040656

Solution :

The solution is explained in KB artible :

Method for Windows 2000, Windows XP, or Windows Server 2003

To resolve this issue, register the Softpub.dll, Wintrust.dll, Initpki.dll, and Mssip32.dll files. To register these files, follow these steps:

1. Click Start, click Run, type cmd, and then click OK.

2. At the command prompt, type regsvr32 Softpub.dll /s, and then press ENTER.

3. At the command prompt, type regsvr32 Wintrust.dll /s, and then press ENTER.

4. At the command prompt, type regsvr32 Initpki.dll /s, and then press ENTER.

5. At the command prompt, type regsvr32 Mssip32.dll /s, and then press ENTER.


After you re-register the above dll’s , you perform a software update scan.From than the updates will install normally.


Hope it helps ,

Kenny Buntinx