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, 2012 at 09:40 PM in Default

avatar image

140 37 42 45

(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, 2012 at 01:52 PM

avatar image

177 6 7 11

Thank you so much for the info, I was able to setup the remote server distribution database.

Sep 04, 2012 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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Aug 30, 2012 at 09:40 PM

Seen: 1930 times

Last Updated: Sep 04, 2012 at 01:23 PM

Copyright 2018 Redgate Software. Privacy Policy