Can you go to your subscriber or another machine and register the publisher
"bjones" <bjones@discussions.microsoft.com> wrote in message
news:0F7D1163-6200-40AB-9BF6-5E00AA7DA8FF@microsoft.com...
> i did script it out because the gui would not allow me to set up the
> publication and distribution which is why i was thinking it was related to
> sysservers or something. i appear to have 4 distribution jobs and not sure
> which was is valid. is there supposed to be only one distribution job for
1
> publication other than the distribution/subscription cleanup jobs?
>
> "Hilary Cotter" wrote:
>
> > you should be able to find them in the management folder. It might be a
> > little hard to identify them - but the category should help.
> >
> > BTW - did you script out your publications and then re-rerun them. If
you
> > are not careful when editing your publication scripts and assigning new
> > agent names and publication name it can cause your jobs to disappear
when
> > you look in the agents folder.
> >
> > --
> > 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 > >
> > "bjones" <bjones@discussions.microsoft.com> wrote in message
> > news:F8437637-C2E3-42A0-B2EF-3158646F3D36@microsoft.com...
> > > The distribution and log agents seem to be down because they couldn't
> > connect
> > > to the subscriber. I am not sure how to check their status and restart
the
> > > agents without the monitor gui. any advise on how to do this?
> > >
> > > "bjones" wrote:
> > >
> > > > Hi Hilary
> > > >
> > > > I have the below and tried registring the distribution server.
However
> > > > nothing appears under the server when expanding the monitor.
> > > >
> > > > "Hilary Cotter" wrote:
> > > >
> > > > > No, do you have the show replication monitor group in Tools -
> > Replication?
> > > > >
> > > > > --
> > > > > 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 > > > > >
> > > > > "bjones" <bjones@discussions.microsoft.com> wrote in message
> > > > > news:94C95374-EDD5-40C9-AC80-FCBE95FA02EC@microsoft.com...
> > > > > > publication, distribution and subscription agents run on the
same
> > server.
> > > > > i
> > > > > > have tried reinstalling with the same result. is there a
sysservers
> > or
> > > > > some
> > > > > > other system related value which might be causing this to fail?
> > > > > >
> > > > > > "Hilary Cotter" wrote:
> > > > > >
> > > > > > > Do you have a remote distributor? It will show up there if
this is
> > the
> > > > > case.
> > > > > > > If not, something seems hosed. I would remove replication and
> > reinstall
> > > > > it.
> > > > > > > --
> > > > > > > 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 > > > > > > >
> > > > > > > "bjones" <bjones@discussions.microsoft.com> wrote in message
> > > > > > > news:131B5C87-9D38-42E6-9627-E4C8AF022C4F@microsoft.com...
> > > > > > > >i have setup replication on server mssql v7.0, but the
> > replication
> > > > > monitor
> > > > > > > > does not display. have also tried via tools ->
replication ->
> > show
> > > > > > > > replication monitor.But after selecting the server with the
> > > > > distribution
> > > > > > > > database, it does not expand any further to show the agents.
has
> > > > > anyone
> > > > > > > > seen
> > > > > > > > this before?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> >
> >
> >