MSDTC configuration on active/passive cluster question

Last Post 30 Oct 2008 04:13 AM by Markus_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Markus_SQL
New Member
New Member

--
30 Oct 2008 04:13 AM
I am replacing an old Win2000/SQL2000 Active/passive cluster. My question is what is MSDTC used for ? I guess I am confused. It is not configured on the current cluster but we do have alot of linked servers getting data from our cluster. Isn't MSDTC required for cross db queries/inserts ? I thought it was but the service is not running on our current server. On the new WIN2003 cluster it is running and in Cluster Admin so our server admin must have already configured it...


Acceptable Use Policy
---