Prerequisites

Review the prerequisites before you begin setting up replication for Microsoft SQL Server.

Make sure:

You have an understanding of SAP replication and are familiar with Microsoft SQL Server.
ECDA for ODBC is installed on the same host as your replicate Microsoft SQL Server database.
You have valid licenses for Replication Server and Replication Server Options.
Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012 is installed and configured to serve as the source (primary) database from which Replication Agent replicates transactions and as the target (replicate) database to which Replication Server with ECDA replicates transactions.
Microsoft SQL Server JDBC driver 4.0 is installed. This driver is supported for Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, and Microsoft SQL Server 2012.
TCP/IP connectivity is available.

Because Replication Agent for Microsoft SQL Server is limited to the Microsoft Windows platform, all examples shown are for Windows.

Note: On Windows Server 2008 and Windows Server 2008 R2, you must be logged in as an Administrator.

Do not use Replication Server reserved words for object names or connection names. A complete list of reserved words is in the Replication Server Reference Manual.