Edit: I’ve posted this on youtube here
During a recent deployment of WSUS on Windows 2012 R2, using WID database, I ran into a problem whereby after I approved updates, they would fail to download. The WSUS console show the following error “The files for this update failed to download”
The application log showed the following Event ID 364 error
And also the following Event ID 10032 error
With such a specific error description in the Event Id 364 I thought finding a solution would be straight forward. And indeed I quickly found this following KB article describing the issue I was experiencing
In my environment we were not using a Sonicwall firewall device, so Method 1 applied to my scenario. Specifically, configure BITS to work in foreground mode. The KB article details the command to run, and for my scenario (WSUS 3.0 with a Windows Internal Database that was created by a default WSUS installation) the solution described was to run the following command:
%programfiles%\Update Services\Setup\ExecuteSQL.exe -S %Computername%\MICROSOFT##SSEE -d “SUSDB” -Q “update tbConfigurationC set BitsDownloadPriorityForeground=1”
However, I did not have the ExecuteSQL.exe utility anywhere on my WSUS server. A missing ExecuteSQL.exe utility scenario is also described on this blog, and pointed me in the right direction.
Firstly, download and install the Microsoft SQL Server 2012 Feature Pack from here. Specifically, you want to install the Native Client & Command Line Utilities
Then open an administrative command prompt to C:\Program Files\Microsoft SQL Server\110\Tools\Binn
Run the following command
SQLCMD.exe -S \\.\pipe\Microsoft##WID\tsql\query -d “SUSDB” -Q “update tbConfigurationC set BitsDownloadPriorityForeground=1”
Once complete, restart the Windows Update service.
After that, my WSUS server was able to download updates successfully from Microsoft Update.