This project has moved. For the latest updates, please go here.

Previous Install Data Quality Services Manual Install Install SSDT Next

 

Install Replication Distributor

FineBuild can install and configure Replication Distributor as part of the SQL Server install process.

Replication Distributor is written by Microsoft. It was chosen to be included in FineBuild because it provides the Distribution databases needed when using SQL Server Replication.

Replication Distributor can not be installed on Express Edition.

SQL Replication home page http://msdn.microsoft.com/en- us/library/ms151198.aspx
SQL Replication download All components needed for Replication Distributor are included in the SQL Server install media
SQL Replication introduction http://technet.microsoft.com/en- us/library/ms152531.aspx


SQL Server Replication is a vast topic, and the links above only give the briefest introduction. Running replication in a Production environment is a skilled operation, but when done correctly it is reliable and resilient. Anybody considering using replication for the first time is advised to investigate the materials available on the internet, and consider hiring someone with skills in replication to provide knowledge transfer.

FineBuild Replication Distributor Install

Automated silent installation of Replication Distributor is performed by Process Id 4SN and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupDistributor FULL No No No No No
SetupDistributor WORKSTATION No No No No No
SetupDistributor CLIENT N/A N/A N/A N/A N/A


FineBuild also uses the following parameters to help configure Replication Distributor:

Parameter Default Value Description
DistributorDatabase Distributor Name of Distributor database
DistributorPassword sapwd value Password for Replication administrator. The password should be recorded in the DBA Password Store
DirSQL SQLFiles High-level folder name for SQL Server files and folders
Instance MSSQLSERVER SQL Server instance name


FineBuild will not by default install Replication Distributor, because most sites do not need this functionality.
If you want FineBuild to install Replication Distributor, then you must add the following parameter when you run FineBuild:

/SetupDistributor:Yes

The FineBuild install for Replication Distributor includes the following:


Manual Replication Distributor Install

The following steps show what you would have to do to install Replication Distributor manually. FineBuild does all of this work for you automatically.

Configure Instance as Distributor

1) Start SQL Server Management Studio (SSMS) and run the following command:

EXEC sp_get_distributor


If the value of installed is False then perform all of the steps in this section

2) Run the following command to configure the SQL Instance as a Distributor.

EXEC sp_adddistributor @distributor='Instance', @password='DistributorPassword'


Setup Replication Distributor Database

If the value of distribution db installed is False then perform all of the steps in this section

1) Create the folder to host the Distribution DB data file.

Run the following command, replacing DrvData and Instance with the values of the DrvData parameter and the SQL Instance name being installed.
MD DrvData:\DirSQL\MSSQL.Instance.Data\DistributorDatabase


2) Run the following command to create the Distribution database.

EXEC sp_adddistributiondb @database='DistributorDatabase', @security_mode=1, 
@data_folder='DrvData:\DirSQL\MSSQL.Instance.Data\DistributorDatabase',
@log_folder='DrvLog:\DirSQL\MSSQL.Instance.Log'


Configure SQL Instance as Publisher

1) Run the following command to configure the SQL instance as a Publisher.

EXEC sp_adddistpublisher @publisher='Instance',distribution_db='DistributorDatabase', 

@security_mode=1, @password='DistributorPassword', 
@working_directory='DrvProg:\DirSQL \MSSQL_10\Instance\MSSQL\Repl'


Copyright FineBuild Team © 2011 - 2015. License and Acknowledgements

Previous Install Data Quality Services Top Install SSDT Next

Last edited Feb 26, 2015 at 4:24 PM by EdVassie, version 15