Solved

Error when start MSDTC Service

Posted on 2014-11-11
21
119 Views
Last Modified: 2014-11-12
Dear EE,

I got error when i start MSDTC service.

Please see attached screenshot.

Thanks
11-12-2014-11-33-33-AM.jpg
0
Comment
Question by:Netsol-NOS
  • 11
  • 10
21 Comments
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40436866
Can't help much but tell you what the error message says.
Go and check for error in the EventLog.
0
 

Author Comment

by:Netsol-NOS
ID: 40436911
Dear Vitor,

EVERY THING WAS RUNNING FINE TILL

We have changed the permission of MSDTC from NETWORK SERVICES TO DOMAIN USER.

Please see attached file step by step what we have done and after that we have revert back but still MS DTC service is not running.



Thanks
MSDTC-Cluste-Issue.docx
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40436920
The MSDTC service must run under the NT AUTHORITY\NetworkService Windows account.
You can read all here in MSDN article.
0
 

Author Comment

by:Netsol-NOS
ID: 40436924
Yes you are right.

But now how to resolve this issue.

And guess what the problem is in PRODUCTION....:(
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40436970
Go and change back the service account and restart the MSDTC service. Isn't working anyway.
0
 

Author Comment

by:Netsol-NOS
ID: 40436996
I have done it and but now it is not working.
Please see screen shot.
123.docx
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40437009
Check the EventLog now. There must be some entries relating to the error.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40437011
Forgot to ask. You started the MSDTC by bringing it online in the cluster administration tool, right? If you didn't then you must do it there. Do not start the service in the Windows Services because it's a cluster.
0
 

Author Comment

by:Netsol-NOS
ID: 40437036
Dear Vitor,

Can you please connect GTM from below link to see the error by your self.

GTM LINK

https://global.gotomeeting.com/join/910156597

Special thanks for  your help.



Thanks
0
 

Author Comment

by:Netsol-NOS
ID: 40437084
I think the MSDTC disk is not working.

Can you please confirm how can we check the disk?
0
Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40437106
Try to move the MSDTC group to the other node and check if it works there.
0
 

Author Comment

by:Netsol-NOS
ID: 40437155
Not woking even then.

Can we make another MSDTC service over the existing one.

Like we have old one

MSDTC 1

Can we create new one

MSDTC 2 with new HDD partition ?

Can you please confirm this.
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40437164
Sure. Just delete the problematic one before so SQL Server won't try to use it.
0
 

Author Comment

by:Netsol-NOS
ID: 40437172
Special thanks.

1) Did we need to close SQL cluster ?
2) Did we need to close secondry server shut down ?
    2a) while  working new MSDTC service on primary server ?

3) After creating new MSDTC service do we need to VALIDATE SQL cluster with the new MSDTC service for synchronization ?

4) DID SQL CLUSTER SURVIVE when NEW MSDTC service will create ?

Thanks
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40437186
If you create an own group to MSDTC service you won't need to worry with SQL Server, since won't affect it.

After creating the new MSDTC you just need to validate if it works on both nodes and then do a test with your T-SQL code. Isn't expected any downtime for SQL Server or machines.
0
 

Author Comment

by:Netsol-NOS
ID: 40437195
Special thanks Vitor so kind of you.

Let me do this in 30 minutes.
0
 

Author Comment

by:Netsol-NOS
ID: 40437310
one out of way questions why we need MSDTC service / partition / cluster perticular for SQL cluster ?
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40437326
You need a MSDTC for handling Distributed Transactions. Isn't necessary to be clustered. You can install a local MSDTC in each node. Will also work.
0
 

Author Comment

by:Netsol-NOS
ID: 40437384
Dear Vitor,

Problem resolved .

Add 2 GB MSDTC another partition in SAN.
Make another MSDTC service.

I need to thank you specially for your dedicated support.

Please email me at adeel.imtiaz@netsoltech.com so that i can get your email address.

Thanks
0
 

Author Closing Comment

by:Netsol-NOS
ID: 40437389
Dear EE,

Mr Vitor provide excellent support to us over the MSDTC service.

Dear Visitors,

Mr. Vitor provide solution.  please read all communication so that you can get the right path.

Thanks
NetSol-NOS
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40437447
I'm glad that I could help you resolve this issue.
Kind regards.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now