Friday, February 17, 2012

distributed transaction w 2 servers in different domains

Setting up distributed transaction between 2 servers from the same Windows
domain is no problem,
but when I try to do it with 2 servers from different domains i get error:
Server: Msg 7391, Level 16, State 1, Line 9
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. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
Situation: both servers Windows 2000 Server SP4, SQL Server 2000 SP4
Updating data remotely works fine only when distributed transaction is not
used.
I believe that the problem is with security.
Should MSDTC and MSSQLServer start under some special accounts with special
rights?
Maybe the domains should trust one another?
Please help.
Tom.Hello Tom,
You may want to use dtcping to test dtc communication between servers and
make sure they are not blocked by firewalls
How to troubleshoot MS DTC firewall issues
http://support.microsoft.com/defaul...kb;EN-US;306843
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||That was it.
Name resolution did not funtion correctly in both directions.
THANK YOU VERY MUCH.
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:lEqqlwRiGHA.5608@.TK2MSFTNGXA01.phx.gbl...
> Hello Tom,
> You may want to use dtcping to test dtc communication between servers and
> make sure they are not blocked by firewalls
> How to troubleshoot MS DTC firewall issues
> http://support.microsoft.com/defaul...kb;EN-US;306843
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Welcome!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

No comments:

Post a Comment