x

SQL Replication - Not able to see configure distribution

I am not able to see the configure distribution when I right click the replication menu in one of the sql server instances but can see for other instances?

Anjani

more ▼

asked May 12 at 05:13 PM in Default

avatar image

asinha
1

What versions of SQL Server are the different nodes on? Is the one you can't see 'configure distribution' Enterprise?

May 15 at 02:25 PM Scotty
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Hi Scotty,

Thanks for the follow up. Yes, I am using SQL Server Enterprise Edition 2014 which has 6 instances. Surprisingly, on 3 instances I can see the 'configure distribution' but not on the other 3. I have compared the installation features and found the same. on one of the instances, I have set up distributor, publisher, and subscriber and the replication is working without any issue. When I tried to replicate the same for one of the other instances then I am not able to because I don't see "configure distributor' when I right click on replication.

Thanks, Anjani

more ▼

answered May 15 at 08:36 PM

avatar image

asinha
1

(comments are locked)
10|1200 characters needed characters left

I still having issue. Can someone help me?

more ▼

answered May 18 at 04:53 PM

avatar image

asinha
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x374

asked: May 12 at 05:13 PM

Seen: 26 times

Last Updated: 6 days ago

Copyright 2016 Redgate Software. Privacy Policy