In this video I show you how to setup WSUS or Software Update Services in SERVER 2016 using SQL 2016 via POWERSHELL. For me this is the only guaranteed way to get WSUS working using a SQL database instead of WID, Windows Internal Database
POWERSHELL
Install-WindowsFeature -Name UpdateServices-Services,UpdateServices-DB –IncludeManagementTools
Browse to : "c:\program files\update services\tools"
.\wsusutil.exe postinstall SQL_INSTANCE_NAME="YOUR SERVERNAME HERE" CONTENT_DIR=YOUR SYNC FOLDER
Install Report Viewer 2012
http://www.microsoft.com/en-us/downlo...
Install SQL ClearTypes for Report Viewer can be found in the Feature Pack
https://www.microsoft.com/en-us/downl...
GPO Location
Configure GPO \ Policy \ Admin Templates \ Windows Components \ Windows Update
If you use domain account for SQL permissions, add that user to local admin otherwise you'll get access denied errors on log files.