Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Adding instance to sql cluster

Posted on 2011-02-14
7
Medium Priority
?
563 Views
Last Modified: 2012-05-11
We have a 2 node sql cluster and need to install another instance.  This instance will be installed on Node1 (both  nodes are 'active').  I have never done this before and was hoping someone could provide explicit instructions on how to install a new instance (named of course) and also how to go about applying the patch.
0
Comment
Question by:sqlnewbie08
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 1200 total points
ID: 34891811
0
 

Author Comment

by:sqlnewbie08
ID: 34891873
Yes... I am aware of this.  We are having all the necessary infrastructure in place before the install begins (separate virtual server, ip address, luns ...).  What i've never done is install a new instance on an exisiting clustered environment and then patch the new instance.  That is what I  need to know how to do.
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 1200 total points
ID: 34892094
Ok, so if you have dedicated disks, IP, etc. please see articles below and do all these in a TEST environment first not directly to PRODUCTION environment. Also no matter what you do, because SQL is clueter aware and you have already a cluster built and running, perform ALL actions on ACTIVE node during downtime and from Cluster Manager exclusively including service packs/patches.

We did similar thing in dev/testing and did not worked verry well so we will be building brand new environment for SQL 2008 soon then migrate our prod DB's db's to that environment.

SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en


You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server 2008
http://support.microsoft.com/kb/932897

Lessons Learned
http://technet.microsoft.com/en-ca/library/cc917532.aspx
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 1200 total points
ID: 34892107
Oh yeah...I remember we had quite some fun with admin domain accounts running the patches that were "named" differently on active directory vs no active directory domain.
0
 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 400 total points
ID: 34892982
if you have set 1st node and have set shared drives and got ip for new sql server:
check:

How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)
http://msdn.microsoft.com/en-us/library/ms191545%28v=SQL.90%29.aspx


How to Cluster SQL Server 2005
http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

0
 

Author Comment

by:sqlnewbie08
ID: 34897114
I've reviewed all these docs ...  none of the specifically let you know how to add an instance to an existing cluster.  
0
 

Assisted Solution

by:publicvoid
publicvoid earned 400 total points
ID: 34899285
Make sure your new disk group is on Node1 and run the SQL installer from there (you will need to choose the appropriate path for your data files during the installation).

Here is a good article, complete with screen shots:

http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

Note that for SQL Server 2005, the installer will install the binaries on all of the nodes in the cluster (unless you explicitly remove them, not recommended). Also be aware that even though you are installing a NEW SQL instance, your existing instances MAY be restarted during the installation. If you are running this on a production cluster, you may want to perform the installation when this is acceptable.

As for patching your clustered SQL instances, simply run the appropriate EXE on a cluster node (make sure you have the correct CPU architecture...x86 or x64). The installer will find all of your SQL instances and let you patch them all together (and will patch all of the nodes in the cluster). Of course, expect SQL service restarts while the patch is running and possible server reboots once patching is complete.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question