All patches from 04/21/16 breaks SUSDB connection
Question
-
I'm running into a problem when I update my WSUS server (Windows 2012 R2) with "any" of the 13 patches from 04/21/16 breaks WSUS. Any patch that required a reboot. To test, I tried each patch individually. Each one would break WSUS after the reboot except for KB3103616. I didn't have any issue with that one patch. I also avoided installing KB3148812 based on the Technet article, but it did not fix the issue. It still fails to connect to the database and clients cannot connect.
https://social.technet.microsoft.com/Forums/en-US/786be517-1d38-4d42-901c-0e586f755453/update-kb3148812-breaks-my-wsus-server?forum=winserverwsus
Log Name: Application
Source: MSSQL$MICROSOFT##WID
Date: 4/22/2016 10:04:52 AM
Event ID: 18456
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: NETWORK SERVICE
Computer: my_wsus_server.domain.edu
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database 'SUSDB'. [CLIENT: <named pipe>]
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##WID" />
<EventID Qualifiers="49152">18456</EventID>
<Level>0</Level>
<Task>4</Task>
<Keywords>0x90000000000000</Keywords>
<TimeCreated SystemTime="2016-04-22T14:04:52.000000000Z" />
<EventRecordID>14775</EventRecordID>
<Channel>Application</Channel>
<Computer>thimble.richmond.edu</Computer>
<Security UserID="S-1-5-20" />
</System>
<EventData>
<Data>NT AUTHORITY\NETWORK SERVICE</Data>
<Data> Reason: Failed to open the explicitly specified database 'SUSDB'.</Data>
<Data> [CLIENT: <named pipe>]</Data>
<Binary>184800000E000000170000005400480049004D0042004C0045005C004D004900430052004F0053004F0046005400230023005700490044000000070000006D00610073007400650072000000</Binary>
</EventData>
</Event>
