MSDTC and Win2K3

We have Windows 2003 OS and SQL Server 2000. We are following the following
procedure, as it is an alternate of executing a distributed transaction.
Whenever we are tying to execute the following code
begin distributed transaction
SELECT COUNT(*) FROM OPENDATASOURCE('SQLOLEDB','Data Source=
serverip;UserID=username;Password=pwd' ).AACS.dbo.edbdata
commit tran
OR
begin distributed transaction
SELECT COUNT(*) FROM OPENDATASOURCE('SQLOLEDB','Data Source=
serverip;UserID=username;Password=pwd' ).MFDATA.dbo.tbl_login
rollback
In case we are trying to execute the similar code from any other server, it
works properly but in case of our test server we receive the following error
Server: Msg 7391, Level 16, State 1, Line 2
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. ]
We have tried using the settings given by microsoft but it did not work.
Hi
Did you check out:
http://msdn.microsoft.com/library/de...c72e00fc01.asp
and http://support.microsoft.com/kb/827805 ?
John
"Sandeep Gupta" wrote:

> We have Windows 2003 OS and SQL Server 2000. We are following the following
> procedure, as it is an alternate of executing a distributed transaction.
> Whenever we are tying to execute the following code
> begin distributed transaction
> SELECT COUNT(*) FROM OPENDATASOURCE('SQLOLEDB','Data Source=
> serverip;UserID=username;Password=pwd' ).AACS.dbo.edbdata
> commit tran
> OR
> begin distributed transaction
> SELECT COUNT(*) FROM OPENDATASOURCE('SQLOLEDB','Data Source=
> serverip;UserID=username;Password=pwd' ).MFDATA.dbo.tbl_login
> rollback
>
> In case we are trying to execute the similar code from any other server, it
> works properly but in case of our test server we receive the following error
> Server: Msg 7391, Level 16, State 1, Line 2
> 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. ]
> We have tried using the settings given by microsoft but it did not work.