Re: win2k/sql2k to win2k3/sql2k5 dtc problems
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Mon, 23 Jan 2006 17:18:31 -0700
Thanks for posting the fix! Hope everything else runs well
from the upgrade.
-Sue
On Mon, 23 Jan 2006 18:54:26 -0500, "titanic panic" <jcy1971
(at) gmail dawt calm> wrote:
>OK, had to reset security with this:
>
>http://support.microsoft.com/?kbid=899191#XSLTH4233121123120121120120
>
>Thanks.
>
>panic
>
>
>"titanic panic" <jcy1971 (at) gmail dawt calm> wrote in message
>news:OcKcnQHIGHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
>> Thanks,
>>
>> The win2k/sql2k server's DTC service runs as "LocalSystem", the
>> win2k3/sql2k5 DTC service runs as "NT Authority\NetworkService".
>>
>> The win2k3/sql2k5 server used to be NT4/sql7 and was upgraded over the
>> weekend.
>>
>> Also RCP security has been turned off, and rpc ping and dtc ping both are
>> successful, however our application keeps coming back with "Communication
>> Link Failure".
>>
>> panic
>>
>>
>> "Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
>> news:3tgat1lccfb19vhin1roajrtd1oukfco8u@xxxxxxxxxx
>> > In addition to enabling DTC, you may want to check the
>> > security configuration as well:
>> > "XACT_E_NOENLIST" error message in DTC and SQL Server
>> > http://support.microsoft.com/?id=831425
>> >
>> > -Sue
>> >
>> > On Mon, 23 Jan 2006 13:56:40 -0500, titanic panic
>> > <jcy1971@googlemailservice> wrote:
>> >
>> > >We're having problems running triggers from a win2000/sql2000 server to
>> > >a win2003/sql2005 server and vice versa.
>> > >
>> > >enable network DTC access in add/remove windows components is enabled.
>> > >
>> > >What are the steps necessary to ensure that DTC is communicating
>> > >properly between these two servers?
>> > >
>> > >Thanks for any help,
>> > >
>> > >panic
>> >
>>
>>
>
.
- References:
- win2k/sql2k to win2k3/sql2k5 dtc problems
- From: titanic panic
- Re: win2k/sql2k to win2k3/sql2k5 dtc problems
- From: Sue Hoegemeier
- Re: win2k/sql2k to win2k3/sql2k5 dtc problems
- From: titanic panic
- Re: win2k/sql2k to win2k3/sql2k5 dtc problems
- From: titanic panic
- win2k/sql2k to win2k3/sql2k5 dtc problems
- Prev by Date: Re: win2k/sql2k to win2k3/sql2k5 dtc problems
- Next by Date: SSL info
- Previous by thread: Re: win2k/sql2k to win2k3/sql2k5 dtc problems
- Next by thread: 2005-Problem restoring database with encrypted columns to diff ser
- Index(es):