Wednesday, April 13, 2011

MSDTC Service on SQL server 2005

How do I Start the MSDTC service on SQL Server 2005?

From stackoverflow
  • 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
    
  • 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.

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.