Zieglers

Just little about C#, .NET, SQL Server, SharePoint and SAP

Setting Subscribers before configuring Replication

Posted by zieglers on May 20, 2006

After a one week 2072 session given to IT guys of Citibank Istanbul, I want to write some of my observations during replication labs. The most forgotten part while configuring replication was setting subscribers before using the wizard.

To do this, right click your publisher/distributer server > Properties > Replication TAB > Configure > Subscribers TAB > check the subscriber server.

Also, service pack is an important issue in order to successfully configure the replication. Be sure that you applied the same service pack to all publishers and subscribers. To check this, simply execute

SELECT @@VERSION and SELECT SERVERPROPERTY('ProductLevel') statements and verify that the output is the same for all servers.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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

 
%d bloggers like this: