Setting up Service Broker where the initiator database is part of the AG

  There have been several posts on setting up Service Broker where the database is part of the Availability Group. This is a one stop blog for setting up Service Broker where the initiator database is part of the AG What happens when the AG fails over? Should there be any additional steps in setting…

1

Error configuring distribution- "Publishing and distribution are supported only in SQL Server version 7.0 or later"

  I recently installed an instance of SQL Server 2016 on one of my server. Later when I tried to configure the new instance as Distributor I faced the below error: Error: —————————— TITLE: Configure Distribution Wizard —————————— ‘Prod\SQL16’ cannot be configured for publishing and distribution. Publishing and distribution are supported only in SQL Server…

1