How do I Start the MSDTC service on SQL Server 2005?
+1
A:
Microsoft Distributed Transaction Coordinator is not "on SQL Server" per se - it is a normal Windows Service. To start it, go to the command prompt and enter:
net start msdtc
Guido Domenici
2009-03-11 09:38:58
A:
If you want to get access to MSDTC administration UI, go to Administration=>Component Services=>Local Computer. There you'll be able to manage the MSDTC via GUI.
Valentin Vasiliev
2009-03-11 09:45:41