Distributed transaction

I tri do start distribute transaction from a Server sql 2005, and other 2
server SQL 2000. I starto MSDTC service, the 2 server 2000 are connetcetd
true Linked Server from the SQL 2005 with SQLNCLI provider.
When i start the transaction and update a table on my first remote server
SQL server 2000 i get this error:
Server: messgae 7391, level 16, state 2, row 6
The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "SQL-SERVER2" was unable to begin a distributed transaction.
OLE DB provider "SQLNCLI" for linked server "SQL-SERVER2" returned message
"The transaction coordinator has disabled the support for remote/network
transaction".
(Sorry but i translate the message error from italian)
If i update the remote server qithout transaction i've got no problem. Works
perfectly.
Someone can help me? How can i solve this problem?
ThanksIf you're sure MSDTC is enabled and running on all your computers then I
would guess there is a firewall blocking the connection in one of the
machines.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"checcouno" <checcouno@.discussions.microsoft.com> wrote in message
news:53CAD34E-4F66-4D30-825B-FB59FACB6D22@.microsoft.com...
>I tri do start distribute transaction from a Server sql 2005, and other 2
> server SQL 2000. I starto MSDTC service, the 2 server 2000 are connetcetd
> true Linked Server from the SQL 2005 with SQLNCLI provider.
> When i start the transaction and update a table on my first remote server
> SQL server 2000 i get this error:
> Server: messgae 7391, level 16, state 2, row 6
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "SQL-SERVER2" was unable to begin a distributed transaction.
> OLE DB provider "SQLNCLI" for linked server "SQL-SERVER2" returned message
> "The transaction coordinator has disabled the support for remote/network
> transaction".
> (Sorry but i translate the message error from italian)
> If i update the remote server qithout transaction i've got no problem.
> Works
> perfectly.
> Someone can help me? How can i solve this problem?
> Thanks|||Could be a user's permission problem? And how i should configure the DTC
service and MSSQLSERVER service? What kinf of users these services sholud us
e
to run?
My configuration:
My local pc with WINXP SP2 (firewall disabled) and SQL Server 2005 with
MYLOCALDB and one linked server on a Server 2000 sp4 and SQL SERVER 200 sp2.
On both is running and enabled MSDTC, MSSQLSERVER and SQLSERVERAGENT and bot
h
the machine on the same domain.If i try to update a table on the remote
linked server the updata success. If i start a transaction and update the
remote table i've got this error:
OLE DB provider "SQLNCLI" for linked server "SQL-SERVER2" returned message
"The transaction coordinator has disabled its support for remote
transaction/network ".
Thanks
"Roger Wolter[MSFT]" wrote:

> If you're sure MSDTC is enabled and running on all your computers then I
> would guess there is a firewall blocking the connection in one of the
> machines.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "checcouno" <checcouno@.discussions.microsoft.com> wrote in message
> news:53CAD34E-4F66-4D30-825B-FB59FACB6D22@.microsoft.com...
>
>