2

This article details exact steps to set up basic database replication with SQL Server 2014.

It starts with this:

  1. Right-click the Replication folder, and then click Configure Distribution.

On right clicking my Replication folder (I do believe I installed replication), I only get the following options:

Launch Replication Monitor
Generate Scripts....
Update Replication Passwords...

I can't find any other place in SQL Server Mgmt Studio to get to this section. What am I missing?

3

You are likely using the Express Edition. Note that Express Edition can only act as a Subscriber. Try using Standard Edition or above to Configure Distribution and Publishing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.