publication database not listed

When I create new subscription there is nothing listed under SQL Server.
I configured Server for replication, then published myDatabase.
Then I wanted to subscribe to this database, but couldn't -
I ckick on Server's Name under tree and tha's it - nothing is shown under it
to pick from.
There is following message in event log:
The replication agent is not registered properly. Rerun SQL Server setup.
We have SQL Server 2000 with spk3 installed.
We have production databases on it and can not rerun installation.
Is there anyway to reconfigure the server or do something else?
Any suggestions will be appreciated.
Thanks.
Can you tell me exactly the steps you take to get this? IE, right click on
the publication, push new subscription, etc.
Then while you are doing this run profiler and ensure you capture all
errors. Then post the results back here.
There have been cases where replication stored procedures go missing. It is
unclear whether these procs where ever installed or if they were deleted
somehow.
Can you run the following in your master database?
select count(*) from sysobjects where type ='p' and report back here with
the count!
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:823A7863-6166-4164-B02E-F317688CBA9D@.microsoft.com...
> When I create new subscription there is nothing listed under SQL Server.
> I configured Server for replication, then published myDatabase.
> Then I wanted to subscribe to this database, but couldn't -
> I ckick on Server's Name under tree and tha's it - nothing is shown under
it
> to pick from.
> There is following message in event log:
> The replication agent is not registered properly. Rerun SQL Server setup.
> We have SQL Server 2000 with spk3 installed.
> We have production databases on it and can not rerun installation.
> Is there anyway to reconfigure the server or do something else?
> Any suggestions will be appreciated.
> Thanks.