hi...
Sorry if i am putting question at wrong place, guide me.
I have tried 2 exploits (available on net) of Distributed
Transaction Coordinator at 4 different 2k machines.
But after execution of exploit, i dont see any change in
behavior of DTC. It works as it was. The target systems
do not have the required patch/service pack.
Kindly put some suggestions or take me to appropriate group.
Take care...bye
Ok, why 2000 and not 2003 R2? Why are you trying to get in? From the inside
of the network or outside? What exactly did you try? What patches did you
think would fix it?
This could be the case where a later patch fixes the issue or your testing
is a little off. Either way - move to 2003!!!!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Umer" <Umer@.discussions.microsoft.com> wrote in message
news:DC4A6615-30F7-44C2-BD81-97D4262B14C4@.microsoft.com...
> hi...
> Sorry if i am putting question at wrong place, guide me.
> I have tried 2 exploits (available on net) of Distributed
> Transaction Coordinator at 4 different 2k machines.
> But after execution of exploit, i dont see any change in
> behavior of DTC. It works as it was. The target systems
> do not have the required patch/service pack.
> Kindly put some suggestions or take me to appropriate group.
> Take care...bye
Showing posts with label required. Show all posts
Showing posts with label required. Show all posts
Friday, March 9, 2012
Wednesday, March 7, 2012
MSDTC Required?
I am preparing for the installation of SQL Server 2005 Standard on a
two-node cluster. The SQL Server books Online" topic named "Before
Installing Failover Clustering" indicates that you must install MSDTC if you
are installing the Database Engine and SSIS, Notification Services or
Workstations components. I am not planning on installing SSIS or
Notification Services but would like to install the Workstations components
(specifically SSMS and the other tools) on the clustered nodes.
Is it really necessary to install MSDTC in the cluster if I don't plan on
doing distributed transactions? I want to keep the installation as simple
as possible and don't see why I need to install MSDTC in the cluster with
the Workstation components.
Any help would be appreciated.
Thanks!
Chris
SQL works a lot better with MSDTC. You can go ahead and install it in the
cluster group if you do not have a lot of distributed transactions.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
>I am preparing for the installation of SQL Server 2005 Standard on a
>two-node cluster. The SQL Server books Online" topic named "Before
>Installing Failover Clustering" indicates that you must install MSDTC if
>you are installing the Database Engine and SSIS, Notification Services or
>Workstations components. I am not planning on installing SSIS or
>Notification Services but would like to install the Workstations components
>(specifically SSMS and the other tools) on the clustered nodes.
> Is it really necessary to install MSDTC in the cluster if I don't plan on
> doing distributed transactions? I want to keep the installation as simple
> as possible and don't see why I need to install MSDTC in the cluster with
> the Workstation components.
> Any help would be appreciated.
> Thanks!
> Chris
>
|||Can you clarify "Works a lot better with..."
I always install it as a matter of procedure but if it's not necessary, how
does it help?
"Geoff N. Hiten" wrote:
> SQL works a lot better with MSDTC. You can go ahead and install it in the
> cluster group if you do not have a lot of distributed transactions.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Cgal" <cgallelli@.newsgroups.nospam> wrote in message
> news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
>
|||SQL tries to initialize a DTS connection when it starts up. When MSDTC is
not there, SQL has to wait for a timeout so you get slower startups and
failovers.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"burt_king" <burt_king@.yahoo.com> wrote in message
news:CA063DB1-C405-44E5-9628-9C10AE5C7630@.microsoft.com...[vbcol=seagreen]
> Can you clarify "Works a lot better with..."
> I always install it as a matter of procedure but if it's not necessary,
> how
> does it help?
>
> "Geoff N. Hiten" wrote:
|||MS DTC is installed on each cluster node as part of the Windows OS
installation. What is required is to make it "clustered."
If you will only be installing a single SQL Server instance, then you can
configure the MS DTC cluster resource to use the same cluster resource group
as the SQL Server installation.
Otherwise, follow the instructions to set up a dedicated cluster resource
group for MS DTC, which will require a dedicated shared cluster disk, IP
address, and Network Name resources.
Do not run MS DTC as a resource in the Quorum cluster resource group.
Sincerely,
Anthony Thomas
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
> I am preparing for the installation of SQL Server 2005 Standard on a
> two-node cluster. The SQL Server books Online" topic named "Before
> Installing Failover Clustering" indicates that you must install MSDTC if
you
> are installing the Database Engine and SSIS, Notification Services or
> Workstations components. I am not planning on installing SSIS or
> Notification Services but would like to install the Workstations
components
> (specifically SSMS and the other tools) on the clustered nodes.
> Is it really necessary to install MSDTC in the cluster if I don't plan on
> doing distributed transactions? I want to keep the installation as simple
> as possible and don't see why I need to install MSDTC in the cluster with
> the Workstation components.
> Any help would be appreciated.
> Thanks!
> Chris
>
|||What if this were active/active sql 2000 instances. Still one MSDTC?
"Anthony Thomas" wrote:
> MS DTC is installed on each cluster node as part of the Windows OS
> installation. What is required is to make it "clustered."
> If you will only be installing a single SQL Server instance, then you can
> configure the MS DTC cluster resource to use the same cluster resource group
> as the SQL Server installation.
> Otherwise, follow the instructions to set up a dedicated cluster resource
> group for MS DTC, which will require a dedicated shared cluster disk, IP
> address, and Network Name resources.
> Do not run MS DTC as a resource in the Quorum cluster resource group.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Cgal" <cgallelli@.newsgroups.nospam> wrote in message
> news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
> you
> components
>
>
|||Each cluster can only have a single MSDTC instance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SQLdba" <burt_king@.yahoo.com> wrote in message
news:D7919F72-F753-4232-80CE-DCD52FA271EA@.microsoft.com...[vbcol=seagreen]
> What if this were active/active sql 2000 instances. Still one MSDTC?
>
> "Anthony Thomas" wrote:
|||In which case, the recommended solution is to have a dedicated MS DTC
cluster resource group with dedicated dependencies (Shared Disk, IP Address,
and Network Name).
In times past, Microsoft recommended adding this resource to the Quorum
group; however, it was determined that this was a bad practices because
whenever the quorum goes offline, and DTC handles are destroyed if the two
resources are collocated.
In a dedicated group, even if the quorum group is moved, or the DTC group is
moved, pending DTC transactions and SQL Server handles are maintained.
Sincerely,
Anthony Thomas
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eKAYYTxaHHA.3272@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Each cluster can only have a single MSDTC instance.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "SQLdba" <burt_king@.yahoo.com> wrote in message
> news:D7919F72-F753-4232-80CE-DCD52FA271EA@.microsoft.com...
can[vbcol=seagreen]
resource[vbcol=seagreen]
IP[vbcol=seagreen]
plan
>
|||Actually, the recommendation was changed based on testing high-volume
systems where certain storage systems could be saturated by the DTC traffic
to the point where the Quorum disk appeared unresponsive, thus causing a
cluster failure. Since Microsoft is officially hardware agnostic, this led
to a blanket recommendation for a dedicated MSDTC group, which later was
modified to apply only to high volume systems.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:eZDWpk7aHHA.4140@.TK2MSFTNGP06.phx.gbl...
> In which case, the recommended solution is to have a dedicated MS DTC
> cluster resource group with dedicated dependencies (Shared Disk, IP
> Address,
> and Network Name).
> In times past, Microsoft recommended adding this resource to the Quorum
> group; however, it was determined that this was a bad practices because
> whenever the quorum goes offline, and DTC handles are destroyed if the two
> resources are collocated.
> In a dedicated group, even if the quorum group is moved, or the DTC group
> is
> moved, pending DTC transactions and SQL Server handles are maintained.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:eKAYYTxaHHA.3272@.TK2MSFTNGP03.phx.gbl...
> can
> resource
> IP
> plan
>
two-node cluster. The SQL Server books Online" topic named "Before
Installing Failover Clustering" indicates that you must install MSDTC if you
are installing the Database Engine and SSIS, Notification Services or
Workstations components. I am not planning on installing SSIS or
Notification Services but would like to install the Workstations components
(specifically SSMS and the other tools) on the clustered nodes.
Is it really necessary to install MSDTC in the cluster if I don't plan on
doing distributed transactions? I want to keep the installation as simple
as possible and don't see why I need to install MSDTC in the cluster with
the Workstation components.
Any help would be appreciated.
Thanks!
Chris
SQL works a lot better with MSDTC. You can go ahead and install it in the
cluster group if you do not have a lot of distributed transactions.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
>I am preparing for the installation of SQL Server 2005 Standard on a
>two-node cluster. The SQL Server books Online" topic named "Before
>Installing Failover Clustering" indicates that you must install MSDTC if
>you are installing the Database Engine and SSIS, Notification Services or
>Workstations components. I am not planning on installing SSIS or
>Notification Services but would like to install the Workstations components
>(specifically SSMS and the other tools) on the clustered nodes.
> Is it really necessary to install MSDTC in the cluster if I don't plan on
> doing distributed transactions? I want to keep the installation as simple
> as possible and don't see why I need to install MSDTC in the cluster with
> the Workstation components.
> Any help would be appreciated.
> Thanks!
> Chris
>
|||Can you clarify "Works a lot better with..."
I always install it as a matter of procedure but if it's not necessary, how
does it help?
"Geoff N. Hiten" wrote:
> SQL works a lot better with MSDTC. You can go ahead and install it in the
> cluster group if you do not have a lot of distributed transactions.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Cgal" <cgallelli@.newsgroups.nospam> wrote in message
> news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
>
|||SQL tries to initialize a DTS connection when it starts up. When MSDTC is
not there, SQL has to wait for a timeout so you get slower startups and
failovers.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"burt_king" <burt_king@.yahoo.com> wrote in message
news:CA063DB1-C405-44E5-9628-9C10AE5C7630@.microsoft.com...[vbcol=seagreen]
> Can you clarify "Works a lot better with..."
> I always install it as a matter of procedure but if it's not necessary,
> how
> does it help?
>
> "Geoff N. Hiten" wrote:
|||MS DTC is installed on each cluster node as part of the Windows OS
installation. What is required is to make it "clustered."
If you will only be installing a single SQL Server instance, then you can
configure the MS DTC cluster resource to use the same cluster resource group
as the SQL Server installation.
Otherwise, follow the instructions to set up a dedicated cluster resource
group for MS DTC, which will require a dedicated shared cluster disk, IP
address, and Network Name resources.
Do not run MS DTC as a resource in the Quorum cluster resource group.
Sincerely,
Anthony Thomas
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
> I am preparing for the installation of SQL Server 2005 Standard on a
> two-node cluster. The SQL Server books Online" topic named "Before
> Installing Failover Clustering" indicates that you must install MSDTC if
you
> are installing the Database Engine and SSIS, Notification Services or
> Workstations components. I am not planning on installing SSIS or
> Notification Services but would like to install the Workstations
components
> (specifically SSMS and the other tools) on the clustered nodes.
> Is it really necessary to install MSDTC in the cluster if I don't plan on
> doing distributed transactions? I want to keep the installation as simple
> as possible and don't see why I need to install MSDTC in the cluster with
> the Workstation components.
> Any help would be appreciated.
> Thanks!
> Chris
>
|||What if this were active/active sql 2000 instances. Still one MSDTC?
"Anthony Thomas" wrote:
> MS DTC is installed on each cluster node as part of the Windows OS
> installation. What is required is to make it "clustered."
> If you will only be installing a single SQL Server instance, then you can
> configure the MS DTC cluster resource to use the same cluster resource group
> as the SQL Server installation.
> Otherwise, follow the instructions to set up a dedicated cluster resource
> group for MS DTC, which will require a dedicated shared cluster disk, IP
> address, and Network Name resources.
> Do not run MS DTC as a resource in the Quorum cluster resource group.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Cgal" <cgallelli@.newsgroups.nospam> wrote in message
> news:eN61fcOZHHA.348@.TK2MSFTNGP02.phx.gbl...
> you
> components
>
>
|||Each cluster can only have a single MSDTC instance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SQLdba" <burt_king@.yahoo.com> wrote in message
news:D7919F72-F753-4232-80CE-DCD52FA271EA@.microsoft.com...[vbcol=seagreen]
> What if this were active/active sql 2000 instances. Still one MSDTC?
>
> "Anthony Thomas" wrote:
|||In which case, the recommended solution is to have a dedicated MS DTC
cluster resource group with dedicated dependencies (Shared Disk, IP Address,
and Network Name).
In times past, Microsoft recommended adding this resource to the Quorum
group; however, it was determined that this was a bad practices because
whenever the quorum goes offline, and DTC handles are destroyed if the two
resources are collocated.
In a dedicated group, even if the quorum group is moved, or the DTC group is
moved, pending DTC transactions and SQL Server handles are maintained.
Sincerely,
Anthony Thomas
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eKAYYTxaHHA.3272@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Each cluster can only have a single MSDTC instance.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "SQLdba" <burt_king@.yahoo.com> wrote in message
> news:D7919F72-F753-4232-80CE-DCD52FA271EA@.microsoft.com...
can[vbcol=seagreen]
resource[vbcol=seagreen]
IP[vbcol=seagreen]
plan
>
|||Actually, the recommendation was changed based on testing high-volume
systems where certain storage systems could be saturated by the DTC traffic
to the point where the Quorum disk appeared unresponsive, thus causing a
cluster failure. Since Microsoft is officially hardware agnostic, this led
to a blanket recommendation for a dedicated MSDTC group, which later was
modified to apply only to high volume systems.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:eZDWpk7aHHA.4140@.TK2MSFTNGP06.phx.gbl...
> In which case, the recommended solution is to have a dedicated MS DTC
> cluster resource group with dedicated dependencies (Shared Disk, IP
> Address,
> and Network Name).
> In times past, Microsoft recommended adding this resource to the Quorum
> group; however, it was determined that this was a bad practices because
> whenever the quorum goes offline, and DTC handles are destroyed if the two
> resources are collocated.
> In a dedicated group, even if the quorum group is moved, or the DTC group
> is
> moved, pending DTC transactions and SQL Server handles are maintained.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:eKAYYTxaHHA.3272@.TK2MSFTNGP03.phx.gbl...
> can
> resource
> IP
> plan
>
Monday, February 20, 2012
MSDTC
hello,
is MSDTC required in order for a 2003 sql cluster to work correctly?
No, MSDTC is not required in order for SQL Server 2000 failover Clustering to work correctly on Windows 2003 MSCS.
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
|||What about when doing linked servers? Do you have to add the MSDTC, MSDTC
Network Name, MSDTC IP Address cluster resources? If not, when would be
necessary to use the MSDTC, MSDTC Network Name, MSDTC IP Address resources
cluste resources.
Does Enable DTC for network access just have to be installed? Our linked
server queries weren't working until we installed Enable DTC for network
access however the cluster also has also. The cluster is an active/active
sql 2000 enterprise with Windows 2003 Enteprise.
Steve
"Calvin Do" <calvin@.spinsonic.com> wrote in message
news:OP7LWvEnEHA.1672@.TK2MSFTNGP09.phx.gbl...
> hello,
> is MSDTC required in order for a 2003 sql cluster to work correctly?
>
|||Steve,
Good question. For distributed transactions if you are using MSDTC as the transaction manager then you will need to configure MSDTC as a clustered resource on a SQL Server 2000 Failover clustering. (Distributed
transactions span two or more servers known as resource managers. The management of the transaction must be coordinated between the resource managers by a server component called a transaction
manager. Microsoft SQL Server can operate as a resource manager in distributed transactions coordinated by transaction managers such as the Microsoft Distributed Transaction Coordinator (MS DTC), or other
transaction managers that support the X/Open XA specification for Distributed Transaction Processing. For more information, see the Microsoft Distributed Transaction Coordinator documentation in SQL Server 2000
Books Online)
Many think that MSDTC has to be configured first otherwise they cannot install SQL Server 2000 cluster properly or it will nto operated correctly and that is not true. I have seen and installed many SQL Server 2000
instances on Win2000 and Win2003 and did not configure MSDTC as it was not required (no distributed transactions were occuring).
HTH,
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
is MSDTC required in order for a 2003 sql cluster to work correctly?
No, MSDTC is not required in order for SQL Server 2000 failover Clustering to work correctly on Windows 2003 MSCS.
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
|||What about when doing linked servers? Do you have to add the MSDTC, MSDTC
Network Name, MSDTC IP Address cluster resources? If not, when would be
necessary to use the MSDTC, MSDTC Network Name, MSDTC IP Address resources
cluste resources.
Does Enable DTC for network access just have to be installed? Our linked
server queries weren't working until we installed Enable DTC for network
access however the cluster also has also. The cluster is an active/active
sql 2000 enterprise with Windows 2003 Enteprise.
Steve
"Calvin Do" <calvin@.spinsonic.com> wrote in message
news:OP7LWvEnEHA.1672@.TK2MSFTNGP09.phx.gbl...
> hello,
> is MSDTC required in order for a 2003 sql cluster to work correctly?
>
|||Steve,
Good question. For distributed transactions if you are using MSDTC as the transaction manager then you will need to configure MSDTC as a clustered resource on a SQL Server 2000 Failover clustering. (Distributed
transactions span two or more servers known as resource managers. The management of the transaction must be coordinated between the resource managers by a server component called a transaction
manager. Microsoft SQL Server can operate as a resource manager in distributed transactions coordinated by transaction managers such as the Microsoft Distributed Transaction Coordinator (MS DTC), or other
transaction managers that support the X/Open XA specification for Distributed Transaction Processing. For more information, see the Microsoft Distributed Transaction Coordinator documentation in SQL Server 2000
Books Online)
Many think that MSDTC has to be configured first otherwise they cannot install SQL Server 2000 cluster properly or it will nto operated correctly and that is not true. I have seen and installed many SQL Server 2000
instances on Win2000 and Win2003 and did not configure MSDTC as it was not required (no distributed transactions were occuring).
HTH,
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
Subscribe to:
Posts (Atom)