x

Cannot create remote distributor database

I would like to create the distributor separate from the publisher. So on configuration of the distributor(server1), I choose the second option and add and got the following error message. My publisher server will be server 1. But I want to connect to server 2(remote server) for the distribution database. I get the following error message: Server1 is not enabled as a Publisher at the Distributor, Server2. Contact the administrator of the Distributor to enable this server as a Publisher. Does that mean I have to create the distributor and publisher in the same server?
more ▼

asked Aug 30 '12 at 09:40 PM in Default

Chitrarekha gravatar image

Chitrarekha
140 30 41 43

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

1 answer: sort voted first

You should first setup and configure distributor on server2 and choose your server1 database as the publisher. For detailed instructions, read this article from excellent replication stairway series on SSC

more ▼

answered Aug 31 '12 at 01:52 PM

yogirk gravatar image

yogirk
177 4 5 8

Thank you so much for the info, I was able to setup the remote server distribution database.
Sep 04 '12 at 01:23 PM Chitrarekha
(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x293

asked: Aug 30 '12 at 09:40 PM

Seen: 703 times

Last Updated: Sep 04 '12 at 01:23 PM