Problem in Microsoft Distributed Transaction Coordinator (MS DTC) on CLuster SQL2000 Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Problem in Microsoft Distributed Transaction Coordinator (MS DTC) on CLuster SQL2000 Server

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-02 : 07:19:50

Hems writes "Dear All,

Please help me in resolving this problem.We have a One Cluster SQL2000 Server with SP3 & OS:W2K with SP3 and one remote server non cluster SQL2000 Server with SP3 & OS:W2K with SP3.I have below procedure in my cluster SQL2000 Server

Server Name: cmdat
Use Pubs
Go

CREATE trigger test1
on test
for insert,update
as
declare @id1 as int
select @id1=id1 from inserted
insert into [180.66.1.1].pubs.dbo.test(id1)values(@id1)
Go

insert into test(id1) value(1)
Go

After Executing this,We get below error message.

Error Message;
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.]

Note:180.66.1.1 is a IP of Remote SQL2000 Server
and cmdat is the Name of Cluster SQL200 Server.

Please help me on above problem"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources