locked
SQL 2005 Cluster on Server 2008 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, hopefully somebody here can assist me...
    I am trying to setup a SQL 2005 cluster on a Server 2008 failover cluster.
    I configure the Windows cluster and there are no hassles.
    When I install the SQL cluster, the install detects that it is a cluster and installs SQL on both nodes, however SQL is not registered in the Failover Cluster Management MMC and I can therefore not manage the cluster or fail it over to the other node.
    (I can connect to the SQL server virtual instance through management studio)

    Any assistance would be appreciated.
    Thanks!

    Wednesday, January 11, 2012 1:04 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    from CMD prompt run - cluster res

    This should list out all the cluster resources (and their groups). Its possible that the SQL res got sent to 'available storage'.

    On win 2008 - You need to apply SP (3/4) to be fully functional.

    Thanks - Vijay Sirohi
    • Proposed as answer by PrinceLucifer Thursday, January 12, 2012 6:43 AM
    • Marked as answer by amber zhang Wednesday, January 18, 2012 7:18 AM
    Wednesday, January 11, 2012 2:47 PM
    Answerer
  • Question
    Sign in to vote
    1
    Sign in to vote

    Thanks for your reply, and you are quite correct.

    I found that this is a known issue of SQL 2K5 as reported in the following KB article: http://support.microsoft.com/kb/932897

    • Proposed as answer by PrinceLucifer Thursday, January 12, 2012 6:43 AM
    • Marked as answer by amber zhang Wednesday, January 18, 2012 7:18 AM
    Thursday, January 12, 2012 5:21 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    from CMD prompt run - cluster res

    This should list out all the cluster resources (and their groups). Its possible that the SQL res got sent to 'available storage'.

    On win 2008 - You need to apply SP (3/4) to be fully functional.

    Thanks - Vijay Sirohi
    • Proposed as answer by PrinceLucifer Thursday, January 12, 2012 6:43 AM
    • Marked as answer by amber zhang Wednesday, January 18, 2012 7:18 AM
    Wednesday, January 11, 2012 2:47 PM
    Answerer
  • Question
    Sign in to vote
    1
    Sign in to vote

    Thanks for your reply, and you are quite correct.

    I found that this is a known issue of SQL 2K5 as reported in the following KB article: http://support.microsoft.com/kb/932897

    • Proposed as answer by PrinceLucifer Thursday, January 12, 2012 6:43 AM
    • Marked as answer by amber zhang Wednesday, January 18, 2012 7:18 AM
    Thursday, January 12, 2012 5:21 AM