WSUS problem

Event Type: Error
Event Source: Windows Server Update Services
Event Category: Database
Event ID: 421
Date: 7/18/2006
Time: 10:15:55 AM
User: N/A
Computer: MYSERVER
Description:
Connection to database failed. Reason=Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
General network error. Check your network documentation.. Connection string: Data Source=MYSERVER\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'm Googling this....

Found http://wsus.editme.com/ContentFileDownloadFailedAccessDeniedNoHTTP
and http://msmvps.com/blogs/athif/archive/2006/04/18/91472.aspx
and http://blogs.msdn.com/astebner/archive/2005/11/23/496503.aspx

All refer to a hidden setting on the SonicWall firefall (I have a SOHO3):

Enable HTTP 1.1 Range Requests from FIREWALL

If you have a SonicWALL device on your network then, you can use the following steps to resolve this issue:

1. Navigate to http:///diag.html from a computer on your network (by default this URL will be http://192.168.168.168/diag.html).
2. Enable the setting to allow HTTP byte range requests in the gateway anti-virus filtering process.
3. Reboot the SonicWALL firewall device .
4. Attempt to download again.

However, this does not help me, since my SonicWall doesn't run Gateway AV.

The other suggested workaround is:

Set BitsDownloadPriorityForeground=1 using osql.exe on WSUS SQL instance.

1. net stop WSUSservice
2. CD "%ProgramFiles%\Update Services\tools\osql"
3. osql.exe -S -E -b -n -Q "USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1"
4. net start WSUSservice

Notes

• When you run the above command-line, you will get the output as - "(1 row affected)".
• The osql utility can be found under the "%ProgramFiles%\Update Services\Tools\osql" folder.
• Provide the servername with the -S parameter. [Replace

However, someone commented on this blog:

http://wsus.editme.com/ContentFileDownloadFailedAccessDeniedNoHTTP

to add these domains to the Allowed List when using SonicWall's CFS:

enter the following URL's in the Allowed domains http://windowsupdate.microsoft.com http://*.windowsupdate.microsoft.com https://*.windowsupdate.microsoft.com http://*.update.microsoft.com https://*.update.microsoft.com http://*.windowsupdate.com http://download.windowsupdate.com http://download.microsoft.com http://*.download.windowsupdate.com http://wustat.windows.com http://ntservicepack.microsoft.com

I did that, so let's see if it helps......