February 1, 2010 at 6:44 pm
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.
February 1, 2010 at 6:47 pm
I forgot to mention this is a 64bit installation of sql server 2005
February 2, 2010 at 4:46 am
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.
February 2, 2010 at 7:05 am
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.
December 23, 2010 at 1:17 am
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
January 4, 2011 at 2:44 am
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
January 5, 2011 at 5:45 am
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply