SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Need to Install 2nd Instance of SQL Server 2005 on a clustered server


Need to Install 2nd Instance of SQL Server 2005 on a clustered server

Author
Message
Patti Johnson
Patti Johnson
SSC Eights!
SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)

Group: General Forum Members
Points: 953 Visits: 950
I have a clustered server active/passive with sql 2005 installed. I have an ip address for node1 and an ip addressed for node2. I have the cluster ip address and I have the sql cluster ip. There is already a clustered instance on the server. I would like to install another clustered instance. Does each clustered instance have to have their own separate sql and cluster ip address before I can install the second instance or can I use the same ip addresses defined for the 1st instance? Do I install the 2nd instance from in the installation cd or can I click add/remove programs and find the sql install and install a new instance from there. SP2 has already been installed on the first instance. I am trying to figure out how to avoid getting the version change msg when I install from the CD.
Patti Johnson
Patti Johnson
SSC Eights!
SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)

Group: General Forum Members
Points: 953 Visits: 950
I forgot to mention this is a 64bit installation of sql server 2005
MANU-J.
MANU-J.
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4852 Visits: 8766
Simply run the SQL installer again and create a new clustered SQL Instance. Note that the new instance will also need a new, unique IP address and a network name in addition to the disk resource. It works exactly the same as the first time, except shared components are already installed and will be skipped this time around.

I am assuming the disks are already set up as clustered disks. If not, you need to do that first so they are in the Available Storage group.
Patti Johnson
Patti Johnson
SSC Eights!
SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)SSC Eights! (953 reputation)

Group: General Forum Members
Points: 953 Visits: 950
Are you saying that I will need an IP for the new SQL clusterr? and that I won't need a new IP for the nodes and I won't need a new IP for the cluster?

My other question was, what do I use to do the install - "add/remove programs" and select sql server, or use the install cd. My concern was the patches and getting the message version warning message.
siva_krishnan
siva_krishnan
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 126
Dear Patricia J.
Good day to you. Do you managed to installe this 2nd SQL instance?
Please share with me. If possible give the step by step procedure.


Friends, anyone can help. pleazzzzzzzzzzz

thanks
siva_krishnan
siva_krishnan
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 126
Dear Gurs's

Can i create or install the 2nd instance as a stand alone instance in cluster machine?
I dont want to fail over this 2nd instance to another node (if the active node is fails).
please share your experience.

regards
siva
Steve-3_5_7_9
Steve-3_5_7_9
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2114 Visits: 1606
Yes.

There are two methods I can think of, neither of which I would personally pursue.

1. Run the SQL Installation and when at the "Components to Install" screen, check "SQL Server Database Services", NOT including "Create a SQL Server failover cluster". You'll need disk that does NOT fail over, so if you're thinking of using disk that is already assigned to a CLUSTER instance, that will NOT be possible.

2. Run the SQL Installation and "Create a SQL Server failover cluster". You'll need cluster resources such as disk and IP. In this case, DO NOT make the other "NODES" available to this instance, therefore the SQL Instance will NOT "FAILOVER". I'm not too sure why you would want to do this, but it's possible. If you have the resources for the install, you might as well use the cluster for availability.

====EDIT====
I would also add that #2 is similiar to having an existing cluster running then you have an issue with a NODE and need to EVICT it, so if you had a two node cluster and you evict one because you need to replace it, or for other reasons. In this case, you're down to 1 node until the 2nd node is added back in. Clusters are intended to keep systems up during server hardware failures.
============


Steve



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search