Distributor is the servers that manage the whole replication system. It act like a middle man for publisher and subscriber. This article explains how to setup a distribution in ms sql server?
Before start we need some prerequisite knowledge about SQL Server Replication. If we have already configured the Distributor, first disable publishing and distribution before starting.
Configuring a Distributor
In MS SQL Server, in order to configure any type of replications at first we must need to setup a distributor. It is prerequisite for any type of replications. The steps to configure a distributor are given bellow:
Connect to the server which will be act as a distributor.
Remember that SQL Server replication requires the actual server name to make a connection to the server. Connections through a IP address, server alias, or any other alternate name are not supported. So please specify the actual server name as like: ‘YourPC’. To get the server name logon to your server and write the following SQL query
It will return the actual server name.
Right click on the Replication folder and click Configure Distribution.
Distribution Configuration Wizard will be launch. Click next.
Need to select a server name which will act as Distribution. We can select either current server or remote server where QL Server will create a distribution database and log. For remote server click add and connect to that server. Let’s select the current server and click next.
Specify the path/location where snapshots of the publications will be stored. Also we can change it later from the distributor properties. Keep the default value and click next.
Select the name and location/path of the distribution database (.mdf) and log files (.ldf). Keep the default value and click next.
Click finish to complete the distribution configuration process. Once the distribution has been configured, the system database will have an additional database whose name is “distribution”.
In this way we can configure distributor in SQL server. This distribution can be used for the Snapshot, Transactional, and Merge Replication.