Re: SQL Server 7 and DTC

----- Original Message ----- 
From: "Ian Stocks" <[email protected]>
To: "AFJ" <[email protected]>; <[email protected]>
Sent: Thursday, February 10, 2005 10:39 PM
Subject: Re: [Zebedee-talk] SQL Server 7 and DTC


> ----- Original Message ----- 
> From: "AFJ" <[email protected]>
> To: <[email protected]>
> Sent: Thursday, February 10, 2005 8:22 PM
> Subject: [Zebedee-talk] SQL Server 7 and DTC
>
>
>> Hello
>>
>> Is anybody connecting SQL Server 7 machines with Zebedee to perform
>> distributed queries with MS DTC (distributed transaction 
>> coordinator) on a
>> WAN?
>>
>> I wonder if it's necessary to tunnel the ports used by MS DTC too, 
>> or just
>> the port used by SQL Server 7?
>
> I did briefly have transactional replication running over a couple 
> of zebedee links (need two links, as connections could be made from 
> either end). This was under NT4, I think it has got progressively 
> harder with W2K, XP and W2K3 server, and being able to listen on rpc 
> ports for localhost ip addresses. If you have a Unix/Linux box at 
> each end to do the zebedee bits it may be easier but I haven't tried 
> it.
>
> From what I remember you need to limit the ports that RPC will use 
> for connections :-
> http://www.pistonheads.co.uk/sales/detail.asp?i=36200&s=39

Hmm, that might just be the wrong link, try this one :-)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q154596

> A liberal sprinkling of Alias names to make SQL Server think the 
> machine that is running zebedee is the server at the other end of 
> the link.
>
> All that and 4 instances of zebedee.exe, 2 server, 2 client, 1 of 
> each at each end.
>
> I can dig out the config of zebedee I used if you think it would be 
> useful.
>
> Ian.
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real 
> users.
> Discover which products truly live up to the hype. Start reading 
> now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Zebedee-talk mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/zebedee-talk 



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click