SQL Server Performance

A/P Tools on 2nd node?

Discussion in 'SQL Server 2005 Clustering' started by acki4711, Oct 3, 2006.

  1. acki4711 Member

    Hi all,
    I just installed a 2 node A/P sql 2005 cluster. All seems all right, failover works.
    The only thing that's a bit strange to me, on 2nd node there are no sql tools (sql management studio, performance tools etc.) installed??
    Is this the normal behaviour our has there somthing went wrong?
    (Logfiles do not show any error but there is even no ...2nd_node_Tools.log file?)

    Thanks for a hint.
  2. bradmcgehee New Member

    The client tools are only installed on one node. You can install then on the second node manually, if you like.

    Brad M. McGehee, SQL Server MVP
  3. satya Moderator

    When you perform a failover the accessibility is taken care irrespective of installation of these tools, so IMHO need not worry in this regard.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page