Export (0) Print
Expand All

Installing SQL Server Replication

Updated: 14 April 2006

Replication components can be installed using the Microsoft SQL Server 2005 Installation Wizard, at the command prompt, or by using an .ini file. Install replication when installing an instance of SQL Server or when modifying an existing instance.

After replication components are installed, you must configure the server before you can use replication. For more information, see Configuring and Maintaining Replication in SQL Server 2005 Books Online.

ms143677.note(en-US,SQL.90).gifImportant:
If you install replication components when modifying an existing instance of SQL Server, you must stop and restart SQL Server Agent after the install is complete. This action ensures that SQL Server Agent recognizes the replication agent subsystems and can call replication agents from job steps.

To install replication when installing a new instance of SQL Server

  • To install replication components, including Replication Management Objects (RMO), select SQL Server Database Services on the Components to Install page of the Installation Wizard.

To install replication when modifying an existing instance of SQL Server

  • To install replication components:
    1. On the Components to Install page of the SQL Server Installation Wizard, click Advanced.
    2. On the Feature Selection page, expand Database Services.
    3. Click Replication, and then click Entire feature will be installed on local hard drive.
  • To install Replication Management Objects (RMO):
    1. On the Components to Install page of the SQL Server Installation Wizard, click Advanced.
    2. On the Feature Selection page, expand Client Components.
    3. Click Software Development Kit, and then click Entire feature will be installed on local hard drive.

To install replication when installing a new instance of SQL Server

  • To install replication components:
    • Specify a value of SQL_Engine for the ADDLOCAL parameter at the command prompt or in an .ini file. For example, the command prompt could be:
      start /wait setup.exe /qb ADDLOCAL=SQL_Engine SQLACCOUNT=domain\user SQLPASSWORD=$tr0ngP@ssw0rd
      
  • To install Replication Management Objects (RMO):
    • Specify a value of SDK for the ADDLOCAL parameter at the command prompt or in an .ini file. For example, the command prompt could be:
      start /wait setup.exe /qb ADDLOCAL=SQL_Engine,SDK SQLACCOUNT=domain\user SQLPASSWORD=thepassword
      

To install replication when modifying an existing instance of SQL Server

  • To install replication components:
    • Specify a value of SQL_Replication for the ADDLOCAL parameter at the command prompt or in an .ini file. For example, the command prompt could be:
      start /wait setup.exe /i <installation package> /qb ADDLOCAL=SQL_Replication
      
  • To install Replication Management Objects (RMO):
    • Specify a value of SDK for the ADDLOCAL parameter at the command prompt or in an .ini file. For example, the command prompt could be:
      start /wait setup.exe /i <installation package> /qb ADDLOCAL=SDK
      

Release History

14 April 2006

New content:
  • Added information about the requirement to stop and restart SQL Server Agent if you install replication components when modifying an existing instance of SQL Server.

Community Additions

ADD
Show:
© 2014 Microsoft