I've read about a thousand different things and really need a straight answer:
I'm setting up clustering on a dual-node W2K3 cluster.
If the applications that are accessing the SQL Server DO NOT utilize MSDTC,
do I need to even bother with creating the group, resources, etc. for MSDTC?
If I still need to create it, exactly what is the Network Resoource name:
just some random name I make up or is it something specific?
And doesn't SQL Server install create those anywway?
Thanks for any help you can provide.
Anthony
SQL does not require MSDTC, if you app does not use it, don't install it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"A. Robinson" <A. Robinson@.discussions.microsoft.com> wrote in message
news:6B0E7A37-47B3-475D-81AE-FE0C4E49E900@.microsoft.com...
> I've read about a thousand different things and really need a straight
> answer:
> I'm setting up clustering on a dual-node W2K3 cluster.
> If the applications that are accessing the SQL Server DO NOT utilize
> MSDTC,
> do I need to even bother with creating the group, resources, etc. for
> MSDTC?
> If I still need to create it, exactly what is the Network Resoource name:
> just some random name I make up or is it something specific?
> And doesn't SQL Server install create those anywway?
> Thanks for any help you can provide.
> Anthony
|||Thank you!!! Was going nuts trying to convince people it didn't need to be
there if you don't use it...
"Rodney R. Fournier [MVP]" wrote:
> SQL does not require MSDTC, if you app does not use it, don't install it.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "A. Robinson" <A. Robinson@.discussions.microsoft.com> wrote in message
> news:6B0E7A37-47B3-475D-81AE-FE0C4E49E900@.microsoft.com...
>
>
|||If you won't be using it heavily, I would still set it up using in the
cluster group using the Quorum disk. I personally have had zero success
installing a clustered SQL 2000 without MSDTC.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:EEB3C7D5-974C-4CDB-9C82-69230336BA96@.microsoft.com...[vbcol=seagreen]
> Thank you!!! Was going nuts trying to convince people it didn't need to be
> there if you don't use it...
> "Rodney R. Fournier [MVP]" wrote:
it.[vbcol=seagreen]
name:[vbcol=seagreen]
|||Really? We have 20 of them. They all work great.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23Qim8SkJFHA.3340@.TK2MSFTNGP14.phx.gbl...
> If you won't be using it heavily, I would still set it up using in the
> cluster group using the Quorum disk. I personally have had zero success
> installing a clustered SQL 2000 without MSDTC.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
> news:EEB3C7D5-974C-4CDB-9C82-69230336BA96@.microsoft.com...
> it.
> name:
>
|||While SQL Server does not require MS DTC, MS DTC on a cluster is only
supported when clustered and it is recommended to cluster it.
When clustering MS DTC it is preferred to have it in its own group with its
own resources, your second choice should be to put it in the cluster group,
use the quorum disk and create MS DTC its own Network Name and IP Address
resources for your MSDTC resource to use and set that resources properties
not to affect the group.
Here are some KB articles on correctly setting this up:
301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600
817064 How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/?id=817064
Also this article which may be of interest:
817065 How To Enable Network COM Access in Windows Server 2003
http://support.microsoft.com/?id=817065
Dave Whitney
SQL Support
|||Agreed, since we use SQL clusters without MSDTC, we disable the default
windows service for it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Dave Whitney [MS]" <dwhitneyOnline@.microsoft.com> wrote in message
news:FEBotroJFHA.132@.TK2MSFTNGXA02.phx.gbl...
> While SQL Server does not require MS DTC, MS DTC on a cluster is only
> supported when clustered and it is recommended to cluster it.
> When clustering MS DTC it is preferred to have it in its own group with
> its
> own resources, your second choice should be to put it in the cluster
> group,
> use the quorum disk and create MS DTC its own Network Name and IP Address
> resources for your MSDTC resource to use and set that resources properties
> not to affect the group.
> Here are some KB articles on correctly setting this up:
> 301600 How to configure Microsoft Distributed Transaction Coordinator on a
> http://support.microsoft.com/?id=301600
> 817064 How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/?id=817064
> Also this article which may be of interest:
> 817065 How To Enable Network COM Access in Windows Server 2003
> http://support.microsoft.com/?id=817065
> Dave Whitney
> SQL Support
>
|||Well, we have been scared by the recommended best practices into submission,
and simply sucked in and coughed up a separate disk for the MSDTC resource.
(I'm not talking about whether the MSDTC resource should or should not be
configured. It should in our environments.)
Linchi
"Dave Whitney [MS]" <dwhitneyOnline@.microsoft.com> wrote in message
news:FEBotroJFHA.132@.TK2MSFTNGXA02.phx.gbl...
> While SQL Server does not require MS DTC, MS DTC on a cluster is only
> supported when clustered and it is recommended to cluster it.
> When clustering MS DTC it is preferred to have it in its own group with
> its
> own resources, your second choice should be to put it in the cluster
> group,
> use the quorum disk and create MS DTC its own Network Name and IP Address
> resources for your MSDTC resource to use and set that resources properties
> not to affect the group.
> Here are some KB articles on correctly setting this up:
> 301600 How to configure Microsoft Distributed Transaction Coordinator on a
> http://support.microsoft.com/?id=301600
> 817064 How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/?id=817064
> Also this article which may be of interest:
> 817065 How To Enable Network COM Access in Windows Server 2003
> http://support.microsoft.com/?id=817065
> Dave Whitney
> SQL Support
>
Showing posts with label clustering. Show all posts
Showing posts with label clustering. Show all posts
Monday, February 20, 2012
MSDTC / W2K3 / SQL 2000 Clustering
I'm in the process of setting up my first W2K3 / SQL 2000 cluster and I have a few questions with regards to MSDTC.
Documentation I have says that MSDTC must be clustered in order for SQL clustering to work. It also says that you cannot use comclust.exe anymore and that MSDTC must be setup in its own group with the following ( VIP, Network Name, and dedicated shared di
sk). I currently have Windows and SQL 2000 clustering up and running without MSDTC clustered.
My questions are :
1) Do I need MSDTC at all? If so, why?
2) If I do need MSDTC clustered, can I use a disk that has other applications installed on it? (I only have two LUNS to work with on the SAN, my quorum device and a device I'm using for SQL data / logs)
I know that I haven't given a lot of background information, but I was hoping I could get a discussion started.
Thanks.
Comments inline.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"tech_arch_guy" <tech_arch_guy@.discussions.microsoft.com> wrote in message
news:2B8AD70E-877C-4F02-A0F7-7A51B072075C@.microsoft.com...
> I'm in the process of setting up my first W2K3 / SQL 2000 cluster and I
have a few questions with regards to MSDTC.
> Documentation I have says that MSDTC must be clustered in order for SQL
clustering to work. It also says that you cannot use comclust.exe anymore
and that MSDTC must be setup in its own group with the following ( VIP,
Network Name, and dedicated shared disk). I currently have Windows and SQL
2000 clustering up and running without MSDTC clustered.
> My questions are :
> 1) Do I need MSDTC at all? If so, why?
Yes. Setup will fail without MSDTC.
> 2) If I do need MSDTC clustered, can I use a disk that has other
applications installed on it? (I only have two LUNS to work with on the SAN,
my quorum device and a device I'm using for SQL data / logs)
>
W2000 used the quorum device as the MSDTC physical disk by default. W2003
recommends using another disk, but in your case the qourum drive is probably
OK. I have a cluster upgraded from W2000 to W2003 with MSDTC on the quorum
device and it works just fine.
> I know that I haven't given a lot of background information, but I was
hoping I could get a discussion started.
> Thanks.
|||You do NOT need MSDTC clustered for installing SQL Server 2000 virtual instance on a Windows 2003 Microsoft Cluster Server. You need MSDTC only if you doing distributed transactions. you can cluster MSDTC
even after installing SQL Server 2000 virtual instance.
Refer the foll. KB for Win2K3
How to configure Microsoft Distributed Transaction Coordinator (MSDTC)on a Windows Server 2003
http://support.microsoft.com/?kbid=301600
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/default.aspx?kbid=817064
It is recommended to use a seperate shared disk (500MB works) for MSDTC. In your case you just have the qourum disk and sql disk. I have seen many clusters that have MSDTC using the Quorum disk. Usually if
you are not doing a lot of distributed transactions then leave that way if everything is working fine. But if you are building your cluster and want to build as per best practices then the recommendation is to use a
seperate disk for MSDTC.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I agree with Uttam but if you like to create DTC resource if you have
distributed transactions or even linked servers, you will be creating it just
like you create a disk resource. Make sure you have a disk, name and ip
resource created for MSDTC.
"Uttam Parui[MS]" wrote:
> You do NOT need MSDTC clustered for installing SQL Server 2000 virtual instance on a Windows 2003 Microsoft Cluster Server. You need MSDTC only if you doing distributed transactions. you can cluster MSDTC
> even after installing SQL Server 2000 virtual instance.
> Refer the foll. KB for Win2K3
> How to configure Microsoft Distributed Transaction Coordinator (MSDTC)on a Windows Server 2003
> http://support.microsoft.com/?kbid=301600
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default.aspx?kbid=817064
> It is recommended to use a seperate shared disk (500MB works) for MSDTC. In your case you just have the qourum disk and sql disk. I have seen many clusters that have MSDTC using the Quorum disk. Usually if
> you are not doing a lot of distributed transactions then leave that way if everything is working fine. But if you are building your cluster and want to build as per best practices then the recommendation is to use a
> seperate disk for MSDTC.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
Documentation I have says that MSDTC must be clustered in order for SQL clustering to work. It also says that you cannot use comclust.exe anymore and that MSDTC must be setup in its own group with the following ( VIP, Network Name, and dedicated shared di
sk). I currently have Windows and SQL 2000 clustering up and running without MSDTC clustered.
My questions are :
1) Do I need MSDTC at all? If so, why?
2) If I do need MSDTC clustered, can I use a disk that has other applications installed on it? (I only have two LUNS to work with on the SAN, my quorum device and a device I'm using for SQL data / logs)
I know that I haven't given a lot of background information, but I was hoping I could get a discussion started.
Thanks.
Comments inline.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"tech_arch_guy" <tech_arch_guy@.discussions.microsoft.com> wrote in message
news:2B8AD70E-877C-4F02-A0F7-7A51B072075C@.microsoft.com...
> I'm in the process of setting up my first W2K3 / SQL 2000 cluster and I
have a few questions with regards to MSDTC.
> Documentation I have says that MSDTC must be clustered in order for SQL
clustering to work. It also says that you cannot use comclust.exe anymore
and that MSDTC must be setup in its own group with the following ( VIP,
Network Name, and dedicated shared disk). I currently have Windows and SQL
2000 clustering up and running without MSDTC clustered.
> My questions are :
> 1) Do I need MSDTC at all? If so, why?
Yes. Setup will fail without MSDTC.
> 2) If I do need MSDTC clustered, can I use a disk that has other
applications installed on it? (I only have two LUNS to work with on the SAN,
my quorum device and a device I'm using for SQL data / logs)
>
W2000 used the quorum device as the MSDTC physical disk by default. W2003
recommends using another disk, but in your case the qourum drive is probably
OK. I have a cluster upgraded from W2000 to W2003 with MSDTC on the quorum
device and it works just fine.
> I know that I haven't given a lot of background information, but I was
hoping I could get a discussion started.
> Thanks.
|||You do NOT need MSDTC clustered for installing SQL Server 2000 virtual instance on a Windows 2003 Microsoft Cluster Server. You need MSDTC only if you doing distributed transactions. you can cluster MSDTC
even after installing SQL Server 2000 virtual instance.
Refer the foll. KB for Win2K3
How to configure Microsoft Distributed Transaction Coordinator (MSDTC)on a Windows Server 2003
http://support.microsoft.com/?kbid=301600
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/default.aspx?kbid=817064
It is recommended to use a seperate shared disk (500MB works) for MSDTC. In your case you just have the qourum disk and sql disk. I have seen many clusters that have MSDTC using the Quorum disk. Usually if
you are not doing a lot of distributed transactions then leave that way if everything is working fine. But if you are building your cluster and want to build as per best practices then the recommendation is to use a
seperate disk for MSDTC.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I agree with Uttam but if you like to create DTC resource if you have
distributed transactions or even linked servers, you will be creating it just
like you create a disk resource. Make sure you have a disk, name and ip
resource created for MSDTC.
"Uttam Parui[MS]" wrote:
> You do NOT need MSDTC clustered for installing SQL Server 2000 virtual instance on a Windows 2003 Microsoft Cluster Server. You need MSDTC only if you doing distributed transactions. you can cluster MSDTC
> even after installing SQL Server 2000 virtual instance.
> Refer the foll. KB for Win2K3
> How to configure Microsoft Distributed Transaction Coordinator (MSDTC)on a Windows Server 2003
> http://support.microsoft.com/?kbid=301600
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default.aspx?kbid=817064
> It is recommended to use a seperate shared disk (500MB works) for MSDTC. In your case you just have the qourum disk and sql disk. I have seen many clusters that have MSDTC using the Quorum disk. Usually if
> you are not doing a lot of distributed transactions then leave that way if everything is working fine. But if you are building your cluster and want to build as per best practices then the recommendation is to use a
> seperate disk for MSDTC.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
MSDTC - The Microsoft Clustering Service failed restore a registry
Cluster active-active.
The node B was reinstalled after a hardware failure.
Now the node B is ok. The failover is ok, except because I receive the
message"The Microsoft Clustering Service failed restore a registry key for
resource SQL Server " when I move the Instance B from Node A to Node B.
How can I install MSDTC without affect the Node A (without unistall msdtc
from this node) ?
Node A - Instance A (msdtc resource is online)
thanks for your help.
You don't install DTC, it is already on the machine. It is part of the OS.
You just configure the resource into the cluster. All you should have to do
is edit the properties of the DTC resource and add NodeB as a possible
owner.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:F5B0FAB8-C20C-4009-96A9-98AB79D5D965@.microsoft.com...
> Cluster active-active.
> The node B was reinstalled after a hardware failure.
> Now the node B is ok. The failover is ok, except because I receive the
> message"The Microsoft Clustering Service failed restore a registry key for
> resource SQL Server " when I move the Instance B from Node A to Node B.
> How can I install MSDTC without affect the Node A (without unistall msdtc
> from this node) ?
> Node A - Instance A (msdtc resource is online)
> thanks for your help.
The node B was reinstalled after a hardware failure.
Now the node B is ok. The failover is ok, except because I receive the
message"The Microsoft Clustering Service failed restore a registry key for
resource SQL Server " when I move the Instance B from Node A to Node B.
How can I install MSDTC without affect the Node A (without unistall msdtc
from this node) ?
Node A - Instance A (msdtc resource is online)
thanks for your help.
You don't install DTC, it is already on the machine. It is part of the OS.
You just configure the resource into the cluster. All you should have to do
is edit the properties of the DTC resource and add NodeB as a possible
owner.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:F5B0FAB8-C20C-4009-96A9-98AB79D5D965@.microsoft.com...
> Cluster active-active.
> The node B was reinstalled after a hardware failure.
> Now the node B is ok. The failover is ok, except because I receive the
> message"The Microsoft Clustering Service failed restore a registry key for
> resource SQL Server " when I move the Instance B from Node A to Node B.
> How can I install MSDTC without affect the Node A (without unistall msdtc
> from this node) ?
> Node A - Instance A (msdtc resource is online)
> thanks for your help.
MSDTC
Hi all,
I'm new to clustering. Just some question to ask u all.
Do we have to configure separate static ip, network name and physical disk
for the MSDTC?
Or we can use the same static ip, network name and physical disk(Q:quorum
disk) that we configure for server clustering?
Appreciate ur help.
Tks
Message posted via http://www.droptable.com
Current best practice recommendations from Microsoft say to put MSDTC in its
own virtual server. therefore you will need a static IP addres, network
name, and physical disk. It is possible to use the Quorum disk and group
but it is not recommended. If you expect a low volume of Distributed
Transactions, you should be OK sharing one device.
Geoff N. Hiten
Microsoft SQL Server MVP
"Mohd Hidayat via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:947e91d07767474e88186ebbb5ed1539@.droptable.co m...
> Hi all,
> I'm new to clustering. Just some question to ask u all.
> Do we have to configure separate static ip, network name and physical disk
> for the MSDTC?
> Or we can use the same static ip, network name and physical disk(Q:quorum
> disk) that we configure for server clustering?
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.droptable.com
|||Mohd
It is recommended to create a new group with disk, ip, and name resources
available for the MSDTC resource. It is acceptable to use an existing group
if you do not have the resource capasity.
http://support.microsoft.com/default...b;en-us;301600
Regards
CT
"Mohd Hidayat via droptable.com" wrote:
> Hi all,
> I'm new to clustering. Just some question to ask u all.
> Do we have to configure separate static ip, network name and physical disk
> for the MSDTC?
> Or we can use the same static ip, network name and physical disk(Q:quorum
> disk) that we configure for server clustering?
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.droptable.com
>
I'm new to clustering. Just some question to ask u all.
Do we have to configure separate static ip, network name and physical disk
for the MSDTC?
Or we can use the same static ip, network name and physical disk(Q:quorum
disk) that we configure for server clustering?
Appreciate ur help.
Tks
Message posted via http://www.droptable.com
Current best practice recommendations from Microsoft say to put MSDTC in its
own virtual server. therefore you will need a static IP addres, network
name, and physical disk. It is possible to use the Quorum disk and group
but it is not recommended. If you expect a low volume of Distributed
Transactions, you should be OK sharing one device.
Geoff N. Hiten
Microsoft SQL Server MVP
"Mohd Hidayat via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:947e91d07767474e88186ebbb5ed1539@.droptable.co m...
> Hi all,
> I'm new to clustering. Just some question to ask u all.
> Do we have to configure separate static ip, network name and physical disk
> for the MSDTC?
> Or we can use the same static ip, network name and physical disk(Q:quorum
> disk) that we configure for server clustering?
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.droptable.com
|||Mohd
It is recommended to create a new group with disk, ip, and name resources
available for the MSDTC resource. It is acceptable to use an existing group
if you do not have the resource capasity.
http://support.microsoft.com/default...b;en-us;301600
Regards
CT
"Mohd Hidayat via droptable.com" wrote:
> Hi all,
> I'm new to clustering. Just some question to ask u all.
> Do we have to configure separate static ip, network name and physical disk
> for the MSDTC?
> Or we can use the same static ip, network name and physical disk(Q:quorum
> disk) that we configure for server clustering?
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.droptable.com
>
Subscribe to:
Posts (Atom)