Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL server 2005 Distributed Transaction Coordinator service
Posted on 2012-12-20
Dear all,
Right now some of our Windows 2003 server is running DTC service I expected, please see attached.
But what I found out is not all of the SQL group include the DTC resource, is that right that all SQL server instance should have this DTC resource ? or just one SQL group in the cluster need that ?
from my understanding, the installation of cluster will do this for us, we don't have to worry about that, right?
if we need to install it, do we need to restart the SQL instance/service after that ?
DTC.jpg
Right now some of our Windows 2003 server is running DTC service I expected, please see attached.
But what I found out is not all of the SQL group include the DTC resource, is that right that all SQL server instance should have this DTC resource ? or just one SQL group in the cluster need that ?
from my understanding, the installation of cluster will do this for us, we don't have to worry about that, right?
if we need to install it, do we need to restart the SQL instance/service after that ?
DTC.jpg
[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
-
4
2
2- +1
10 Comments
Yes it should be there on all Servers.
From where you are executing command to different SQL server instance
From where you are executing command to different SQL server instance
Active 6 days ago
PatelAlpesh,
so if I found it is not existing on any SQL instance group ,the nI have to add that myself?
"From where you are executing command to different SQL server instance " but it seems needs the links server to be created also ?
so if I found it is not existing on any SQL instance group ,the nI have to add that myself?
"From where you are executing command to different SQL server instance " but it seems needs the links server to be created also ?
Active 6 days ago
"It will be there by default. "
so if it is not there then I have to enable it, any restart of the SQL instance?
so if it is not there then I have to enable it, any restart of the SQL instance?
Active 4 days ago
unless you have problems: you are good: there is 1 MSDTC resource for 2003 cluster all nodes
just in case:
How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster
http://support.microsoft.com/?kbid=301600
just in case:
How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster
http://support.microsoft.com/?kbid=301600
Active 2 days ago
Agree...
MSDTC when installed on a cluster becomes clustered. Only a single instance is used on a cluster.
On a non-clustered environment, only those machines involved in a distributed transaction need to have it enabled.
By default (from 2003 SP1 on) it is disabled to protect network security.
It is an operating system service (not just for SQL server) and is configured / started / managed seperately. It uses RPC on ports over 1024 and will use as many as needed to handle the requests - you can limit and manage, but generally best to leave it to manage or respond to the workloads.
A lot of time, the only reason to use it (as far as DBA's are concerned) is because of SQL Server and so it is often mistaken as a SQL Server utility.
You dont have to stop or start SQL server unless there are permissions issues that have to be resolved for the SQL Server service account (and even then there are often other ways like sdset etc). There are a couple of DB settings like RPC that might need to be set, but that is a simple config and doesnt require restarts.
MSDTC when installed on a cluster becomes clustered. Only a single instance is used on a cluster.
On a non-clustered environment, only those machines involved in a distributed transaction need to have it enabled.
By default (from 2003 SP1 on) it is disabled to protect network security.
It is an operating system service (not just for SQL server) and is configured / started / managed seperately. It uses RPC on ports over 1024 and will use as many as needed to handle the requests - you can limit and manage, but generally best to leave it to manage or respond to the workloads.
A lot of time, the only reason to use it (as far as DBA's are concerned) is because of SQL Server and so it is often mistaken as a SQL Server utility.
You dont have to stop or start SQL server unless there are permissions issues that have to be resolved for the SQL Server service account (and even then there are often other ways like sdset etc). There are a couple of DB settings like RPC that might need to be set, but that is a simple config and doesnt require restarts.
Active 6 days ago
mark_wills,
Thansk a lot. yeah, once people see "transaction", they will consider that this is a SQL resouce.
"Only a single instance is used on a cluster"
So this means if there are 2 x SQL instance in the cluster group, then ony one can own that.
Thansk a lot. yeah, once people see "transaction", they will consider that this is a SQL resouce.
"Only a single instance is used on a cluster"
So this means if there are 2 x SQL instance in the cluster group, then ony one can own that.
Active 2 days ago
well, there will be one instance og msdtc and that service will be started / owned by an account.
It is similar to SQL Server Service in that regard. It gets fired up under an account, then whatever resources (or people) need to use it, then they consume the service as required.
SQL Server doesnt necessarily "own the service", but SQL Server does place the distributed transaction request (or the transaction gets escalated because it engages another server).
Think of it as a queue manager for RPC... One server says to another "I need stuff" and the DTC manages that request checking to see if everything is OK (like permissions).
It is similar to SQL Server Service in that regard. It gets fired up under an account, then whatever resources (or people) need to use it, then they consume the service as required.
SQL Server doesnt necessarily "own the service", but SQL Server does place the distributed transaction request (or the transaction gets escalated because it engages another server).
Think of it as a queue manager for RPC... One server says to another "I need stuff" and the DTC manages that request checking to see if everything is OK (like permissions).
Featured Post
Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Why is this different from all of the other step by step guides? Â Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
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…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 11 hours left to enroll
632 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.