Bits and foreground setting Jules 5/16/2007 11:49:01 AM Can anybody tell me how to perform the following command on a wsus 3.0 server. osql -S %computername%\wsus -E -b -n Q "USE SUSDB update tbConfigurationC set BitsDownloadPriorityForeground=1" I have been being tryiing to get bits to run the foreground. Everyone gives me links to bits info but nobody seems to be able to tell me how to make bits run in the foreground - the command above worked with wsus 2.0. Thanx Jules

Re: Bits and foreground setting "Winfried Sonntag [MVP]" <Winfried.Sonntag[ at ]gmx.de> 5/16/2007 1:54:47 PM Jules schrieb: [Quoted Text] > Can anybody tell me how to perform the following command on a wsus 3.0 server. > osql -S %computername%\wsus -E -b -n Q "USE SUSDB update tbConfigurationC > set BitsDownloadPriorityForeground=1" > I have been being tryiing to get bits to run the foreground. Everyone gives > me links to bits info but nobody seems to be able to tell me how to make bits > run in the foreground - the command above worked with wsus 2.0. Try: WsusDebugTool.exe /Tool:SetForegroundDownload Restart Services. Winfried -- http://www.microsoft.com/germany/windowsserver2003/technologien/updateservices/default.mspx http://www.wsuswiki.com/Home

Re: Bits and foreground setting Jules 5/17/2007 2:37:00 AM Winfried, Sounds like the tool I need. But I can't actually find it on the website! I can find references to it not actual file. Do you have a URL for the file. Thanx Jules "Winfried Sonntag [MVP]" wrote: [Quoted Text] > Jules schrieb: > > > Can anybody tell me how to perform the following command on a wsus 3.0 server. > > osql -S %computername%\wsus -E -b -n Q "USE SUSDB update tbConfigurationC > > set BitsDownloadPriorityForeground=1" > > I have been being tryiing to get bits to run the foreground. Everyone gives > > me links to bits info but nobody seems to be able to tell me how to make bits > > run in the foreground - the command above worked with wsus 2.0. > > Try: WsusDebugTool.exe /Tool:SetForegroundDownload > Restart Services. > > Winfried > -- > http://www.microsoft.com/germany/windowsserver2003/technologien/updateservices/default.mspx > http://www.wsuswiki.com/Home >

Re: Bits and foreground setting "Winfried Sonntag [MVP]" <Winfried.Sonntag[ at ]gmx.de> 5/17/2007 10:42:00 AM Jules schrieb: [Quoted Text] > Winfried, Sounds like the tool I need. But I can't actually find it on the > website! I can find references to it not actual file. Do you have a URL for > the file. http://download.microsoft.com/download/5/d/c/5dc98401-bb01-44e7-8533-3e79ae0e0f97/Update%20Services%203.0%20API%20Samples%20and%20Tools.EXE Winfried -- http://www.microsoft.com/germany/windowsserver2003/technologien/updateservices/default.mspx http://www.wsuswiki.com/Home

Re: Bits and foreground setting Jules 5/18/2007 2:40:00 AM Winfried, After a lot of search in google not microsoft I found the tool. Ran it and it has solved the problem Thanx Jules "Winfried Sonntag [MVP]" wrote: [Quoted Text] > Jules schrieb: > > > > Winfried, Sounds like the tool I need. But I can't actually find it on the > > website! I can find references to it not actual file. Do you have a URL for > > the file. > > http://download.microsoft.com/download/5/d/c/5dc98401-bb01-44e7-8533-3e79ae0e0f97/Update%20Services%203.0%20API%20Samples%20and%20Tools.EXE > > Winfried > -- > http://www.microsoft.com/germany/windowsserver2003/technologien/updateservices/default.mspx > http://www.wsuswiki.com/Home >

Re: Bits and foreground setting "Winfried Sonntag [MVP]" <Winfried.Sonntag[ at ]gmx.de> 5/18/2007 4:42:19 PM Jules schrieb: [Quoted Text] > After a lot of search in google not microsoft I found the tool. Ran it and > it has solved the problem > Thanx Thanks for response. ;) Winfried -- http://www.microsoft.com/germany/windowsserver2003/technologien/updateservices/default.mspx http://www.wsuswiki.com/Home

Re: Bits and foreground setting "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 5/21/2007 12:26:07 AM "Jules" <Jules[ at ]discussions.microsoft.com> wrote in message news:B9B4C229-94B5-4155-B728-3B8F031E9DF7[ at ]microsoft.com... [Quoted Text] > Can anybody tell me how to perform the following command on a wsus 3.0 > server. > osql -S %computername%\wsus -E -b -n Q "USE SUSDB update tbConfigurationC > set BitsDownloadPriorityForeground=1" To answer the *original* question, for the sake of the archives... You cannot run an osql.exe command on WSUS 3.0, because WSUS 3.0 installs a version of SQL Server 2005 which no longer uses the osq.exe utility. Futhermore, whether or not the tbConfigurationC table and/or the BitsDownloadPriorityForeground columns even continue to exist in WSUS 3.0 is a matter for speculation (or advanced SQL 2005 DBAs who can determine that fact). The command above was published to address a very specific issue affecting firewalls that were not HTTP v1.1 compliant. The preferred resolution here would be to address the issue of non-compliance with published HTTP protocols, rather than impeding the designed functionality of WSUS by placing BITS in foreground mode. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....

Re: Bits and foreground setting Jules 5/22/2007 7:42:00 AM Lawrence, The Astaro firewall doesn't seem to like passing http 1.1 information. I realise that putting bits into foreground does disable the background feature but since the updates are being downloaded overnight when the link is not being used. Jules "Lawrence Garvin (MVP)" wrote: [Quoted Text] > "Jules" <Jules[ at ]discussions.microsoft.com> wrote in message > news:B9B4C229-94B5-4155-B728-3B8F031E9DF7[ at ]microsoft.com... > > Can anybody tell me how to perform the following command on a wsus 3.0 > > server. > > osql -S %computername%\wsus -E -b -n Q "USE SUSDB update tbConfigurationC > > set BitsDownloadPriorityForeground=1" > > To answer the *original* question, for the sake of the archives... > > You cannot run an osql.exe command on WSUS 3.0, because WSUS 3.0 installs a > version of SQL Server 2005 which no longer uses the osq.exe utility. > Futhermore, whether or not the tbConfigurationC table and/or the > BitsDownloadPriorityForeground columns even continue to exist in WSUS 3.0 is > a matter for speculation (or advanced SQL 2005 DBAs who can determine that > fact). > > The command above was published to address a very specific issue affecting > firewalls that were not HTTP v1.1 compliant. The preferred resolution here > would be to address the issue of non-compliance with published HTTP > protocols, rather than impeding the designed functionality of WSUS by > placing BITS in foreground mode. > > -- > Lawrence Garvin, M.S., MCTS, MCP > Independent WSUS Evangelist > MVP-Software Distribution (2005-2007) > https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E > > Everything you need for WSUS is at > http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx > > And, almost everything else is at > http://wsusinfo.onsitechsolutions.com > ..... > > >

Re: Bits and foreground setting "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 5/22/2007 10:19:22 PM "Jules" <Jules[ at ]discussions.microsoft.com> wrote in message news:082AAA6F-AFD8-4766-A9ED-F986EB279701[ at ]microsoft.com... [Quoted Text] > Lawrence, > The Astaro firewall doesn't seem to like passing http 1.1 information. I > realise that putting > bits into foreground does disable the background feature but since the > updates are being downloaded overnight when the link is not being used. Ya gotta do whatcha gotta do. :-) Thank you for the information on the Astaro, though. I'll add that to my 'specific products' notes on this issue. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....