Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: SQL Install into Cluster Fails

    I'm trying to install SQL into a new cluster. The cluster service is up and running fine. I can even fail it from Node 1 to Node 2 with no problem.

    However, when I try to install SQL, I get a screen that tells me that SQL is performing required operations on the cluster nodes...this may take a few minutes.

    After hanging on that message for a looong time, SQL comes up with a generic message that the install failed and that SQL is cleaning up. Then, nothing. No error message, nothing that I can track down.

    Some system information:
    Node 1. Dell PE2650, 2x 2.8 GHz, 2 GB RAM
    - Windows 2000 Advanced Server
    - Dell Perc3/DC RAID/SCSI Controller
    - Dell Perc3/DI Integrated RAID Controller

    Node 2. Dell PE2650, 2x 2.8 GHz, 2 GB RAM
    - Windows 2000 Advanced Server
    - Dell Perc3/DC RAID/SCSI Controller
    - Dell Perc3/DI Integrated RAID Controller

    Shared Storage. Dell PV220
    - Q: Quorum (1 GB)
    - S: Data (136 GB)
    - T: Logs (20 GB)


    Additional Notes:
    1. I am using a checklist from Dell and another from MS.
    2. I have also downloaded and read the checklist from sql-server-performance.com.
    3. I have ensured that the comclust.exe was run on both nodes prior to starting the SQL installation
    4. I am using SQL Enterprise Edition. We used the same CD to install a cluster server two weeks ago.

    Questions:
    1. Where can I find an installation error log that might point more specifically to where the problem might be?
    2. Any thoughts on what the problem might be?
    3. Anyone ever experience something similar?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    The logs are stored in C:\WINNT of the node where you ran the SETUP from. The name of the file is something like SQLSTP.LOG
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    http://support.microsoft.com/default...rs/70clstr.asp for information on SQL cluster (ver.7) step by step.

    http://www.sql-server-performance.co...stall_main.asp about SQL 2K clustering.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245

    Solved: Install MDAC 2.7 SP1

    Called MS. Sent them the error logs (there are two, both of them in the WINNT folder as pointed out by someone earlier). After a brief analysis, they told me to install MDAC 2.7 SP1 on one of the nodes.

    That solved it.

    Regards,

    hmscott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •