Monthly Archives: January 2019

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’
select @@SERVERNAME

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

sp_helpserver

sp_adddistributor ‘servername’

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