By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions:

ERROR: MSDTC on server 'servername' is unavailable.

RESOLUTION
On the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.

Resources:
http://support.microsoft.com/kb/822473/
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54705


Feedback

# re: MSDTC on server 'servername' is unavailable

I already started the service but the problem is still existing 2/13/2007 5:57 PM | Roger

# re: MSDTC on server 'servername' is unavailable


Roger, Sometimes it requires the restart of machine, pls try with restarting your database server. 2/28/2007 9:14 AM | Narendra Tiwari

# re: MSDTC on server 'servername' is unavailable (Solution)

you need to run the MSDTC Service
Here you are the way

Control Panel > Adminstrative Tools > Component Services > Computers > (right click) My Computer > Run MS DTC

If you have the application and the SQL Server Data base in two different machines you must do that also

Control Panel > Adminstrative Tools > Component Services > Computers > (right click) My Computer > Properties > MS DTC (TAB) > allow remote access

for put yourself in the save side allow all checkboxs in this window

in this case you may also need to add this attribute to the connection string 'enlist=false' 4/24/2007 5:23 AM | Moslim

# re: MSDTC on server 'servername' is unavailable


Thanks

I got the solution by your comments

Gautam Jain 10/30/2007 2:05 PM | Gautam Jain

# re: MSDTC on server 'servername' is unavailable

Thanks Moslim!
After much research this seemed to solve the problem.

/gustav 2/10/2008 10:46 PM | Gustav Brock

# re: MSDTC on server 'servername' is unavailable

I am running sql server 2005 and getting same issue. I thought this was only a problem with sql server 2000? When I go to turn on the MS DTC it is already started, but started at the time I opened the component services. Does this have to be done everytime the machine starts up? Thanks. 3/4/2008 8:10 PM | Eric

# re: MSDTC on server 'servername' is unavailable

Thank very much, it have been very usefull for me.. 5/5/2008 11:44 PM | Murat

# re: MSDTC on server 'servername' is unavailable

Thanks Dude!
I am very helpful to you.
It resolved my big problem.

Cheers :-) 5/28/2008 9:59 PM | Sanjeev

# re: MSDTC on server 'servername' is unavailable

I have problem with:

"Control Panel > Adminstrative Tools > Component Services > Computers > (right click) My Computer > Properties > MS DTC (TAB) > allow remote access"

after MSDTC(TAB) > security configuration (TAB) > tick all boxes as recommended > but this require to restart service.

is there any other way? 6/30/2008 11:40 AM | oryzana

# re: MSDTC on server 'servername' is unavailable

I have done as you said, but now if i run the update query in sql query analyser, this is giving error: Login failed for user 'sa'
I am using SQL Server 2005, Windows XP 9/9/2008 8:04 PM | Brij Mohan

# re: MSDTC on server 'servername' is unavailable

thx too much! 11/6/2008 12:46 AM | nix

# re: MSDTC on server 'servername' is unavailable

Thanks for your answer, It is working fine 1/21/2009 12:44 PM | murali

# re: MSDTC on server 'servername' is unavailable

Thanks a Lot...Your help is worth
2/2/2009 11:47 AM | Nilesh

# re: MSDTC on server 'servername' is unavailable

Perfect!! My boss ran over in a panic and good old google tech support fixed the issue :o) 2/26/2009 10:19 PM | Ross Pinnuck

# re: MSDTC on server 'servername' is unavailable

Great tip. Thanks! 3/10/2009 6:09 PM | Marc

# re: MSDTC on server 'servername' is unavailable

When I reconfigure the DTC options, sql asks me if I want to restart DTC service and all dependent services.. Anybody knows if sqlserver service is a dependent service ? (will all connected users know it when I press 'ok' ?? :) 3/25/2009 7:10 PM | Shuwi

# re: MSDTC on server 'servername' is unavailable

Run the MSDTC server under the Network Service account 3/30/2009 9:41 PM | Ian

# re: MSDTC on server 'servername' is unavailable

Thank you very much budy..
article left by "Moslim" on Apr 24, 2007 5:23 AM ,it helped me today...thanks a lot..

4/3/2009 12:52 PM | Shakti

# re: MSDTC on server 'servername' is unavailable

Dude it worked !
Thanks ! 5/11/2009 10:38 PM | Hemal

# re: MSDTC on server 'servername' is unavailable

Sweet action. I am yet another satisfied customer. 6/30/2009 1:11 PM | flyfishr

# re: MSDTC on server 'servername' is unavailable

Bundle of thanx to "Moslim " for his valuable comments:
"in this case you may also need to add this attribute to the connection string 'enlist=false' "

this solved my problem after spending more than 3 days

my SQL server is on other machine, so after solving the issue:
"ERROR: MSDTC on server 'servername' is unavailable.",
i encountered another error:
"The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)"
Thanx God it is solved now..! :) 7/19/2009 6:55 AM | Bilal Haider

# re: MSDTC on server 'servername' is unavailable

Moslim is the MAN!!!

Thank you for sharing your insights on this. It helped me fix the problem I've been troubleshooting for the last two days. 8/7/2009 10:40 AM | Marcelo

# re: MSDTC on server 'servername' is unavailable

Very useful, just had this problem as I have ventured into the world of Transactions and LINQ

:)
Andi
Zero7Web 8/11/2009 4:48 AM | Andi G

# re: MSDTC on server 'servername' is unavailable

Thank You very much
for such a nice Help
All the best 8/19/2009 8:42 AM | Nushrat Ali Tyagi

# re: MSDTC on server 'servername' is unavailable

Thank's u so much Moslem and Narendra Tiwari..
THanks for sharing
8/24/2009 8:12 AM | Adnan

# re: MSDTC on server 'servername' is unavailable

Thank you very much, it worked for me! 9/25/2009 1:10 AM | Puja

# re: MSDTC on server 'servername' is unavailable

Thanks very much it is really good. 10/1/2009 4:33 PM | susheel

# re: MSDTC on server 'servername' is unavailable

But isn't 'enlist=false' defeating the whole purpose of having a Transaction? Any operation using that connection string will not be within the ambient transaction. If you really don't want a transaction you can use the TransactionScopeOption.Supress in the transaction scope. 11/6/2009 2:57 AM | Ashutosh

# re: MSDTC on server 'servername' is unavailable

Thanks a lot for your help mate, It was very helpful, now I can continue developing. 11/30/2009 6:25 PM | Reedyseth

# re: MSDTC on server 'servername' is unavailable

Thanks a lot!!! 12/14/2009 6:46 PM | Daniel Makiyama

# re: MSDTC on server 'servername' is unavailable

hey Man, this is not working...I dont know what is wrong!
but Thanks a lot fo ryour insights.!
12/17/2009 11:44 PM | MK

# re: MSDTC on server 'servername' is unavailable

I was trying to hydrate WF but it was failed because this service was "stop". After I start this service then it dehydrates succefully... Thanks for this post. 12/21/2009 12:02 PM | Syed

# re: MSDTC on server 'servername' is unavailable

Thanks a lot! You're a big help.. 1/7/2010 7:14 AM | Egman O. Sanit

# re: MSDTC on server 'servername' is unavailable

Thanks A lot1 You are a great Help 4/20/2010 3:58 PM | Krishna

# re: MSDTC on server 'servername' is unavailable

Thanks so much.
4/21/2010 12:48 PM | tano carridi

# re: MSDTC on server 'servername' is unavailable

Thank you very much! It worked well. 5/14/2010 10:03 AM | HanNguyen

# re: MSDTC on server 'servername' is unavailable

Thanks for the solution. It's working fine for me. 6/1/2010 12:02 PM | A PATEL

# re: MSDTC on server 'servername' is unavailable

Thanks. Worked for me. 6/1/2010 7:42 PM | steve

# re: MSDTC on server 'servername' is unavailable

thanks, it works. 6/18/2010 3:56 PM | priti

# re: MSDTC on server 'servername' is unavailable

thanks its working 4/14/2011 1:45 PM | shangar

# re: MSDTC on server 'servername' is unavailable

Thanks!!!!!!!!!!!!

It really works. 6/16/2011 10:08 AM | Sachin

# re: MSDTC on server 'servername' is unavailable

Thanks, This really saved my bacon :D 7/29/2011 4:32 PM | Richard

# re: MSDTC on server 'servername' is unavailable

Instantly resolved the issue. thanks. 8/3/2011 10:44 PM | Bor

# re: MSDTC on server 'servername' is unavailable

Worked like a charm, thanks! 9/1/2011 3:15 AM | roob

# re: MSDTC on server 'servername' is unavailable

Thanx a lot , Its working . 9/23/2011 12:04 PM | Narasimha

# re: MSDTC on server 'servername' is unavailable

That is awaresome!

It helped me. 11/8/2011 5:02 PM | AWEDA AKEEM

# re: MSDTC on server 'servername' is unavailable

Thank you this fixed my problem 3/8/2012 7:25 PM | Krista

# re: MSDTC on server 'servername' is unavailable

Thanx a lot, It's working fine for me 12/18/2012 1:57 PM | fahimeh

# re: MSDTC on server 'servername' is unavailable

Thank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu... 2/25/2014 5:40 PM | Ramesh gandhi

Post a comment





 

 

News

Employers
Soppa Group India
iSmart Panache Inc
R Systems Internationals Ltd
Technovate eSolutions Pvt Ltd
The contents of this blog are my personal opinion and do not represent in any way the view of my employer.
These postings are provided "AS IS" with no warranties, and confer no rights.

Google PR™ - Post your Page Rank with MyGooglePageRank.com

Archives

Post Categories

Image Galleries

Articles & Magazines

ASP.Net 2.0 Compilation

ASP.Net, Blogs I refer...

Atlas

Dost

Drivers and Software Download

Garhwal

Travel Domain

WSS and WebParts

Syndication: