Solved

MSDCT 2 - Causing Server To Restart

Posted on 2011-09-20
19
417 Views
Last Modified: 2012-05-12
Hello Experts,

I have a Windows 2008 Server running a small web based application. The database is Micorsoft SQL Server 2008.

Occasionally, the server has been restarting and having checked the logs, it seems the last even to occur is MSDCT opening.

I have no idea what it is and there is nothing out of the ordinary happening prior to this applcation starting.

----------------------------------------------------------------------------
MSDTC started with the following settings:

 Security Configuration (OFF = 0 and ON = 1):
 Allow Remote Administrator = 0,
 Network Clients = 0,
 Trasaction Manager Communication:
 Allow Inbound Transactions = 0,
 Allow Outbound Transactions = 0,
 Transaction Internet Protocol (TIP) = 0,
  Enable XA Transactions = 0,
  MSDTC Communications Security = Mutual Authentication Required,
 Account = NT AUTHORITY\NetworkService,
  Firewall Exclusion Detected = 0

 Transaction Bridge Installed = 0
 Filtering Duplicate Events = 1
----------------------------------------------------------------------

Any help would be much appreciated on what this software is and in particular if and how i can stop it initiating.

Thank you,


D.
0
Comment
Question by:NewFourWalls
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 9
19 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36567040
Do you have a SQL Cluster setup?
0
 

Author Comment

by:NewFourWalls
ID: 36567055
TO be honest, I have very little experience dealing with Windows servers, I am not sure what an SQL Cluster is. I certainly haven't set one up myself. How can I check?
0
 
LVL 8

Accepted Solution

by:
venk_r earned 500 total points
ID: 36567072
Go to control panel ->Administrative Tools
See if you can find cluster tool in it

Venkat
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:NewFourWalls
ID: 36567211
Hi,

No, there is noting in that folder or the sub folder terminal services mentioning cluster.

Thanks.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36567450
Click Administrative tools->Component Services
Expand Computers->My computers->Distribution Transaction Cordinator
right click local DTC on your right window and select the properties.Click the security tab and send me the snapshot of the settings
0
 

Author Comment

by:NewFourWalls
ID: 36567961
Hi, I have attached the snapshot of the properties box as requested. Thank you for your help. DTC > Securty
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36568004
Can you send me the whole log during that timeframe if possible.?
0
 

Author Comment

by:NewFourWalls
ID: 36568156
I don't have a problem sending you it, but how do i extract it?
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36568181
Go to the event viewer  
Click Application under Windows LOgs. To you right side  there is an option called Filter current log.Select that option and provide the time window in it.Once it shows the filtered log  right click on application and select save filtered log as option.Then save it to a .evtx file and send it to me.
0
 

Author Comment

by:NewFourWalls
ID: 36568198
Do you have an email address or way of sending you a file as it has some ftp and ip details in there which i would rather not make public :)
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36568204
send it to
venkat.ramalingam@gmail.com
0
 

Author Comment

by:NewFourWalls
ID: 36568330
Hi, I have just emailed you the log.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36568341
ok .will take a look.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36568510
Sorry,didnt get much input from the event log .

MSDTC service is required only if you are calling remote stored procs or connecting to other SQL server instances in network through linked servers and other oledb data sources. If you are not doing those, then you can ignore these warning messages.

Do you see the server restarting or rebooting when these messages occur?
0
 

Author Comment

by:NewFourWalls
ID: 36569312
No, the server is hosted through a company. It is located on their site.

I start to recieve MS SQL timeout errors for a few minutes leading up to a restart.

I am connecting to a couple of remote MySQL databases to grab information from the tables, but that generally happens multiple times per day, without errors.

That's all I know unfortunately.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36569331
Sorry I wasnt able to help you.Hopefully someone else should be able to help you.
0
 

Author Comment

by:NewFourWalls
ID: 36572492
No problem, thanks for your help.
0
 

Author Closing Comment

by:NewFourWalls
ID: 36718246
Thanks.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36718614
Thanks NewFourWalls.You've been generous.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

738 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