Microsoft patch KB3148812 (Link to the KB article has been removed by Microsoft), has an know issue when you have a WSUS server installed on you MS Windows Server 2012 R2.
A messages that was found in the application log of the server:
Log Name: Application
Event ID: 18456
Task Category: Logon
Keywords: Classic,Audit Failure
User: NETWORK SERVICE
Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. Reason: Failed to open the explicitly specified database ‘SUSDB’. [CLIENT: <named pipe>]
<Provider Name=”MSSQL$MICROSOFT##WID” />
<Security UserID=”S-1-5-20″ />
<Data>NT AUTHORITY\NETWORK SERVICE</Data>
<Data> Reason: Failed to open the explicitly specified database ‘SUSDB’.</Data>
<Data> [CLIENT: <named pipe>]</Data>
Microsoft has released a patch for this issue.
But don’t forget the manual steps that need to be executed, else the problem will be remain on your WSUS server. Solution article of Microsoft >> KB3159706
I did the following steps, (WSUS server has no SSL certificate activated, so last part of the process doesn’t be execute in my case.)
See that the above updates have been installed. When not, install these manually and proceed then with the manual steps.
- Open an elevated Command Prompt window, and then run the following command (case sensitive, assume “C” as the system volume):
"C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing
- Activate HTTP Activation under .NET Framework 4.5 Features (Via powershell)
Display Name Name Install State
------------ ---- -------------
[X] WCF Services NET-WCF-Services45 Installed
[X] HTTP Activation NET-WCF-HTTP-Activat... Installed
[ ] Message Queuing (MSMQ) Activation NET-WCF-MSMQ-Activat... Available
[ ] Named Pipe Activation NET-WCF-Pipe-Activat... Available
[ ] TCP Activation NET-WCF-TCP-Activati... Available
[X] TCP Port Sharing NET-WCF-TCP-PortShar... Installed
- Restart the WSUS Service
net stop "WSUS service"
net start "WSUS service"
After this step the problem has been resolved when you have no SSL certificate activated for your WSUS server else you need to continue with steps 03 & 04.