SQL 2000 - Replication Error 2812

Hot Topic

SQL Server 2005 Setup Was Unable to Install on Your Computer
SQL Server Express needs MSXML 6.0 for install
sp1 effects...
Configuration of SQL Server 2000 Instance
Object Explorer - Default Database
Why is taking so long to open/render the reports for the first time?
ANYONE PLEASE - Local Synchronization Between SQL Mobile and Local SQL Database
Should I use Notifications for this?
When to use varbinary(max) and when to use image?
Default SqlServer database creation path

SQL Server

Organizing Business Rules in SSIS
Where are the solution file for Adventure works DW saved?
Can SSIS package be run from WebService?
WMI Configuration?
How do I calculate YTD for previous year
IIS error on New Subscription
Access vs. SQL Server
increase the speed of the report
Help : Dynamic table generation
SQL Server 2005 CTP setup error: MSXML DomDocument could not be created

SQL 2000 - Replication Error 2812

Windows Server 2003

SQL Server 2000 on both servers

Attempting to configure replication from server A to Server B using publishing configuration wizard.

Using Enterprise Manager and we received error 2812: Could not find stored Procedure 'msdb.dbo.sp_add_jobstep_internal'.

Following the analysis of general Microsoft help which pointed to a user/rights problem I used the Query Analyser, login with 'sa' and executed sp_adddistributor . I basicly received the same error. I also executed sp_help looking for the specifice procedure - not found.

Is it possible the sp is really not there. All help is appreciated.

Thanks,

Answer this question

SQL 2000 - Replication Error 2812

  • maixmus

    Samsys, there is probably something wrong with your SP4 installation on your publisher/distributor machine. Considering proc sp_add_jobstep_internal did not exist (this proc is new in SP3+) and that sp_changedbowner is being called (this proc call was removed from sp_adddistributiondb in SP3+), the replication scripts most likely did not install properly.

    Can you verify that your SP4 installation was installed properly with no failures Can you tell me the build number returned when you execute "select @@version"

    The solution may involve reinstalling SP4, or may be as simple as re-running proc dbo.sp_vupgrade_replication.

  • Ross Goodell

    Can you give more detail as to what you were doing when you got this error message Were you running a wizard

  • Dgates123

    What SQL service pack do you have on all your nodes And the machine that has Enterprise Manager, what version of SQL SErver and service pack is installed

  • Potyos

    Both servers have SQL Server SP4. Actually I found that the Sp was not in the library and I got a copy from another Unit.

    However, now I have moved on to a Server: msg 15110 error - sp_changeddbowner - the proposed new database owner is already a user in the database. I am so annoyed at Microsoft and this whole process. Why can't I just login as administrator and replicate

    Excuse me for my venting.

  • nka4

    I can certainly confirm the version tomorrow. We were able to progress a little to create the 'distribution' database using Transact-SQL, however we are receiving new errors as we attempt to create the subscription and publisher.

    These errors involve more 'missing' stored procedures:

    distribution.dbo.sp_MSadd_logreader_agent

    distrbution.dbo.sp_MSPublication_access

    I will also reload the SP4

    Thanks,

  • tobyxu

    Yes running the replication wizard and for now just following the defaults. We select Server A as the distribution/publisher server. I also tested by trying to configure replication using Transact-SQL. The sp_adddistribution executes OK, however the sp_adddistributionDB fails with the same error (database owner is already a user).
  • SQL 2000 - Replication Error 2812
Answer this question