Post reply

SQL SERVER 2005 CLUSTERING

  • March 31, 2009 at 10:00 am

    #384259

    hello All

    Can anyone please tel me the exact procedure for installation of sql server 2005 ( fail over clustering ) . I am implementing clustering on 2 nodes ( between sql server 2005 ) . I have gone through the MSDN article for installation of sql servecr 2005 fail over clustering

    A) Please let me know wether i need to install sql server 2005 on the single node ( or on both the nodes ) . or wether installation on one node automatically configures second node also .

    I am using windows server 2003.

    Any help would be appreciated.

    Thanks

    Nikhil

  • March 31, 2009 at 10:07 am

    #969250

    This should help you get started

    http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en

  • March 31, 2009 at 11:50 am

    #969320

    Thanks for replying.. I have read this article. Actually its mentioned there in the article how to install sql server 2005 on fail over cluster. But i am confused at one point , wether it needs to be installed on both nodes or by installing it on one node will automatically configure the second one .

    Please advise

  • March 31, 2009 at 11:56 am

    #969327

    During the installation you will select "Create a SQL Server failover cluster" option below the "SQL Server Database Services" option (Page 40 of the document). This will install the database engine on the primary and the secondary nodes.

    You will need to install the client components and Integration Services on the secondary nodes separately along with the service packs.

    You need to make sure the OS is already clustered and MS-DTC is installed and configured.

  • March 31, 2009 at 12:45 pm

    #969356

    I just need to correlate few of things that are constantly irritating me . need to understand the flow exactly regarding what you said .

    Installing database services on both would be done by same wizard only and after that just client compoents needs to installed onto second. cant client also be isntalled from the same wizard ( refer to page 36 of this doc )

    Thanks

  • March 31, 2009 at 1:06 pm

    #969375

    The workstation components, books online and development tools option selected during the installation is will install these on the primary node only. You will need to install these separately on the secondary node post the database engine install.

  • March 31, 2009 at 6:12 pm

    #969568

    If you are going with active/active cluster then need to run setup on both the nodes individually.

    If active/passive then need to run setup on primary node only. Rest about client tools other poster has already posted.

    http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

    MJ

  • April 2, 2009 at 5:44 am

    #970552

    Thanks a lot for the help . Can you please provide with some useful links where i can get some info to configure clustering ( both active/active and active/passive) on windows level.

    Thanks

    Nikhil

Viewing 8 posts - 1 through 7 (of 7 total)

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