Server A SQL 2005 sp2 Standard Ed. (9.00.3042.00)
Server B SQL 2005 sp2 Standard Ed. (9.00.3068.00)
A replication was setup on these two server a while back by someone else. Server A is the publisher and Server B is the distributor and subscriber. The replication was not working and was told it have never worked.
I was requested to rebuild the replication with local distributor, ie, moving distributor from Server B to Server A.
1. deleted the subscriber from Server B using SSMS.
2. deleted the publication from Server A using SSMS.
3. dropped the distributor using the following script on Server B
EXEC sp_dropdistributor @no_checks= 1
I noticed distribution database was gone from Server B. Both publication and subscription were disappeared on SSMS from respective server.
When I tried to create new publication, the "Configure Distribution Wizard" did not appeared as I expected, and the creation failed eventually with the following error.
- Creating Publication 'Areporting' (Error)
View Complete Post