A good tip from the “Deployment Bunny” AKA Mikael Nyström regarding the in-place upgrade of a Windows Server 2012 R2 hosting WSUS and it’s SQL instance to Windows Server 2016.
Ok, so you might not do an in-place upgrade, instead you re-install the entire server, but “if” you do, you need to run this command sometimes
Configuration failed for Windows Server Update Services…
Open an elevated command prompt and execute the following
For Windows Internal Database (WID)
%programfiles%update servicestoolswsusutil.exe postinstall CONTENT_DIR=C:WSUS
SQL Server databases
%programfiles%update servicestoolswsusutil.exe postinstall CONTENT_DIR=C:WSUS SQL_INSTANCE_NAME=<database server name>