Installing SQL Server Replication

SQL Server Setup

previous page next page

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.

Important:
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.

Installing Replication by Using Setup

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.

Installing Replication from the Command Prompt

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:
      Copy Code
      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:
      Copy Code
      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:
      Copy Code
      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:
      Copy Code
      start /wait setup.exe /i <installation package> /qb ADDLOCAL=SDK

Change History

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.

See Also

previous page start next page