SCCM and WSUS (Cannot open Database “SUSDB”)

 

Today, I came a cross with alert on my SCCM console regarding SUP synchronization.

SCCM

 

After looking into WMC.log. The error log indicates that WSUS is unable to open and connect to DB. (internal DB)

 Cannot open database “SUSDB” requested by the login. The login failed.~~Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.~~

After some research this issue started when latest updates where installed.

The update that was responsible for this issue is  KB3159706.

In documentation this update refers to:

Windows 10 feature updates (denoted by the “Upgrades” classification in WSUS) are staged in encrypted packages to Windows Update several days prior to the actual go-live date. This is to ensure that we can release to all regions simultaneously. The Windows 10 client has been able to decrypt these packages since RTM; however, WSUS was not able to do this. Until now, we have been manually decrypting these packages prior to releasing to the WSUS channel, the process of which is both time consuming and error prone. KB3159706 introduces this functionality to WSUS for Windows Server 2012/R2, such that it can now naively decrypt this content. Skipping this KB means not being able to distribute the Windows 10 Anniversary Update, or any subsequent feature update, via these platforms. Note that Windows Server 2016 will have this functionality at RTM.

 

After initial install, there are some manual steps that needs to be taken.

After the restart If you don’t perform the manual steps, you will see permanent error in the WSUS console and WSUS service exceptions in the event log.

The wsusutil.exe postinstall /servicing command shall be executed after the restart following the installation for it to do its magic.

On next scheduled sync, from below picture, you can see that sync was successful and it  did remove issue/alert from SCCM console.

SCCM1

 

Hope it will help someone.

 

Advertisements

7 thoughts on “SCCM and WSUS (Cannot open Database “SUSDB”)”

  1. Thank you Thank you Thank you!
    Found your blog on the 3rd page of my search.
    I do not use SCCM but received the above error.
    Uninstalled that Update and rebooted and everything is operational again.
    Question is will Microsoft come out with an updated update to remedy the issue?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s