Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srm
Starting Member
8 Posts |
 Posted - 2014-12-11 : 10:22:28
|
| Hello Everyone,I am fresher to windows clustering and doing sql clustering first time.I am doing windows clustering on vmware for two node cluster and san storage is iscsitarget software downloaded from net.Now I was able to sucessfuly configure windows cluster on windows server 2008 R2,I would like to know before doing sql clustering on it.When I install Sql on node1 which is on cluster,I require to restart my vm machine(i.e Node1) after installing Sql server 2012 ent edition.Now in that case my windows cluster would failover,then What should I doto resolve this problem.Do I need to stop windows cluster while installing Sql on clustered node? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-11 : 12:29:34
|
| I always perform a restart when installing SQL Server. Sometimes it won't be required until after you install the service pack, but I do it even if it doesn't mention it. You do not need to and should not stop the Windows cluster. You will need to install SQL on both nodes, the second node will be using the "add a node" option.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
srm
Starting Member
8 Posts |
Posted - 2014-12-11 : 13:02:44
|
quote:
Originally posted by tkizer
I always perform a restart when installing SQL Server. Sometimes it won't be required until after you install the service pack, but I do it even if it doesn't mention it. You do not need to and should not stop the Windows cluster. You will need to install SQL on both nodes, the second node will be using the "add a node" option.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
Well,I believe you can also install through Advanced option from Installation media from Advance Cluster Preparation on both nodes and then using Advanced Cluster Completion on any one node where clustering is created.But in any case after Sql installation you need to restart the machine(vmware in my case)then it would affect windows cluster that is running on one the nodes as it will not be available that might start failover am I right?? |
|
|
|
srm
Starting Member
8 Posts |
Posted - 2014-12-11 : 13:05:37
|
| Could please me the steps what I need to do?I have two node windows cluster on vmware with third machine acting as a DC with SAN storage created with iscsi target and initialtor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-11 : 13:50:17
|
| Yes if you restart a node and if it was hosting any cluster resources, then those cluster resources will be failed over to the other node. What other cluster resources do you have?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
srm
Starting Member
8 Posts |
Posted - 2015-01-06 : 03:46:46
|
| Hi I have only Sql Server 2012 on my cluster,no other resource.So How do Stop/shutdown windows cluster gracefully so it will not fail on my vmware.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-06 : 12:01:22
|
| Why are you stopping/shutting down the windows cluster? All you need to do is perform a failover so that one node is active and the other is passive. You can perform work on the passive node without impacting the active node.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
Understanding Sql Failover Clustering