Replication Error 14053

[keithmyers]

I am attempting to create a push subscription using snapshot replication on the publisher. When I try to finish the subscription, I receive the following error:
-------------
SQL Server Enterprise Manager encountered errors creating push subscriptions for the following Subscribers:

COMPUTERNAME: Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
The subscription could not be updated at this time.
The subscription could not be created.
-------------

I am running SQL 2k SP3.

Thanks
-Keith-

 

[JohnBates]

Keith, did you ever resolve this problem? I have the same situation with trying to configure Snapshot.

thanks, John

 

[JohnBates]

... this is what I found in another forum.

In the Master db, sp_replincrementlsn is missing.

Solution is to copy it from another install of SQL Server 2000.

Maybe this will help someone. There's certainly no help on the MS, MSDN site.

John


Here's the sp code:

create proc sp_replincrementlsn (
@xact_seqno binary(10) OUTPUT
)
as
declare @retcode int
/*
** Security Check, this proc is called by snapshot agent or sp_repladd(drop)column, against pub db as DBO
*/
exec @retcode = dbo.sp_MSreplcheck_publish
if @@ERROR <> 0 or @retcode <> 0
begin
return(1)
end

exec @retcode = dbo.sp_replincrementlsn_internal @xact_seqno OUTPUT
if @@ERROR <> 0 or @retcode <> 0
begin
return(1)
end

return 0

GO