WSUS 3.0 not updating after successful sync.

Posted on 2007-10-02
Last Modified: 2008-06-20
I have a Windows 2003 server fully patched and have installed sql 2005 express.  Everything seems to go well, the sync complets but the event viewer tells me that the server is failing to download some updates and Background:  Win 2003 server (not Small Biz, WSUS 3.0 fresh install)
I am not able to download updates after the sync says that it is succeeded.  Event log is telling me: ontent file download failed. Reason: The server does not support the necessary HTTP protocol. Background Intelligent Transfer Service (BITS) requires that the server support the Range protocol header.
 Source File: /msdownload/update/v3-19990518/cabpool/ Destination File: c:\WSUS\WsusContent\90\2D61787A6B680A97D66784817D8847EB6DEEA490.CAB.

We had a wsus 2.0 server that ran just fine and downloaded all updates with no issues.  We are not staying with it do to hardware upgrades.  

I have posted the question and thought that the issues had been fixed but i'm back to sq. 1.

Any help would be great!

Question by:IT_Department
    LVL 51

    Expert Comment

    Was SQL Express already on the server before you installed WSUS?  or was it installed with WSUS?

    Try this:

    This problem occurs if your proxy environment doesnt support HTTP 1.1 Protocol. You can manually work around this by running the following commands at the command prompt to configure BITS.

     To resolve this issue:
     1.  Type: net stop WSUSService, and then press ENTER.
    2.  Type: "%programfiles%\Update Services\tools\osql\osql.exe"  -S SQL_InstanceName -E -b -n Q "USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1" and then press ENTER.
    3.  Type: net start WSUSService.
    4.  Close the command prompt window and retry synchronization: in the WSUS console, click Options, click Synchronization Options, and then under Tasks, click Synchronize now.
    LVL 51

    Expert Comment

    That got butchered a bit:

    2.  Type: "%programfiles%\Update Services\tools\osql\osql.exe"  -S SQL_InstanceName -E -b -n -Q "USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1" and then press ENTER.

    Where SQL_InstanceName is the WSUS instance in SQL Express (normally SUSDB).


    Author Comment

    For whatever reason i do not have the osql folder under the tools folder.  I tried the windows internal db and now i have installed sql 2005 express.  during the wsus install told it to use the sql db.  any ideas???
    LVL 51

    Accepted Solution

    Is there an osql folder in the SQL Express folder?  Just search for osql.exe (it actually should just run from the Run box if the path is correct).

    osql.exe"  -S SQL_InstanceName -E -b -n -Q "USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1"

    If you can't set this up, then remove things and clean up then try again.

    Uninstall SQL Express (you don't need this for anything else, do you?)
    Uninstall WSUS.


    Rerun the setup and accept the defaults.
    Place the WSUS repository on a second partition (or drive).
    Setup your options.

    Leave it overnight.

    Author Comment

    I have ran the work around that this is what is returned:

    [SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
    Server [2].
    [SQL Native Client]Login timeout expired
    [SQL Native Client]An error has occurred while establishing a connection to
    the server. When connecting to SQL Server 2005, this failure may be caused by
    the fact that under the default settings SQL Server does not allow remote
    LVL 51

    Expert Comment

    The WSUS admin account needs access to the DB in SQL.  This is why I say that unless you're a DB Admin and understand how the instances and access need to be configured, then remove it all and install WSUS cleanly.


    Author Comment

    I have reinstalled all of WSUS 3.0, report viewer, .net2 & 3.0 with all updates using windows internal database, and i am still running into the same issue of the server not downloading any updates after approval.  Any new ideas??

    Expert Comment

    I had the same problem and here is what fixed it

    Open IIS Manager
    If there is a WSUS Administration expand it to find the Content website.  If there is no WSUS Administration site then look for the Content site under the Default Website (the location of the Content Site depends on options during the install).

    Right click content and go to properties.
    Click the BITS Server Extension tab and check the Allow Clients to Transfer Data to this Virtual Directory check box.
    Click OK
    Restart IIS

    Retry Download and check event log for errors.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now