October 14, 2008 at 5:32 am
I needed to cleanup replication on a test server manually. As part of this, I needed to delete distributor database manually. Since it was throwing up an error, I read in an article to set the sysdatabases category bit to 0 for distributor db. (it was 16 earlier, I think). Once I did this, I was able to delete the distributor. Now, I have a different problem.
When I go to Tools --> Replication --> Configure Publishing wizard in Enterprise manager, I get this error:
Error 21769: SQL-DMO: The passed ordinal is out of range of the specified collection.
I'm planning to cleanup replication completely and set it up from scratch. Here is what I did.
I created a new database with the same name as the old distribution database (tlDistributor). Now, I no longer get the above error when I try to configure replication through the wizard.
Now, when I go to Tools --> Replication --> Configure Publishing wizard: In the last tab, 'Subscribers', I get the below error;
Error 2812: Could not find the stored procedure 'tlDistributor.dbo.sp_MShelp_sbscriber_info'
This means that since 'Distribution' is not set up, the 'tlDistributor' database that I created does not contain any replication related stored procedures or tables. So, it is actually a dummy database with the same name.
If I delete 'tlDistributor' I get 'Error 21769'. If I create 'tlDistributor' as a new database, it will be a dummy one without the actual content.
My goal is to setup transactional replication with one publisher and two subscribers.
I think I did something fatally wrong when I set the sysdatabases category bit to 0 (for tlDistributor) and deleted it.
Please suggest how I can solve this problem. Thank you.
October 14, 2008 at 2:58 pm
Doctor,
Execute the procedure sp_removedbreplication 'database'. Look in BOL.
Execute in publisher in the subscriber too.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply