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