Would you please provide me the checklist to install SQL Server 2008 and SP3 on a Windows Cluster 2008 R2 SP1 Active/Passive node

Hi there,
Would you please provide me the checklist to install SQL Server 2008 and SP3 on a Windows Server 2008 R2 SP1 on Active Passive node? Thank you in advance for your help.
hpradhan08Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
Active/Passive should be pretty straight forward running "New SQL Server failover cluster installation" on one node and "Add node to a SQL Server failover cluster" on the other node. Below link is for SQL 2005 but for 2008 would be the same:

http://blogs.msdn.com/b/blakhani/archive/2008/06/09/sql-2005-cluster-setup-checklist.aspx


And this is a walkthrough for "SQL Server 2008 Active-Passive/Active-Active Cluster Installation":
http://sqldbpool.com/2009/10/07/sql-server-2008-active-passive-cluster-installation/
0
hpradhan08Author Commented:
I went throught those docs. But it won't show the process to put the IPs... Don't we need to incoporate the IP SQL CLuster install for the following:


Cluster name (OS cluster) - IP Addresss
Cluster name (SQL cluster) -  IP Addresss
Cluster name(MSDTC) -  IP Addresss
Cluster name(node 1) -  IP Addresss
Cluster name(heartbeat) -  IP Addresss
Cluster name  (node 2) -  IP Addresss
Cluster name (heartbeat) -  IP Addresss

Please provide me the full process to complete the Active/Passive node.
0
hpradhan08Author Commented:
any suggestions please
0
lcohanDatabase AnalystCommented:
Maybe you should read/follow the steps provided by Microsoft - please search/download: SQLServer2008FailoverCluster.docx
and http://technet.microsoft.com/en-us/library/dd197457


Also very good detals including screen shots "SQL Server 2008 Active-Passive/Active-Active Cluster Installation":
http://sqldbpool.com/2009/10/07/sql-server-2008-active-passive-cluster-installation/


Basicaly the process is done through "Failover Cluster Management tool in Windows Server 2008" which is installed at least on one node and before SQL 2008 install.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hpradhan08Author Commented:
good, thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.