Remote Distribution - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Replication (2008)

Remote Distribution

Author

Topic

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-01-29 : 04:44:54

I Installed 3 Instances With SQL Server 2008 SE with Instance Names are (REP,REP\DIS,REP\SUB)

I Configured a Distributer in REP\DIS,
Now I'm Configuring Publisher in REP I'm Selecting Remote Server the Below Error Occurred

TITLE: New Publication Wizard
------------------------------

'REP' is not enabled as a Publisher at the Distributor, 'REP\DIS'. Contact the administrator of the Distributor to enable this server as a Publisher.

How to Configure Publisher with Remote Distribution ?

--
Ragu Thangavel
SQL Server DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-29 : 11:27:13

You need to go to the distribution properties (right click replication folder in SSMS and go to the one that says to configure the distributor) and then add your publisher in there. You'll need to assign a password for it. Then you can go to your publisher and add your publication. It'll require you to type in the same password you entered before.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-02-02 : 01:19:19

Thanks for your reply.I Successfully Configured Merge Replication for our client Site.

--
Ragu Thangavel
SQL Server DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-02 : 11:26:06

You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources