Replication Question

Hi,
I'm getting the error below when executing:
sp_addsubscription.
Prior to this I have, added the pub with sp_addpublication followed by
sp_addpublication_snapshot followed by sp_grant_publication_access followed
by sp_addarticle.
SQLServer 2000 SP3 contains the Publication and the Distribution agent is
also on a 2000 server SP3. I have just installed a new server with SP4 which
is my intended subscriber... but I can't get past this error. I have other
replication evvironments setup and they run fine.
This is the error I'm receiving:
Server: Msg 14070, Level 16, State 1, Procedure sp_changesubstatus, Line 993
Could not update the distribution database subscription table. The
subscription status could not be changed.
Server: Msg 14057, Level 16, State 1, Procedure sp_addsubscription, Line 971
The subscription could not be created.
[OLE/DB provider returned message: Unspecified error]
Thx
Something has gone quite wrong along the line so let me start by asking you a
few questions which will hopefully shed some light on the situation:
1) Are there any memory dumps in the LOG folder of any of the SQL Server
instances involved?
2) Are the Publisher and the Distributor on the same SQL200(sp3) instance
(sounds like that is the case but I want to make sure)?
3) Has MDAC on the Publisher\Distributor been updated recently? Or, what is
the version of sqloledb.dll on the Publisher\Distributor machine?
4) Can you add a simple publication from another test database successfully?
If not, which command is it failing on?
-Raymond
"Allen" wrote:

> Hi,
> I'm getting the error below when executing:
> sp_addsubscription.
> Prior to this I have, added the pub with sp_addpublication followed by
> sp_addpublication_snapshot followed by sp_grant_publication_access followed
> by sp_addarticle.
> SQLServer 2000 SP3 contains the Publication and the Distribution agent is
> also on a 2000 server SP3. I have just installed a new server with SP4 which
> is my intended subscriber... but I can't get past this error. I have other
> replication evvironments setup and they run fine.
> This is the error I'm receiving:
> Server: Msg 14070, Level 16, State 1, Procedure sp_changesubstatus, Line 993
> Could not update the distribution database subscription table. The
> subscription status could not be changed.
> Server: Msg 14057, Level 16, State 1, Procedure sp_addsubscription, Line 971
> The subscription could not be created.
> [OLE/DB provider returned message: Unspecified error]
> Thx
>