Error when start MSDTC Service

Dear EE,

I got error when i start MSDTC service.

Please see attached screenshot.

Thanks
11-12-2014-11-33-33-AM.jpg
Netsol-NOSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Can't help much but tell you what the error message says.
Go and check for error in the EventLog.
0
Netsol-NOSAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
The MSDTC service must run under the NT AUTHORITY\NetworkService Windows account.
You can read all here in MSDN article.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Netsol-NOSAuthor Commented:
Yes you are right.

But now how to resolve this issue.

And guess what the problem is in PRODUCTION....:(
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Go and change back the service account and restart the MSDTC service. Isn't working anyway.
0
Netsol-NOSAuthor Commented:
I have done it and but now it is not working.
Please see screen shot.
123.docx
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check the EventLog now. There must be some entries relating to the error.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
Netsol-NOSAuthor Commented:
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
Netsol-NOSAuthor Commented:
I think the MSDTC disk is not working.

Can you please confirm how can we check the disk?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Try to move the MSDTC group to the other node and check if it works there.
0
Netsol-NOSAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sure. Just delete the problematic one before so SQL Server won't try to use it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Netsol-NOSAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
Netsol-NOSAuthor Commented:
Special thanks Vitor so kind of you.

Let me do this in 30 minutes.
0
Netsol-NOSAuthor Commented:
one out of way questions why we need MSDTC service / partition / cluster perticular for SQL cluster ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
Netsol-NOSAuthor Commented:
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
Netsol-NOSAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm glad that I could help you resolve this issue.
Kind regards.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.