Re: transaction replication, MSDTC, 1722 - (The RPC server is unav

I really din't understand what you just wrote in your reply about the IIRC
this error is erroneous. Also, I can't generate transactions on the
subscriber because the database being replicated from DEVFRANCIS ins't
appearing on ECTESTING.

I'm thinking the error has something to do a process(either SQLSERVERAGENT
or MSSQLSERVER) not being able to start msdtc.exe on either DEVFRANCIS or
ECTESTING. What permissions are required, and how do you set them for the
publisher/distributer (DEVFRANCIS) running windows XP, and the subscriber
(ECTESTING) running windows 2000 server.

I've been looking around and found a utility called dcomcnfg to set the
permissions of msdtc but the GUI for the utility is very different if it is
run from XP or windows 2000 server. Would this approache work?

Any advice or suggestions would be appreciated thank you.

Francis


"Hilary Cotter" wrote:

> IIRC this error is erroneous. Try to generate transactions on the subscriber
> and see if they commit. If they do so, replication is working.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Francis Reed" <Francis Reed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:676991CD-E4C6-4C79-A99D-A8AF2539362A@xxxxxxxxxxxxxxxx
> > Hi
> >
> > I'm setting up transactional replication between a windows XP
> > machine(DEVFRANCIS), and a windows 2000 server machine(ECTESTING). I've
> setup
> > the publisher and distributer on the XP machine, and wish to execute the
> push
> > new subscriptions wizard from the XP machine to the windows 2000 machine.
> At
> > the start required services screen it displays
> >
> > SQLServerAgent(on DEVFRANCIS) Running
> > MSDTC (on DEVFRANCIS) Running
> > MSDTC (on ECTESTING) Unknown
> >
> > Also, before the push wizard finished, and error appears displaying
> >
> > Subscriptions were created successfully at the following Subscribers:
> > ECTESTING
> >
> >
> > SQL Server Enterprise Manager could not start the service 'MSDTC' on
> server
> > 'ECTESTING'.
> >
> > 1722 - (The RPC server is unavailable)
> >
> >
> > Basically, I would like the push operation to work, and my transactions to
> > occurs. I would really appreciate it if someone would offer a solution, or
> > give any advice that can solve this problem.
> >
> > Thank you
> > Francis
> >
> >
>
>
>
.

Relevant Pages

  • Re: Merge and transactional replication
    ... For server to server replication, ... mean most transactions originate on the server, ... Your publisher and subscriber will ...
    (microsoft.public.sqlserver.replication)
  • Best Practice & Other
    ... Replication Type: Transactional ... Server 2 did have SQL2005 installed. ... If we deleted these transactions from the subscriber ...
    (microsoft.public.sqlserver.replication)
  • Re: System degrades after 49.71 days
    ... we reboot EVERY M.S. server in the place. ... > exact same type of transactions without problem prior to the 49.71 days. ... > running on a standard desktop style server under Windows NT 4 Server. ...
    (microsoft.public.sqlserver.server)
  • Component COM+ problem in Windows Server 2003
    ... The installed components in the Proxy Server. ... not create transactions, they write correctly, but they do not perform ... In the clients Pc's we have XP and the server is Windows 2003. ...
    (microsoft.public.sqlserver.security)
  • SQL 2000 32-bit on Window 2003 x64 Cluster server & MSDTC distributed transaction
    ... transaction when you have a SQL Server 2000 virtual server in a Windows ... We make heavy use of MSDTC distributed transactions. ... transactions on Window 2003 x64 Cluster server? ...
    (microsoft.public.sqlserver.clustering)