Distributed transaction

microsoft.public.sqlserver.programming

6 Apr 2006 2:01 PM

checcouno

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 use
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 both
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

Show quote

"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" <checco***@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
>
>
>