Pull Subscription

I am setting up a pull subscription and I keep getting an error
message:
"SQL Server Enterprise Manger could not create a pull subscription to
publication 'XX'. Error 14053: Cannot load the DLL replincrementlsn
extended procedure, or one of the DLLs it references. ..."
Any suggestions on how to resolve this error. Thanks in advance.
Hi,
I feel that there is some installation issues. Did you install any service
packs recently whicgh didnt completed fully?Check for the procedures
sp_replincrementlsn and sp_replincrementlsn_internal (Extended proc) in
MASTER database.
If the procedures are not there then create it by scripting it out from some
other SQL servers and try
setting up the subscription again.
Thanks
Hari
MCDBA
"Scott" <scott@.jucovics.com> wrote in message
news:3fe08b2e.0406291147.18387555@.posting.google.c om...
> I am setting up a pull subscription and I keep getting an error
> message:
> "SQL Server Enterprise Manger could not create a pull subscription to
> publication 'XX'. Error 14053: Cannot load the DLL replincrementlsn
> extended procedure, or one of the DLLs it references. ..."
> Any suggestions on how to resolve this error. Thanks in advance.
|||Scott,
if you did a custom install, you need to have selected Replication Support.
If you have installed a service pack, check that it fully installed - have a
look at sqlsp.log file from the c:\windows directory this might shed some
light on any failed actions during the sp installation.
HTH,
Paul Ibison
|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:<uKJ#q6mXEHA.3612@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> Hi,
> I feel that there is some installation issues. Did you install any service
> packs recently whicgh didnt completed fully?Check for the procedures
> sp_replincrementlsn and sp_replincrementlsn_internal (Extended proc) in
> MASTER database.
> If the procedures are not there then create it by scripting it out from some
> other SQL servers and try
> setting up the subscription again.
> --
> Thanks
> Hari
> MCDBA
> "Scott" <scott@.jucovics.com> wrote in message
> news:3fe08b2e.0406291147.18387555@.posting.google.c om...
I tried to script out he sp_replincmentlsn and since it is an extended
stored procedure I'm not sure how? I tried various methods and when I
tried to create the extended stored proc manually, it said it is
"already an object in the database" even though I cannot see it under
the Master database. I do see "sp_replincrementlsn_internal", I'm
trying to rerun the SQL SERVER SP3 right now.