sql server – The Distributor has not been installed correctly

–unable to turn on publish for db and showing error for the distributor has not been installed correclty

exec sp_replicationdboption N’TEst’, N’publish’,’true’

sp_addserver @server = ‘servername’ ,
@local = ‘local’
, @duplicate_ok = ‘duplicate_OK’


sp_adddistributor ‘servername’

sp_adddistributiondb N’distribution’;
sp_adddistpublisher @publisher = ‘servername’, @distribution_db = N’distribution’;

Leave a Reply

Your email address will not be published. Required fields are marked *