Re: SP3a does not work on a cluster

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 07/13/04

  • Next message: Dan Malkin: "Quorum resource on shared array" 
    Date: Tue, 13 Jul 2004 03:16:04 GMT

    Thanks for giving us more information to help you.

    You may be hitting the issue documented in

    PRB: Error Message: "The handle is invalid" Occurs When You Install SQL Server 2000 Service Pack 2 on Virtual SQL Server
    http://support.microsoft.com/?kbid=811882

    I know that you are installing SP3a and the above article is for SP2. The article still will apply for SP3/SP3a.

    As per the above KB,

    CAUSE
    After you type the virtual server name in the text box of the SQL Server Service Pack 2 installation wizard, and then click Next, the setup program checks for the validity of the virtual server name by checking the
    resource type for SQL Server, depending on the Network Name ( SQL Network Name) resource. If the setup program does not find the SQL Server resource as the first resource that depends on the SQL Network
    Name resource, the setup may fail.

    RESOLUTION
    To resolve the problem, use these steps:

    Use the Cluster Administrator utility to switch all the SQL Server cluster group resources offline.
    Check the dependencies of each resource in the SQL Server cluster group. If a resource that has SQL Network Name is listed as one of the dependencies, remove SQL Network Name from the dependencies list.
    For any other resource, such as an MSDTC resource that requires a Network Name resource as one of it dependencies, use these steps to remove the dependency:
    Create a new Network Name resource and name it Temp. Make it dependent on the SQL IP address resource. Leave the Temp resource in offline state.
    Use the Cluster Administrator to modify the dependencies of other resources from the SQL Network Name resource to the Temp Network Name resource.
    For the SQL Server resource, add the SQL Network Name resource to the dependencies list of the SQL Server resource. Verify that the SQL Server resource is the first clustered resource that has a dependency on
    the SQL Network Name resource.
    For other resources that depend on the SQL Network Name resource, remove the Temp Network Name resource and add SQL Network Name to the dependency list.
    Bring all the SQL Server cluster group resources back online.
    Run the setup again

    Let us know if this works.

    If it doesn't work, then I would like to know the following:
    1) Groups that you have
    2) Resources in each group --- their types and their dependencies.

    Best Regards,

    Uttam Parui
    Microsoft Corporation

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

    Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

    Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
    http://www.microsoft.com/protect
    http://www.microsoft.com/security/guidance/default.mspx

  • Next message: Dan Malkin: "Quorum resource on shared array"

    Relevant Pages

    • Re: MSSQL2K and MSSQL side by side in clustered environment
      ... You need to start out with a disk resource in its own resource group. ... Network Name and IP address resource for the clustered SQL instance are ... It appears that the installer sees a complete ... > (is this what you referring to as SQL Server Virtual?). ...
      (microsoft.public.sqlserver.clustering)
    • Re: Help... disk wont come online after it is offlined
      ... Do you know any way to do dependency across resource groups? ... the resources in the primary group where SQL Service and other drives are? ... Microsoft SQL Server MVP ...
      (microsoft.public.sqlserver.clustering)
    • Re: Trying to Move Group - SQL Instance Wont Start
      ... the "allowed nodes" list for that instance and did not run the installer to ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... but the SQL Server resource still fails to start. ...
      (microsoft.public.sqlserver.clustering)
    • Re: Trying to Move Group - SQL Instance Wont Start
      ... Did you follow the instructions in "Maintaining a Failover Cluster" in BOL on recovering from a cluster node failure? ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... but the SQL Server resource still fails to start. ...
      (microsoft.public.sqlserver.clustering)
    • RE: Fulltext failure on a 2 node cluster
      ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
      (microsoft.public.sqlserver.clustering)