| Author |
Topic |
|
mstclair
Starting Member
13 Posts |
 Posted - 2008-01-09 : 17:58:27
|
| Greetings,I've inherited an existing mission-critical 24/7 available cluster (Server 2003, SQL 2005 SP2) that never had DTC configured (not set up for clustering, service simply fails) but it is now needed for new application functionality. The cluster is rock solid and has no issues. I've read KB301600 and KB817064 and a variety of pages regarding configuring MSDTC and/or SQL for clustering, but everything that talks about both assumes you are setting up DTC before SQL.Are there any issues or pitfalls that I should know of when setting up DTC after the fact? When rebooting the machines as per KB817064, will I be able to do them one at a time and have no downtime? The process of transitioning from SQL with no DTC to SQL using DTC with no downtime is something I'm not finding any resources on.Thanks,Mike |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 23:21:59
|
| Should restart sql service at least after adding msdtc resource. |
 |
|
|
mstclair
Starting Member
13 Posts |
Posted - 2008-01-10 : 09:17:05
|
| So when I reboot the machines, I can do them one at a time, avoiding a larger downtime; and then at the end restart SQL for a brief downtime? Makes sense, thanks for your help. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-10 : 23:40:36
|
| You don't have to add msdtc on each node, it's cluster resource so just add it in cluster admin. |
|
|
|
mstclair
Starting Member
13 Posts |
Posted - 2008-01-11 : 12:33:05
|
quote:
Originally posted by rmiao
You don't have to add msdtc on each node, it's cluster resource so just add it in cluster admin.
I know it doesn't have to be added to each node, but I don't want to reboot the whole cluster at once. KB817064 says to reboot the server, do I reboot the whole cluster or each node? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-11 : 14:22:11
|
quote:
Originally posted by mstclair
quote:
Originally posted by rmiao
You don't have to add msdtc on each node, it's cluster resource so just add it in cluster admin.
I know it doesn't have to be added to each node, but I don't want to reboot the whole cluster at once. KB817064 says to reboot the server, do I reboot the whole cluster or each node?
you should never reboot all nodes of a cluster simultaneously. you fail groups to one node and then reboot the passive node. rinse and repeat.bouncing both nodes simultaneously is asking for trouble.-ec |
|
|
|
mstclair
Starting Member
13 Posts |
Posted - 2008-01-16 : 09:54:56
|
| Thanks to all for the advice, everything went smoothly (and no, I didn't reboot the cluster nodes simultaneously). |
|
|
|
kdubb777
Starting Member
24 Posts |
Posted - 2008-01-17 : 19:49:17
|
| One of the first steps in setting up a cluster on 2k3 is to setup MSDTC. Does anyone know of the affects of not having MSDTC on a SQL cluster?? You mstclait said the cluster was rock solid but I thought it was a requirement for SQL clustering??? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-17 : 20:43:39
|
quote:
Originally posted by kdubb777
One of the first steps in setting up a cluster on 2k3 is to setup MSDTC. Does anyone know of the affects of not having MSDTC on a SQL cluster?? You mstclait said the cluster was rock solid but I thought it was a requirement for SQL clustering???
the op mentions that sql was not initially installed on this cluster. dtc is only a requirement when installing sql on a cluster.-ec |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-19 : 23:37:07
|
| MSDTC is not required on cluster although better to create it first. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-02-28 : 18:28:41
|
| hi there i am about to set up SQL 2005 on Cluster.Is it best to set up the windows cluster first.If i set up SQL 2005 first - is it possible to then point this to the cluster ThanksI recall seeing the option when install sql 2005 on stand server the cluster option? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 22:52:30
|
| You know the answer now. |
|
|
|
|
Adding MSDTC to existing 2005 cluster