Failover fails after applying MS03-031 patch

From: Cédric (cedric.weider_at_helvetiapatria.ch)
Date: 08/21/04

  • Next message: Mike Cooper: "Question on setting up failover" 
    Date: 21 Aug 2004 02:53:25 -0700

    Hello !

    I have installed an active/passive MSSQL 2000 Cluster on W2K3 EE and
    applied successfully SP3a to both nodes (Failover to second node still
    works at this time !)

    Before going to test phase, I would like to patch the SQL Server with
    Ms03-031 cummulative patch.
    Wenn applying the patch from active node (NodeA), it says it has
    successfully installed and after verifying the file version for
    SQLSERVR.EXE it is really 2000.80.818.00 on both NodeA and NodeB (That
    should mean that patch IS correctly installed).

    But when I initiate a "move group" in Cluster Admin, the SQL Server
    resource hangs on "Online Pending" to NodeB for a few minutes (SQL
    Service Manager hangs on "Starting...") and then switches back
    automatically to NodeA.

    In Event Log I when obtain the following errors:

    ------------------------------------------------------------
    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (3)
    Event ID: 17052
    Date: 21.08.2004
    Time: 01:28:38
    User: N/A
    Computer: HPV-BSHS-S94
    Description:
    [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status
    5b4)
    ------------------------------------------------------------

    and

    ------------------------------------------------------------
    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (3)
    Event ID: 17052
    Date: 21.08.2004
    Time: 01:28:38
    User: N/A
    Computer:
    Description:
    [sqsrvres] OnlineThread: Error 5b4 bringing resource online.
    ------------------------------------------------------------

    NET MSGHELP 1460 answers: "This operation returned because the timeout
    period expired."

    I'm now searching for two days and have tried many things, inclusive
    backup/restore, manual uninstall of sql and finally image restore to
    have the status from before patching, but nobody could tell me what
    can be the issue...

    Hope you can help me!

    Thanks.
    Cédric

  • Next message: Mike Cooper: "Question on setting up failover"

    Relevant Pages

    • Re: MicroMonopoly aids Terrorism?
      ... >> Not if the patch makes it so you can't use SQL server. ... >> the multitudes of MS patches that get released. ... > No one is disputing that MS was hit by Slammer. ...
      (microsoft.public.security)
    • Critical Alert Update - W32.Slammer
      ... It's not clear if SQL Server 2000 SP1/SP2 includes the ... Microsoft SQL Desktop ... and all applications that install ... >most recent cumulative SQL Server security patch, ...
      (microsoft.public.security)
    • RE: cluster resource in resource group failed
      ... Keywords: Classic,Audit Failure ... SQL Server is terminating in response to a 'stop' request from Service ... OnlineThread: ...
      (microsoft.public.sqlserver.clustering)
    • Re: SQL 2000 on Windows 2003 cluster - URGENT HELP
      ... The log files are plain-text human readable. ... >> Microsoft SQL Server MVP ... >>> do not come online even though I can see them in clusteradmin from ... >>> I feel would come online once SQL server resource comes online. ...
      (microsoft.public.sqlserver.clustering)
    • [NEWS] Cumulative Patch for Microsoft SQL Server
      ... to promote the most advanced vulnerability assessment solutions today. ... This cumulative patch includes the functionality of all previously ... released patches for SQL Server 7.0, SQL Server 2000, MSDE 1.0, and MSDE ... * Named Pipe Hijacking ...
      (Securiteam)