Does Sql 2000 Cluster require DTC?

Hello,
Currently I need to deploy a cluster environment for my client. I've
found many topics discussing about whether Sql 2000 cluster requires
DTC to operate, but still see no final answer for it. Can someone
please help me answer this question?
Thanks,
BN
SQL does not require it, but Exchange does. We have dozens of SQL Clusters
running nicely without MSDTC.
You might need it for your applications to use SQL though, check with your
software vendors.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
<buunguyen@.psv.com.vn> wrote in message
news:1128374943.452421.139090@.f14g2000cwb.googlegr oups.com...
> Hello,
> Currently I need to deploy a cluster environment for my client. I've
> found many topics discussing about whether Sql 2000 cluster requires
> DTC to operate, but still see no final answer for it. Can someone
> please help me answer this question?
> Thanks,
> BN
>
|||Thanks so much for your answer and proof ;-) Rod.
Regards,
Nguyen

does not install SQL Query Analyzer

Hi,

I am developing and application in pocket pc windows mobile 2003. I have added a reference to System.Data.SqlServerCe.dll but when i deploy the application query analyzer doesnt seem to install. Any help please?

cheers,

michael

Hi,

Sorry... for info I am using CS VS2005 and SQL Mobile.

Thank you.

michael

|||

Query Analyzer 3.0 should deploy automatically if you are building and deploying a DEBUG build in VS2005 given your reference to System.Data.SqlServerCe.dll version 2.0. You can also just grab the dev tools CAB and install it to your device/emulator to save time. it is located (depending on your device's WinCE kernel) at:

<drive:>\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4\sqlce30.dev.ENU.ppc.wce4.armv4.CAB

or

C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\<device CPU architecture>\

Darren