Re: WSUS Problem - Help Needed

Hi Siv,

In order to sharing our experience with the other users and help them to
search/find specific answers more efficiently in the future, I would like
to make a summary here:

Problem description:
=====================
You met the following error when using WSUS 3.0 SP1 Server Clean Up Wizard:


The WSUS administration console was unable to connect to the WSUS Server
Database.

Verify that SQL server is running on the WSUS Server. If the problem
persists, try restarting SQL.

System.Data.SqlClient.SqlException -- Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
The statement has been terminated.

Source
Net SqlClient Data Provider

Stack Trace:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate
method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.Control.Invoke(Delegate method)
at
Microsoft.UpdateServices.UI.SnapIn.Wizards.ServerCleanup.ServerCleanupWizard
OnCleanupComplete(Object sender, PerformCleanupCompletedEventArgs e)


Cause: SQL service is not running correctly

Resolution: Restart SQL server.

Thanks again for your time and cooperation.

Have a nice day :-)


Best regards,

Gary Wang(MSFT)
Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| X-Tomcat-ID: 92641881
| References: <3772903D-01FC-4917-805B-D5B50982A845@xxxxxxxxxxxxx>
<4F84C1E5-0579-4531-832D-4A1F1C5FEBF8@xxxxxxxxxxxxx>
<8JuOVWf0IHA.5796@xxxxxxxxxxxxxxxxxxxxxx>
<77250DA6-1165-4014-905B-E3C07909B3B5@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-gzwang@xxxxxxxxxxxxxxxxxxxx (Guozhen Wang[MSFT])
| Organization: Microsoft
| Date: Fri, 20 Jun 2008 11:03:42 GMT
| Subject: Re: WSUS Problem - Help Needed
| X-Tomcat-NG: microsoft.public.windows.server.sbs
| Message-ID: <RYaISVs0IHA.1784@xxxxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| Lines: 274
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:112490
| NNTP-Posting-Host: TOMCATIMPORT3 10.201.220.210
|
| Hello Siv,
|
| Thanks for your update and sharing experience.
|
| I am very happy to know that you had resolved this issue by yourself.
|
| Hav a nice day :-)
|
| Best regards,
|
| Gary Wang(MSFT)
| Microsoft CSS Online Newsgroup Support
|
| Get Secure! - www.microsoft.com/security
|
| =====================================================
| This newsgroup only focuses on SBS technical issues. If you have issues
| regarding other Microsoft products, you'd better post in the
corresponding
| newsgroups so that they can be resolved in an efficient and timely
manner.
| You can locate the newsgroup here:
| http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
|
| When opening a new thread via the web interface, we recommend you check
the
| "Notify me of replies" box to receive e-mail notifications when there are
| any updates in your thread. When responding to posts via your newsreader,
| please "Reply to Group" so that others may learn and benefit from your
| issue.
|
| Microsoft engineers can only focus on one issue per thread. Although we
| provide other information for your reference, we recommend you post
| different incidents in different threads to keep the thread clean. In
doing
| so, it will ensure your issues are resolved in a timely manner.
|
| For urgent issues, you may want to contact Microsoft CSS directly. Please
| check http://support.microsoft.com for regional support phone numbers.
|
| Any input or comments in this thread are highly appreciated.
| =====================================================
|
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --------------------
| | From: "Siv" <g@xxxxxxxxxxxxxxxxxxxxxxxx>
| | References: <3772903D-01FC-4917-805B-D5B50982A845@xxxxxxxxxxxxx>
| <4F84C1E5-0579-4531-832D-4A1F1C5FEBF8@xxxxxxxxxxxxx>
| <8JuOVWf0IHA.5796@xxxxxxxxxxxxxxxxxxxxxx>
| | In-Reply-To: <8JuOVWf0IHA.5796@xxxxxxxxxxxxxxxxxxxxxx>
| | Subject: Re: WSUS Problem - Help Needed
| | Date: Fri, 20 Jun 2008 10:40:36 +0100
| | Lines: 207
| | Message-ID: <77250DA6-1165-4014-905B-E3C07909B3B5@xxxxxxxxxxxxx>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | format=flowed;
| | charset="iso-8859-1";
| | reply-type=original
| | Content-Transfer-Encoding: 7bit
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
| | X-MS-CommunityGroup-PostID: {77250DA6-1165-4014-905B-E3C07909B3B5}
| | X-MS-CommunityGroup-ThreadID: 63DA7A59-A9D1-4751-99C5-0FA4255A8A59
| | X-MS-CommunityGroup-ParentID: CABBEA57-1A08-4063-9317-11BF580EC74C
| | Newsgroups: microsoft.public.windows.server.sbs
| | Path: TK2MSFTNGHUB02.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:112475
| | NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
| | X-Tomcat-NG: microsoft.public.windows.server.sbs
| |
| | Guozhen,
| |
| | I restarted the SQL Server services and then retried, this cleared the
| issue
| | as the "Server Cleanup Wizard" now completes successfully without
hitting
| an
| | error quite early on in the cleanup process. I have now recovered over
| 32GB
| | of space from my Server's C: Drive.
| |
| | Thanks for your help.
| |
| | Siv
| |
| | "Guozhen Wang[MSFT]" <v-gzwang@xxxxxxxxxxxxxxxxxxxx> wrote in message
| | news:8JuOVWf0IHA.5796@xxxxxxxxxxxxxxxxxxxxxxxxx
| | > Hello Siv,
| | >
| | > Thank you for your post.
| | > My name is Gary Wang, and it is my pleasure to work with you on this
| | > issue!
| | > Please allow me to confirm that my understandings are correct. As I
| | > understand it, the issue is:
| | >
| | > You met the following error when using WSUS 3.0 SP1 Server Clean Up
| | > Wizard:
| | >
| | >
| | > The WSUS administration console was unable to connect to the WSUS
Server
| | > Database.
| | >
| | > Verify that SQL server is running on the WSUS Server. If the problem
| | > persists, try restarting SQL.
| | >
| | > System.Data.SqlClient.SqlException -- Timeout expired. The timeout
| period
| | > elapsed prior to completion of the operation or the server is not
| | > responding.
| | > The statement has been terminated.
| | >
| | > Source
| | > Net SqlClient Data Provider
| | >
| | > Stack Trace:
| | > at System.Windows.Forms.Control.MarshaledInvoke(Control caller,
| Delegate
| | > method, Object[] args, Boolean synchronous)
| | > at System.Windows.Forms.Control.Invoke(Delegate method, Object[]
args)
| | > at System.Windows.Forms.Control.Invoke(Delegate method)
| | > at
| | >
|
Microsoft.UpdateServices.UI.SnapIn.Wizards.ServerCleanup.ServerCleanupWizard
| | > OnCleanupComplete(Object sender, PerformCleanupCompletedEventArgs e)
| | >
| | > If I have misunderstood your concerns please feel free to let me know.
| | >
| | > This issue seems a little complex, it may cost time for troubleshoot.
| And
| | > we may need more information for further investigation.
| | >
| | > To narrow down the root cause more effectively, please tell us which
| task
| | > are you running in the Cleanup Wizard that times out?
| | >
| | > Also please help to collect the following infromation:
| | >
| | > 1. Please help to take a screenshot of exact symptom when the error
| | > occurs.Save it to *.JPG and send to me.
| | > 2. Gather MPS WSUS report on SBS. Please check below steps:
| | >
| | > a. Download MPSrepot_SUS from
| | >
|
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
| | > 15706/MPSRPT_SUS.EXE
| | >
| | > b. Run MPSRPT_SUS.exe.
| | >
| | > c. The tool will automatically collect the information. This
procedure
| | > will
| | > take 10~15 minutes.
| | >
| | > d. Open Windows Explorer, navigate to the folder:
| | > %SystemRoot%\MPSReports\MSUS\Bin\Reports\Cab
| | >
| | > e. Send the .cab file directly to me.
| | >
| | > My email address is v-gzwang@xxxxxxxxxxxxx
| | >
| | > I look forward to your reply. Also, if you have any questions or
| concerns,
| | > please do not hesitate to let me know. I am happy to help. :-)
| | >
| | > Thank you for your time and cooperation!
| | >
| | > Best regards,
| | >
| | > Gary Wang(MSFT)
| | > Microsoft CSS Online Newsgroup Support
| | >
| | > Get Secure! - www.microsoft.com/security
| | >
| | > =====================================================
| | > This newsgroup only focuses on SBS technical issues. If you have
issues
| | > regarding other Microsoft products, you'd better post in the
| corresponding
| | > newsgroups so that they can be resolved in an efficient and timely
| manner.
| | > You can locate the newsgroup here:
| | > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
| | >
| | > When opening a new thread via the web interface, we recommend you
check
| | > the
| | > "Notify me of replies" box to receive e-mail notifications when there
| are
| | > any updates in your thread. When responding to posts via your
| newsreader,
| | > please "Reply to Group" so that others may learn and benefit from your
| | > issue.
| | >
| | > Microsoft engineers can only focus on one issue per thread. Although
we
| | > provide other information for your reference, we recommend you post
| | > different incidents in different threads to keep the thread clean. In
| | > doing
| | > so, it will ensure your issues are resolved in a timely manner.
| | >
| | > For urgent issues, you may want to contact Microsoft CSS directly.
| Please
| | > check http://support.microsoft.com for regional support phone numbers.
| | >
| | > Any input or comments in this thread are highly appreciated.
| | > =====================================================
| | >
| | > This posting is provided "AS IS" with no warranties, and confers no
| | > rights.
| | >
| | > --------------------
| | > | Thread-Topic: WSUS Problem - Help Needed
| | > | thread-index: AcjRZ/VwYES4+u7JQuCYn4+SDpT/2g==
| | > | X-WBNR-Posting-Host: 207.46.193.207
| | > | From: =?Utf-8?B?VHJhdmlzIFBsdW5rIFtNU0ZUXQ==?=
| | > <TravisPlunkMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx>
| | > | References: <3772903D-01FC-4917-805B-D5B50982A845@xxxxxxxxxxxxx>
| | > | Subject: RE: WSUS Problem - Help Needed
| | > | Date: Wed, 18 Jun 2008 10:23:00 -0700
| | > | Lines: 47
| | > | Message-ID: <4F84C1E5-0579-4531-832D-4A1F1C5FEBF8@xxxxxxxxxxxxx>
| | > | MIME-Version: 1.0
| | > | Content-Type: text/plain;
| | > | charset="Utf-8"
| | > | Content-Transfer-Encoding: 7bit
| | > | X-Newsreader: Microsoft CDO for Windows 2000
| | > | Content-Class: urn:content-classes:message
| | > | Importance: normal
| | > | Priority: normal
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
| | > | Newsgroups: microsoft.public.windows.server.sbs
| | > | Path: TK2MSFTNGHUB02.phx.gbl
| | > | Xref: TK2MSFTNGHUB02.phx.gbl
| microsoft.public.windows.server.sbs:112158
| | > | NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| | > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| | > |
| | > | On the home page of the WSUS server console, how many computers
does
| it
| | > show
| | > | as not having reported status for more than 30 days?
| | > |
| | > | "Siv" wrote:
| | > |
| | > | > Hi,
| | > | > I am running Small Business Server 2003 and WSUS 3.0 SP1. I
| initially
| | > set
| | > | > the WSUS to download everything and it has been running fine.
What
| I
| | > hadn't
| | > | > allowed for was the mass of updates that were stored locally and
how
| | > much of
| | > | > my server's C: drive would be consumed by it.
| | > | >
| | > | > I have modified the settings so that only a subset of the
available
| MS
| | > | > products are included and I was trying to then run the "Server
| Cleanup
| | > | > Wizard" this however keeps failing with the following error:
| | > | >
| | > | >
| ======================================================================
| | > | > The WSUS administration console was unable to connect to the WSUS
| | > Server
| | > | > Database.
| | > | >
| | > | > Verify that SQL server is running on the WSUS Server. If the
problem
| | > | > persists, try restarting SQL.
| | > | >
| | > | >
| | > | > System.Data.SqlClient.SqlException -- Timeout expired. The
timeout
| | > period
| | > | > elapsed prior to completion of the operation or the server is not
| | > | > responding.
| | > | > The statement has been terminated.
| | > | >
| | > | > Source
| | > | > ..Net SqlClient Data Provider
| | > | >
| | > | > Stack Trace:
| | > | > at System.Windows.Forms.Control.MarshaledInvoke(Control caller,
| | > Delegate
| | > | > method, Object[] args, Boolean synchronous)
| | > | > at System.Windows.Forms.Control.Invoke(Delegate method,
Object[]
| | > args)
| | > | > at System.Windows.Forms.Control.Invoke(Delegate method)
| | > | > at
| | > | >
| | >
|
Microsoft.UpdateServices.UI.SnapIn.Wizards.ServerCleanup.ServerCleanupWizard
| | > OnCleanupComplete(Object
| | > | > sender, PerformCleanupCompletedEventArgs e)
| | > | >
| | > | >
| ======================================================================
| | > | > Does anyone know how I can extend the timeout period so that the
| job
| | > can
| | > | > complete?
| | > | >
| | > | > Siv
| | > | >
| | > | >
| | > |
| | >
| |
| |
|
|

.