<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://msmvps.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx</link><description>Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. System.Data.SqlClient.SqlException: Timeout expired.</description><dc:language>en</dc:language><generator>CommunityServer 2008.5 SP2 (Build: 40407.4157)</generator><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#281770</link><pubDate>Mon, 13 Nov 2006 10:26:52 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:281770</guid><dc:creator>ronald</dc:creator><description>&lt;p&gt;thanks! really speeds things up!&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=281770" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#186509</link><pubDate>Thu, 19 Oct 2006 00:54:29 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:186509</guid><dc:creator>Colin Bell</dc:creator><description>&lt;p&gt;Fixed all my timeout errors when changing/setting approvals on multiple updates and the slow access to the admin config pages.&lt;/p&gt;
&lt;p&gt;So what does this SQL script actually do??&lt;/p&gt;
&lt;p&gt;-----&lt;/p&gt;
&lt;p&gt;Main Upstream Server: (3200+ users)&lt;/p&gt;
&lt;p&gt;Win2003 STD SP1 / IIS 6.0&lt;/p&gt;
&lt;p&gt;Secondary Downstream Server: (300+ users)&lt;/p&gt;
&lt;p&gt;Win2000 STD SP4 / IIS 5.0&lt;/p&gt;
&lt;p&gt;SQL Server:&lt;/p&gt;
&lt;p&gt;Win2003 ENT SP1 / SQL 2000 SP4&lt;/p&gt;
&lt;p&gt;3500+ Workstations total&lt;/p&gt;
&lt;p&gt;-----&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=186509" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#105856</link><pubDate>Wed, 26 Jul 2006 18:07:32 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:105856</guid><dc:creator>Vicky</dc:creator><description>This did not work for me, but the problem I am having which relates to the timeout message that I get is when trying to delete a computer group from the WSUS console. &amp;nbsp;I have only one WSUS server so it is not a replica server. &amp;nbsp;Any ideas?&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=105856" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#101153</link><pubDate>Wed, 14 Jun 2006 13:42:48 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:101153</guid><dc:creator>Chris</dc:creator><description>WOW! What a huge difference this makes. &amp;nbsp;I just approved 43 updates in under a minute, where it would take ages before. &amp;nbsp;:)&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=101153" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#100718</link><pubDate>Sun, 11 Jun 2006 18:42:42 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:100718</guid><dc:creator>Thomas</dc:creator><description>Works fine. This really speed up the approvement.&lt;br&gt;Thanks&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=100718" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#99561</link><pubDate>Tue, 06 Jun 2006 08:36:55 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:99561</guid><dc:creator>Bjørnar</dc:creator><description>Yay! Really speedup in WSUS! Thank you! :D&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=99561" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#97107</link><pubDate>Fri, 26 May 2006 09:35:50 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:97107</guid><dc:creator>Anders</dc:creator><description>Success!!
&lt;br&gt;Turned my WSUS server from a turtle to a rabbit :-)) and fixed problems with some sticky updates that were recomended to deny.
&lt;br&gt;
&lt;br&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=97107" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#95683</link><pubDate>Thu, 18 May 2006 07:48:26 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:95683</guid><dc:creator>Nico Kretschmar</dc:creator><description>Thanks, its solved my big problem with wsus after my new installation of our windows 2003 server. Its make my life easier... approved new updates faster.
&lt;br&gt;
&lt;br&gt;very well, also many thanks.&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=95683" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#93628</link><pubDate>Fri, 05 May 2006 17:03:29 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:93628</guid><dc:creator>Alain Vouillon</dc:creator><description>Hello,
&lt;br&gt;
&lt;br&gt;the script can't find my WSUS server.
&lt;br&gt;What is the correct value for:
&lt;br&gt;
&lt;br&gt;HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup\SqlServerName 
&lt;br&gt;
&lt;br&gt;You can replace the value of this key for the place holder in the command below ???
&lt;br&gt;I have: %COMPUTERNAME%\WSUS .
&lt;br&gt;
&lt;br&gt;Thank's for your help.
&lt;br&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=93628" width="1" height="1"&gt;</description></item><item><title>WSUS Update werden nur sehr langsam genehmigt</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#92908</link><pubDate>Sat, 29 Apr 2006 10:33:56 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:92908</guid><dc:creator>Olli's SBS Blog</dc:creator><description>Oliver Sommer2006-04-27&lt;br&gt;Der WSUS 2.0 oder auch WSUS 2 hat ein gro&amp;amp;#223;es Problem: Das &amp;amp;quot;Aproven&amp;amp;quot; (deutsch....&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=92908" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#79889</link><pubDate>Wed, 28 Dec 2005 17:56:17 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:79889</guid><dc:creator>Joshua Levitsky</dc:creator><description>Thank You!!! This made everything sooo much better.
&lt;br&gt;
&lt;br&gt;-Josh&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=79889" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#79572</link><pubDate>Wed, 21 Dec 2005 12:32:02 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:79572</guid><dc:creator>Jon Gerdes</dc:creator><description>Works very well for me:
&lt;br&gt;
&lt;br&gt;WSUS on W2K with MSSQL 2000 SP4.  3500 clients.  Server hardware is an old test system for now - this has extended its lifespan to complete the test P)&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=79572" width="1" height="1"&gt;</description></item><item><title>re: Timeout Approving Updates in WSUS/ Approving updates takes long time in WSUS</title><link>http://msmvps.com/blogs/athif/archive/2005/11/21/76101.aspx#78553</link><pubDate>Fri, 09 Dec 2005 21:18:00 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:78553</guid><dc:creator>Mohammed Athif Khaleel</dc:creator><description>Hi,&lt;br&gt;&lt;br&gt;This worked for me. What exactly does the SQL script do? If you don't mind explaining it to a newbie in this arena...&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=78553" width="1" height="1"&gt;</description></item></channel></rss>