Geeks With Blogs

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

Narendra Tiwari

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

Posted on Monday, October 9, 2006 11:54 AM | Back to top


Comments on this post: MSDTC on server 'servername' is unavailable

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
I already started the service but the problem is still existing
Left by Roger on Feb 13, 2007 5:57 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...

Roger, Sometimes it requires the restart of machine, pls try with restarting your database server.
Left by Narendra Tiwari on Feb 28, 2007 9:14 AM

# re: MSDTC on server 'servername' is unavailable (Solution)
Requesting Gravatar...
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'
Left by Moslim on Apr 24, 2007 5:23 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...

Thanks

I got the solution by your comments

Gautam Jain
Left by Gautam Jain on Oct 30, 2007 2:05 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks Moslim!
After much research this seemed to solve the problem.

/gustav
Left by Gustav Brock on Feb 10, 2008 10:46 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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.
Left by Eric on Mar 04, 2008 8:10 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank very much, it have been very usefull for me..
Left by Murat on May 05, 2008 11:44 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks Dude!
I am very helpful to you.
It resolved my big problem.

Cheers :-)
Left by Sanjeev on May 28, 2008 9:59 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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?
Left by oryzana on Jun 30, 2008 11:40 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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
Left by Brij Mohan on Sep 09, 2008 8:04 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
thx too much!
Left by nix on Nov 06, 2008 12:46 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks for your answer, It is working fine
Left by murali on Jan 21, 2009 12:44 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks a Lot...Your help is worth
Left by Nilesh on Feb 02, 2009 11:47 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Perfect!! My boss ran over in a panic and good old google tech support fixed the issue :o)
Left by Ross Pinnuck on Feb 26, 2009 10:19 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Great tip. Thanks!
Left by Marc on Mar 10, 2009 6:09 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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' ?? :)
Left by Shuwi on Mar 25, 2009 7:10 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Run the MSDTC server under the Network Service account
Left by Ian on Mar 30, 2009 9:41 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank you very much budy..
article left by "Moslim" on Apr 24, 2007 5:23 AM ,it helped me today...thanks a lot..

Left by Shakti on Apr 03, 2009 12:52 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Dude it worked !
Thanks !
Left by Hemal on May 11, 2009 10:38 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Sweet action. I am yet another satisfied customer.
Left by flyfishr on Jun 30, 2009 1:11 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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..! :)
Left by Bilal Haider on Jul 19, 2009 6:55 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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.
Left by Marcelo on Aug 07, 2009 10:40 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Very useful, just had this problem as I have ventured into the world of Transactions and LINQ

:)
Andi
Zero7Web
Left by Andi G on Aug 11, 2009 4:48 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank You very much
for such a nice Help
All the best
Left by Nushrat Ali Tyagi on Aug 19, 2009 8:42 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank's u so much Moslem and Narendra Tiwari..
THanks for sharing
Left by Adnan on Aug 24, 2009 8:12 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank you very much, it worked for me!
Left by Puja on Sep 25, 2009 1:10 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks very much it is really good.
Left by susheel on Oct 01, 2009 4:33 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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.
Left by Ashutosh on Nov 06, 2009 2:57 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks a lot for your help mate, It was very helpful, now I can continue developing.
Left by Reedyseth on Nov 30, 2009 6:25 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks a lot!!!
Left by Daniel Makiyama on Dec 14, 2009 6:46 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
hey Man, this is not working...I dont know what is wrong!
but Thanks a lot fo ryour insights.!
Left by MK on Dec 17, 2009 11:44 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
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.
Left by Syed on Dec 21, 2009 12:02 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks a lot! You're a big help..
Left by Egman O. Sanit on Jan 07, 2010 7:14 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks A lot1 You are a great Help
Left by Krishna on Apr 20, 2010 3:58 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks so much.
Left by tano carridi on Apr 21, 2010 12:48 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank you very much! It worked well.
Left by HanNguyen on May 14, 2010 10:03 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks for the solution. It's working fine for me.
Left by A PATEL on Jun 01, 2010 12:02 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks. Worked for me.
Left by steve on Jun 01, 2010 7:42 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
thanks, it works.
Left by priti on Jun 18, 2010 3:56 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
thanks its working
Left by shangar on Apr 14, 2011 1:45 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks!!!!!!!!!!!!

It really works.
Left by Sachin on Jun 16, 2011 10:08 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks, This really saved my bacon :D
Left by Richard on Jul 29, 2011 4:32 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Instantly resolved the issue. thanks.
Left by Bor on Aug 03, 2011 10:44 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Worked like a charm, thanks!
Left by roob on Sep 01, 2011 3:15 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanx a lot , Its working .
Left by Narasimha on Sep 23, 2011 12:04 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
That is awaresome!

It helped me.
Left by AWEDA AKEEM on Nov 08, 2011 5:02 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank you this fixed my problem
Left by Krista on Mar 08, 2012 7:25 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanx a lot, It's working fine for me
Left by fahimeh on Dec 18, 2012 1:57 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu...
Left by Ramesh gandhi on Feb 25, 2014 5:40 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Thanks :)
Left by Rohit on May 30, 2014 2:55 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
just type services.msc new page will be opend in that select distributed Transaction coordinator then start that
Left by chandra on Jun 05, 2014 1:04 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Hi, I have the same issue, but when i make all the changes, it still not working:
Msg 7391, Level 16, State 2, Line 2
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "lhserver" was unable to begin a distributed transaction.

what can i do to solve it? It is an emergency!!!
Left by Alex on Dec 24, 2014 1:02 AM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
si efectivaente funciono.
Left by clamar on Jan 16, 2015 5:36 PM

# re: MSDTC on server 'servername' is unavailable
Requesting Gravatar...
Followd all steps still not working and giveing same error. Any further insights?
Left by Farhan on Apr 18, 2015 8:46 PM

Your comment:
 (will show your gravatar)


Copyright © Narendra Tiwari | Powered by: GeeksWithBlogs.net | Join free