http://www.sql-server-performance.com/sqlserver2000_clustering_install_part1.asp refers... Before SQL Server 2000 can be installed, the MSDTC (which is now a part of SQL Server 2000), must be configured for running in a cluster. Fortunately, this is a simple step. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks, but that particular document was one of the very first ones I read regarding SQL clustering. I don't believe it answers my question though. I don't want to know how to set it up (and the method in that document doesn't work as described on 2k3. I want to know if you actually need it for the situation I described in my original post.
As mentioned above you need not to install DTC seperately as it is a part of SQL SErver 2000 and you need to configure it. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Before starting your installation of SQL Server 2000 and after installing MCS you need to configure MSDTC. Mohan Kumar MSSQL Database Administrator
My question is do you need to install and configure DTC at all if this is a single sql server instance which is not making calls to remote sql servers at all?
