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

Need to Install 2nd Instance of SQL Server 2005 on a clustered server Expand / Collapse
Author
Message
Posted Monday, February 1, 2010 6:44 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
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.
Post #857674
Posted Monday, February 1, 2010 6:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
I forgot to mention this is a 64bit installation of sql server 2005
Post #857675
Posted Tuesday, February 2, 2010 4:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
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.
Post #857840
Posted Tuesday, February 2, 2010 7:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
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.
Post #857914
Posted Thursday, December 23, 2010 1:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 14, 2014 4:00 AM
Points: 10, 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
Post #1038637
Posted Tuesday, January 4, 2011 2:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 14, 2014 4:00 AM
Points: 10, 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
Post #1042250
Posted Wednesday, January 5, 2011 5:45 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 26, 2014 6:02 AM
Points: 919, Visits: 1,434
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



Post #1042961
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse