Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Jeffrey Williams= Active/Active node question Expand / Collapse
Author
Message
Posted Tuesday, October 26, 2010 4:22 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
Please help= Do we need to install default instance on both the nodes? We have node a and node b. On prod we have both the instances installed on node a and node b. But the stage we have default instance on node a, but n ot node b. Do I have to install the default on node b as well? if I do then what will be the step by step process?

Any Sql guru can reply to this.. Thanks!
Post #1011190
Posted Tuesday, October 26, 2010 7:28 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:37 PM
Points: 4,389, Visits: 9,522
When you install SQL Server on a cluster, the installer will install the across all nodes. The instance will then be active on only one of those nodes. When that node is no longer available, the instance is failed over to one of the other nodes and becomes active on that node.

You don't manually install on each node - the installer will take care of that for you. Note: there are non-cluster aware components that you have to install on each node (SSIS, SSRS, Client Tools, etc...).

A cluster can only have one default instance - all the other instances will be named instances.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #1011231
Posted Wednesday, October 27, 2010 8:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
Thank you so much for your reply-
Post #1011570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse