Saw this issue when I logged into the WSUS database via management studio: SUSDB(Recovery Pending).
When I checked SoftwareDistribution.log with my WSUS, then I realized that NT\Network Service cannot log on the WID database..
So the solution is just to add NT Authority\Network Service to the WSUS database permission. then problem solved 🙂