How to install SQL Server 2005 on the 2nd node of a cluster?

  • when installing SQL Server 2005 on a two node cluster are the binaries installed on both nodes during the installation on the first node or does it have to be done on both?

    thanks,

    Les

  • I've been wondering exactly what steps you take once you get the second cluster node up myself.

    Do you install on the second (new) node and select the failover option?

  • binaries will be on both nodes data files and log files will be on the shared drive


    Kindest Regards,

    Vasc

  • The basic sql 2005 binaries are installed on both nodes however some optional/additional software may only be installed on the node that you're running the installer from and you would have to manually install on the second node if you wanted to use it. I think mgmt tools is one

  • - your sqlserver instance will be able to run on both nodes.

    - You'll have to perform an extra install if you also want to have SqlServer Management Studio available at the second node.

    - Integrationserver needs an extra install at the second node as this is not cluster aware by default.

    The procedure of adding it in clustermanager (and moving and altering the correct config xml file) is described in a technet art. ( http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx )

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

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

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