|
| I am running distributed transactions via linked servers. All the SQL servers
involved are on SQL Server 2000 and on Window 2000 professional.
I am receiving distributed transaction failure error messages when trying to
run distributed queries. The error message is
------------------------------------------------------------------------------------------------
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
does not support distributed transactions.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::Jo
inTransaction returned 0x8004d00a].
------------------------------------------------------------------------------------------------
The DTC service is running on all machines.
I am not running loopback servers.
I am able to ping both ways across the two machines in concern.
There is no firewall between the two servers.
The SQL Servers are not set up in a cluster.
The @@SERVERNAME returns the correct servernames on both servers.
A distributed query directly linking to the remote tables work fine. I am
only receiving the error when trying to run a remote stored procedure.
An example piece of code that fails is:
-----------------------------------------------------------
drop table #dbs
go
create table #dbs(
DATABASE_NAME varchar(30) ,
DATABASE_SIZE int ,
REMARKS varchar(500)
)
go
insert into #dbs(
DATABASE_NAME ,
DATABASE_SIZE ,
REMARKS)
exec ('
exec "<Remote Server>".master.dbo.sp_databases
')
-----------------------------------------------------------
The problem is not related to the stored procedure, it fails which ever
stored procedure I use.
|
|