MS-DTC

I have a SQL Server 2000 Cluster with Windows 2003 Server what resource
should MS-DTC depend on?
Thanks,
As per best practices, you should have a seperate group for MS-DTC. MS-DTC requires a shared disk, ip address and network name.
MSDTC resource has dependency for shared disk and network name.
Note: It is NOT recommended to use the SQL shared disk or the quorum disk for MSDTC.
To configure MSDTC on Win2K3, refer to
How to Configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 Cluster
http://support.microsoft.com/?id=301600
How to enable Network DTC access in Windows Server 2003
http://support.microsoft.com/?kbid=817064
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
|||| Thread-Topic: MS-DTC
| thread-index: AcTLRyNpnrzpWJIXSsikFQVGScXNpw==
| X-WBNR-Posting-Host: 12.31.208.217
| From: =?Utf-8?B?Sm9lIEsu?= <JoeK@.discussions.microsoft.com>
| Subject: MS-DTC
| Date: Mon, 15 Nov 2004 11:13:07 -0800
| Lines: 5
| Message-ID: <92309888-96F8-43BF-9790-2C28A712D612@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.clustering
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clustering:15744
| X-Tomcat-NG: microsoft.public.sqlserver.clustering
|
|
| I have a SQL Server 2000 Cluster with Windows 2003 Server what resource
| should MS-DTC depend on?
|
| Thanks,
|
################################################## ##########################
#######
Hello Joe,
The MSDTC resource in a Windows 2003 should ideally be in its own cluster
group, which contains the following resources:
* IP address resource
* Network Name resource
* "Physical disk" resource
* MSDTC Resource
For the depencies of the MSDTC resource you should add both physical disk
and network name.
For further information on setting up MSDTC on a Windows 2003 cluster,
refer to the following KB artilce:
301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600
Regards,
Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Thank you for using the Microsoft newsgroups as your source for technical
information. In this particular case the complexity of your issue will
require in-depth troubleshooting and will not be best served by newsgroup
support. Please go to;
http://support.microsoft.com/common/...fh;en-us;cntac
tms
Select your region from the map and follow the instructions for contacting
our telephone support centers in your area.