"DavidC" <DavidC@discussions.microsoft.com> wrote in message
news:827BD3C9-F33C-47CB-A97C-B15F261593CE@microsoft.com...
> Hi!
>
> We are attempting to replicate a SQL 2k (Win 2k) server with another
server
> of a very similar spec but the whole process has been a disaster...
>
> Firstly merge replication pushing the subsricption seems to constantly
have
> a status of "deactivated"!
>
> If we use pull subscription, the subscriber cannot contact the publisher.
>
> On a seperate matter I am unable to send emails via DTS from the
publisher -
> the error displayed is "cannot load MAPI interface layer for DTS. Please
make
> sure that SEMMAP.DLL is installed".
>
> Short of formatting the server, as now I am paranoid that the SQL
publisher
> is corrupt, does anyone know of any things to use to check on the "health"
of
> the SQL server and any quick checkpoints for replication?
>
> TIA
>
> David

"Hilary Cotter" wrote:

> The deactivated message means your snapshot has not been run. Expand the
> replication folder, agents folder, snapshot agent, location your
> publication, right click, select agent properties, make the job owner sa,
> and then right click to start your job.
>
> --
> 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
> "DavidC" <DavidC@discussions.microsoft.com> wrote in message
> news:827BD3C9-F33C-47CB-A97C-B15F261593CE@microsoft.com...
> > Hi!
> >
> > We are attempting to replicate a SQL 2k (Win 2k) server with another
> server
> > of a very similar spec but the whole process has been a disaster...
> >
> > Firstly merge replication pushing the subsricption seems to constantly
> have
> > a status of "deactivated"!
> >
> > If we use pull subscription, the subscriber cannot contact the publisher.
> >
> > On a seperate matter I am unable to send emails via DTS from the
> publisher -
> > the error displayed is "cannot load MAPI interface layer for DTS. Please
> make
> > sure that SEMMAP.DLL is installed".
> >
> > Short of formatting the server, as now I am paranoid that the SQL
> publisher
> > is corrupt, does anyone know of any things to use to check on the "health"
> of
> > the SQL server and any quick checkpoints for replication?
> >
> > TIA
> >
> > David
>
>