October 26, 2010 at 4:22 pm
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!
October 26, 2010 at 7:28 pm
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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 27, 2010 at 8:13 am
Thank you so much for your reply-
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply