Jaa

Installing SQL Server Replication

  • Artikkeli

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:

      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

See Also

Concepts

Installing SQL Server 2005
Running Setup from the Command Prompt
Specifying Setup Properties with an .ini File

Other Resources

Installing SQL Server 2005 Components

Help and Information

Getting SQL Server 2005 Assistance

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.