Local DTC is missing on server 2008r2
I've recently had an issue where MSDTC was unable to start up.

The error in the command line when running `net start msdtc` indicated that there were configuration issues.  
I went into the registry and set the configuration settings to the same values as a default installation of MSDTC.

Afterwards, MSDTC was able to start up, however the local dtc seems to be missing in the component services.

I've since followed the steps here.  

 1. `net stop msdtc`
 2. `msdtc -uninstall`
 3. `msdtc -install`
 4. `net start msdtc`

And the steps here.  
Which is the similar procedure as above only with also deleting the registry configuration.

I've also put back a registry backup and rebooted.  
And rebooted after reinstalling.

So far no matter what, the local dtc is hiding from me.  
Does anyone know what might be wrong here, and how to reinstall the local dtc?
I've made an identical post on serverfault.


  • Edited by Reaces 37 minutes ago Server version wrong!
August 31st, 2015 6:14am

Have you performed the installation with an administration command prompt, it will not install with a standard command prompt due to UAC and will not error out.  Also I saw your other post on serverfault, you stated this is 2012 not 2012r2, R2 has the new power shell commands and 2012 does not, they are different operating system versions, not an upgrade.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 7:34pm

Try to remove application role and reinstall application role

Roger

September 1st, 2015 2:27am

Your question made me realize a big blunder in my writeup!

While I'm talking about SQL-Server 2012 (the OS is dedicated to running a SQL Server database for a CRM install)...
The server itself is actually 2008r2, which makes the remarks about the Powershell cmdlets indeed redundant.

My apologies (And thank you very much for the remark)

As for the Administrator being required:

I can see the following two events in event viewer after running it as a an administrator:

 The Microsoft Distributed Transaction Coordinator service was successfully removed.   
 The Microsoft Distributed Transaction Coordinator service was successfully installed.

  • Edited by Reaces 26 minutes ago
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 3:14am

The application role was never installed.  

As this is an msdtc installed for SQL Server purposes, the application role is not used.

To make sure that this role is indeed not required (as it is mentioned in a lot of posts) I checked the dev version of this server. 
It also does not have an application role, but does have the local dtc in the component services.

September 1st, 2015 3:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics