asked on
SQL server 2005 Distributed Transaction Coordinator service
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
Microsoft Server OSMicrosoft SQL Server 2005Microsoft SQL Server 2008Microsoft SQL Server
Last Comment
marrowyung
ASKER
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 ?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
"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?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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).
ASKER
thanks.
From where you are executing command to different SQL server instance