RSS

How to Add New Publisher Server to the Distributor Server (MSSQL Replication)

05 Jan

now if i need to Add new Publisher on my Distributor Server i will do this steps in SQL Server Also if you need to know hot to Setup the Cnfiguration of Distributor Server see this link :http://wp.me/p1Oidq-et or Check the replication categories :https://mostafaelmasry.wordpress.com/category/sql-server-2008/replication/

1- Connect to the MSSQL Distributor Server >>> mangement Studio >>> Replication >>> Write Click >>> Distributor properties

Replic_1

2- Add SQL publisher

Add SQL publisher

3- Add password to Connect the Publisher with this password to the Distributor

replic_3

Now if you Check the Distributor Server you will See 2 Publisher Server

Wait for me in another Replication posts

Regards ,

Mostafa Elmasry

 

 
Leave a comment

Posted by on January 5, 2013 in Replication

 

Tags: , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s