SQL Server Performance Forum – Threads Archive

MSDTC & Windows Server 2003

Does anyone know what the differences are between the MSDTC in Windows Server 2003 and Windows 2000? We are considering upgrading some web/app servers to Windows 2003 but we would like to leave the database server running 2000AS. With the changes that .Net 1.1 / Win2k3 offer in regards to distributed com+ transactions, I want to ensure that we won’t run into compatibility issues. Would I be required to update the MSDTC on the 2000 server if I upgrade the app/web servers to Windows Server 2003? Is this even possible? -dataninja- "The normalcy of a database is inversely proportional to that of it’s DBA."

Check: http://www.microsoft.com/windowsserver2003/evaluation/overview/technologies/clustering.mspx May be help Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

I would also recommend to refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;301600 to configure MSDTC. But as you choose to upgrade, I suggest to install Win2K3 freshly instead of upgrade from Win 2K. THis way any minor issues will not be carried on to Win2K3. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Hmmm, I think I might not have been clear. I don’t want to upgrade the database server from Win2k to Win2k3, which is why I want to make sure that the MSDTC on Win2k will work correctly with the MSDTC on the application servers which will be running Win2k3. -dataninja- "The normalcy of a database is inversely proportional to that of it’s DBA."

If so, then I assure MSDTC will work on Win2K3 as more enhancements involved as compared to previous releases. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>