Re: Help with MSDTC settings
- From: "Ryan Sokolowski [MVP]" <ryan@xxxxxxxxxxxxxxxxx>
- Date: Wed, 30 May 2007 13:34:26 -0700
It's very likely...MS DTC must be installed as a clustered resource to
operate properly on a cluster...COMCLUST is the command you're probably
looking for here...did you ever run this originally to set up the MS DTC
resource on the cluster? If not, you need to...
On both nodes, stop the MSDTC service.
To do this, type the following command at a command prompt, and then press
ENTER:
net stop msdtc
Verify that a message is displayed that indicates that the MSDTC service was
stopped successfully.
On both nodes, remove MSDTC. To do this, type the following command at a
command prompt, and then press ENTER:
msdtc -uninstall
On both nodes, verify that the Distributed Transaction Coordinator service
was removed from the Services snap-in. To start the Services snap-in, click
Start, click Run, type services.msc, and then click OK.
Install MSDTC as a clustered resource on both the active node and the
passive node. First, install MSDTC on the active node. Then, install MSDTC
on the passive node. To do this, follow these steps: a. On the active node,
type the following command at a command prompt, and then press ENTER:
comclust
After the COM Cluster Wizard (Comclust.exe) has finished running, the
program returns you to the command prompt. Do not close the command prompt.
On the passive node, type the following command at a command prompt, and
then press ENTER:
comclust
After the COM Cluster Wizard has finished running, the program returns you
to the command prompt.
Close the command prompt on the passive node. You must close the command
prompt on the passive node first.
Close the command prompt on the active node.
For additional information about how to install MSDTC as a clustered
resource in a Windows 2000 environment, click the following article number
to view the article in the Microsoft Knowledge Base:
290624 How to configure MSDTC in a Windows 2000 cluster environment
Verify that no errors messages appear and that the MSDTC service is
installed. Also, verify that the MSDTC resource is added to the cluster
group.
Try to look here as well:
Click Start, point to Programs, point to Administrative Tools, and then
click Component Services. In the Component Services snap-in, expand
Component Services, expand Computers, expand My Computer, and then expand
COM+ Applications
--
Ryan Sokolowski
MVP - Windows Server - Clustering
MCSE, CCNA, CCDA, BCFP
This posting is provided "AS IS" with no warranties, and confers no rights.
"Curtis" <curtmorrison@xxxxxxxxxxx> wrote in message
news:1180550151.564837.231880@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 30, 1:10 pm, "Ryan Sokolowski [MVP]" <r...@xxxxxxxxxxxxxxxxx>
wrote:
While you were pretty specific about most of your configuration, you
didn't
provide a specific error message or code. :(
Thanks for your response Ryan. The specific error code is generated in
SQL Server Query Analyzer:
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI"
for linked server "BXSQLCLUSTER" was unable to begin a distributed
transaction.
The DTC is running on the target server and there aren't any event log
messages related to it (at least none that I have been able to find).
I'm looking for MSDTC settings on this server that have to do with
allowing inbound and outbound connections, as well as other security
related settings. I checked for these under component services, as
well as the cluster adminsitrator, but unable to find anything. Since
this is a Win2K Server, where would I go to find the equivalent of
Windows 2003 Server's "Add/Remove Windows Components > Application
Server > Enable network DTC access" ? Since this is all I had to do on
my 2003 servers, I'm thinking a similar setting might work on 2k, but
unable to find any documentation related to it. I've been looking
through MS documenation related to this for over a week and starting
to wonder if the problem exists because this is a clustered
environment. Do you have any thoughts on this?
- Curtis
.
- References:
- Help with MSDTC settings
- From: Curtis
- Re: Help with MSDTC settings
- From: Ryan Sokolowski [MVP]
- Re: Help with MSDTC settings
- From: Curtis
- Help with MSDTC settings
- Prev by Date: Re: Cluster Group failover and preferred nodes
- Next by Date: Re: DHCP Server migration to a 64 bit Clustered Server
- Previous by thread: Re: Help with MSDTC settings
- Next by thread: Cluster Group failover and preferred nodes
- Index(es):
Relevant Pages
|
