‘MSDTC unavailable for SQL Express Transactions’ or ‘Who took my MSDTC settings on Vista?’

Greeted this morning by the following error after starting my unit tests “MSDTC on server ‘LONDON\SQLEXPRESS’ is unavailable.”. Just moved development to a new Vista machine. Ok, that’s usually solved quickly by activating Network DTC Access (side note: System.Transactions promotes to MSDTC if it needs too).

On Win2003 and XP you opened up the Component Services, right-clicked Properties on the ‘My Computer’ node under Computer Services > Computers and opened the ‘MSDTC’ tab in the dialog. There you changed the security settings. On Vista (and Win2008 where we had similar troubles a week or so ago, and I had forgotten to ask exactly where and how our sysadmin fixed it) you have to run ‘dcomcnfg’ from the run prompt and if you take the above described path it looks like this:

Lot’s of blank space and no ‘Security Settings’. Ok, in Vista onward they moved the security settings to a new node. Expand the tree to see the ‘Local DTC’ node.

Properties on that look like this:

There you can switch to the Security tab and activate Network DTC access. Voila you’re done…

Advertisements

13 thoughts on “‘MSDTC unavailable for SQL Express Transactions’ or ‘Who took my MSDTC settings on Vista?’

  1. On my Security tab, ‘Network DTC Access’ wasn’t checked.

    I had problem with message similar to this one:

    MSDTC on server ‘\SQLEXPRESS’ is unavailable.

    Thanks, it works now :)

  2. I have been trawling the net for hours now for this solution. Thanks for the post. Precise answer to a troublesome issue…

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s