SQL 2000 - Replication Error 2812

Hot Topic

Consuming Multiple Messages In Parallel from Multiple Windows Services
Help with permissions issues in Sql 05 standard
Method EnumDatabaseMapping on Login SMO object takes 3 minutes
Where is the Business Intelligence Development Studio
Page Number Needed in Report Header
Query Designer in SQL 2005 Mgmt Studio a let-down?
reporting services connection error
IIS Internet Info Services
Passing connection managers to subpackages.
SSIS WorkFlow

SQL Server

No processes on the end of PIPE
Need to refine the query. I get an error
SSMS/"Report" button... is it possible perhaps to customize those reports or add new?
sdk for developing sql server front-end
Oracle support and Report Builder
Upsizing Wizard
logging the DDL stmts
Stored Procedures and SSIS Web Service Task
Full text manual, where are pending changes stored
Select based on primary keys in CSV file...

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

  • GWILSON1981

    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).

  • DankS

    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,

  • gc1848

    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.

  • Iccejc

    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

  • paul_at_foobar_nu

    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.

  • ebferro

    Can you give more detail as to what you were doing when you got this error message Were you running a wizard
  • SQL 2000 - Replication Error 2812
Answer this question