SQLServer Installation Error for Cluster Environme

  • Hi there,

    I have been trying to install SQLServer onto a my cluster environment. I manage to install in MSCS. I basically run though the usual SQLServer set up options choosing Virtual Server.

    I realize that there is communication between the 2 nodes as in the primary is pushing files over to the secondary. Right when it says registering SQLServer for Cluster i get the following error in the Application Log file.

    Event Type:Error

    Event Source:ClusSvc

    Event Category:(2048)

    Event ID:1058

    Date:7/23/2002

    Time:4:34:43 PM

    User:N/A

    Computer:SAMNP009

    Description:

    The Cluster Resource Monitor could not load the DLL SQSRVRES.DLL for resource type SQL Server.

    Data:

    0000: 7e 00 00 00 ~...

    Event Type:Error

    Event Source:ClusSvc

    Event Category:(2048)

    Event ID:1058

    Date:7/23/2002

    Time:4:34:41 PM

    User:N/A

    Computer:SAMNP009

    Description:

    The Cluster Resource Monitor could not load the DLL SQAGTRES.DLL for resource type SQL Server Agent.

    Data:

    0000: 7e 00 00 00 ~...

    I have searched the MS Knowledge base and found the cause of it but still no soultion

    Event ID 1058

    Source:

    ClusSvc

    Description:

    The Cluster Resource Monitor could not load the DLL %1 for resource type %2.

    Problem:

    The Cluster Service tried to bring a resource online that requires a specific resource DLL for the resource type. The DLL is either missing, corrupt, or an incompatible version. As a result, the resource cannot be brought online.

    Solution:

    Check the cluster installation directory for the existence of the named resource DLL. Make sure the DLL exists in the proper directory on both nodes.

    anyone has encountered the same problem in the past?

    Thanks

    wsze

    Edited by - wsze on 07/23/2002 05:04:24 AM

  • You are sure the cluster is functional without installing sql enterprise on it first yes? The only thing close to this is the problem some of us had installing SP1 onto the cluster.

    Wes

  • I would think the cluster is running. I have tried moving the resources around in the Cluster Administrator.

    I have also tried shutting down one server and see the resource gets switched over to the secondary node.

    Is this verification enough to show the Cluster is functioning?

  • I manage to find a work around it. What I did was I copied this file manually onto the secondary node in the \system32 directory and everything seems to work fine.

    Funny but true. Seems like the installation did not transfer these 2 files into the secondary node?

    sze

  • That's pretty much what would happen when you installed SP1 a file wouldn't get copied to one of the nodes.

    Wes

  • Thanks for this info - I've just has a similar problem with an install of SP2 CU12 on a single-node cluster , copying back the SQAGTRES.DLL and SQSRVRES.DLL resolved that problem

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply