Right now some of our Windows 2003 server is running DTC service I expected, please see attached.
But what I found out is not all of the SQL group include the DTC resource, is that right that all SQL server instance should have this DTC resource ? or just one SQL group in the cluster need that ?
from my understanding, the installation of cluster will do this for us, we don't have to worry about that, right?
if we need to install it, do we need to restart the SQL instance/service after that ?