Rob Cooper wrote:
> Hi,
>
> I have the following setup
>
> 1x SQL2005 server running in 80 compatibility mode which is the publisher
> and distributor to 5x SQL2005 push subscription servers.
>
> Originally the publisher was listening on port 1433 (std SQL port) the port
> was changed to 4449 as another server DTSs data to the publisher for
> distribution and it could not connect.
>
> No transactions are distributed.
>
> The Publisher to Distributor says there are no replicated transactions
> available even though tables have changed in the publisher article
>
> The Distributor to Subscriber says there are no replicated transactions
> available, initializing and TCP Provider : An existing connection was
> forcible closed by remote host
>
> I can connect to each subscriber using SQL Management Studio and vis versa.
>
> Any help will be appreciated
>
> Rob
>
>