I could not start the WSUS management console due to a connection error on the Windows 2012 R2 server. In the Event Viewer I found this error:
Classic,Audit Failure 12-10-2016 08:03:39 MSSQL$MICROSOFT##WID 18456 Logon
More details:
EventID:18456
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database 'SUSDB'. [CLIENT: <named pipe>]
Solution:
Do not uninstall any Windows Updates, but try this first:
- Open an elevated Command Prompt and run "C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing
- Enable HTTP Activation under .NET Framework 4.5 Features in the Server Manager Add Roles and Features Wizard
- Restart the WSUS service
