Sunday, March 11, 2012

2k Replication errs .... Error 2812

Hey,
Having some probs w replication between 2 2k srvs running sql2k.

The dist agent is experiencing errors........

"Could not find stored procedure 'sp_MSins_tester'

Error number: 2812

Initially it gave an error of 18452 on dist agent of Could not connect.
I updated the id/pw for the subscriber and that went away and generated the above.

Any thoughts on what I should try next?

--mattHi Matt ,

from what I have experienced (both errors) you will have to create a stored procedure for you dist agent , that you should solve the problem.you might want to check sql books online there is more info there.

Hope this helps in some way..

Regards
Burner|||What did you end up doing to get by this problem ?|||Which service pack do you have installed for sql server 2000 (on both sql servers) ?

No comments:

Post a Comment