WSuS Deployment - SQL Error

Hi,

This is in connection with WSUS installation.

Server OS - win2k3 Ent + sp1
Sql - sqol 2000 + sp 4

Once the installation is over , the update is happening the event viewer throws the following error :
" Content 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/windows2000-kb922582-x86-enu_b184762ae6115013bd0e769309ea0b48d64de4df.exe Destination File: c:\WSUS\WsusContent\DF\B184762AE6115013BD0E769309EA0B48D64DE4DF.EXE.

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

I am using SonilWall Firewall and I dont have a option to enable the HTTP as mentione in Microsoft site. So tried the second option :-

Method 1: The proxy server does not support HTTP 1.1 range requests
Modify the proxy server settings to support HTTP 1.1 range requests. If you cannot modify the proxy server in this manner, configure BITS to work in foreground mode. To do this, follow these steps:1. Click Start, click Run, type the following command, and then click OK:
%programfiles%\Update Services\tools\osql\osql.exe -S %Computername%\WSUS -E -b -n -Q "USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1"
2. Restart the Update Services service. To do this, follow these steps:a. Click Start, click Run, type services.msc, and then click OK.
b. In the Services dialog box, right-click Update Services, and then click Restart.

Now it throws another SQL Error :
[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect())

Kindly let me know how to resolve this issue..I need WSUS to be installed in my NW

Looking forward for a speedy reply...

Thanks in advance

Nand



Answer this question

WSuS Deployment - SQL Error