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.