This is for when the clean up wizard is borking out and repeatedly running it doesn’t feel like its making any progress (not that it tells you anyway).
The server/instance name to connect to with SSMS is:
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
If the above doesn’t work then just uninstall WSUS and start again… its not that painful apart from the amount of crap you have to download.
wuauclt /detectnowhttps://mcpmag.com/articles/2017/08/10/automate-wsus-using-the-powershell-updateservices.aspx
https://www.business.com/articles/powershell-windows-software-update-services/
WSUS Commands in Windows 10 / Server 2016:
https://omgdebugging.com/2017/10/09/command-line-equivalent-of-wuauclt-in-windows-10-windows-server-2016/
usoclient StartScan
WSUS in PowerShell:
https://docs.microsoft.com/en-us/powershell/module/wsus/get-wsusserver?view=win10-ps
That really annoying error that won’t go away about you not being able to make config changes to WSUS as there are some already underway.
Assuming you’ve had this error for a couple of days or more then the fix is below. If you haven’t had this error for a few days then wait longer! Some processes such as changing the languages that you are downloading can take days!!
You need to install SQL Management Studio (or SQL Express)
Then connect to the database by using the following servername:
Then run the following SQL query:
UPDATE tbSingletonData
SET ResetStateMachineNeeded = 0
Further Reading:
https://blogs.msdn.microsoft.com/vedvyas/2014/08/19/following-is-the-steps-to-connect-to-these-windows-internal-database-on-windows-2012-machine-this-to-access-the-wap-configuration-from-the-adfs-configuration-database/
https://community.spiceworks.com/topic/737987-wsus-server-cannot-save-configuration-because-the-server-is-still-prcoessing