Saturday, February 25, 2012

MSDTC Fails

SQL Server 2000 servers are running on two different servers on Windows 2003
.
One is part of domain but the other one is not part of any domain.
MSDTC failed to communicate with error msg 7391.
Followed the instruction as mentioned in KB-329332, but still failed.
Followed the instruction as mentioned in KB-827805 but failed too. In
KB-827805, it only tells to add the registry with value name
"TurnOffRpcSecurity". Is it the only thing to do ?
OR both server must be run under the same domain.Can any SQL Server MVP or Microsoft technical support persons help ?
"Johnny" wrote:

> SQL Server 2000 servers are running on two different servers on Windows 20
03.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||Have you enabled Network COM+ and DTC access under application server on the
add\remove windows components portion of add\remove programs?
nivek
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> SQL Server 2000 servers are running on two different servers on Windows
> 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||I also went through the KB-816701. The components Network COM+ and Network
DTC access are already enable by default.
When I put the two servers to the same domain, MSDTC works beautifully. But
why Windows 2003 has this restriction.
"nivek" wrote:

> Have you enabled Network COM+ and DTC access under application server on t
he
> add\remove windows components portion of add\remove programs?
> --
> nivek
>
>
> "Johnny" <Johnny@.discussions.microsoft.com> wrote in message
> news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
>
>

No comments:

Post a Comment