Following some 3rd party scripts to set up replication I got this error:
The Distributor has not been installed correctly. Could not enable database for publishing
To fix this I ran these three scripts.
sp_adddistributor 'NameofDistributorServer';
sp_adddistributiondb N'NameofDatabaseBeingReplicated';
sp_adddistpublisher @publisher = 'NameofDistributorServer', @distribution_db = N'NameofDatabaseBeingReplicated';
This then allowed me to run:
use master;
exec sp_replicationdboption N'NameofDatabaseBeingReplicated ', N'publish', N'true'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment