Observe these requirements for Microsoft SQL Server.
Replication Agent supports Microsoft SQL Server 2005 Service Pack 2, and the database compatibility level must be set to “SQL Server 2005 (90)”. Replication Agent also supports Microsoft SQL Server 2008, but support is limited to the same functionality supported in Microsoft SQL Server 2005.
You cannot simultaneously use Microsoft replication and Replication Agent on the same Microsoft SQL Server database. Disable Microsoft replication before using Replication Agent for Microsoft SQL Server.
You cannot create a Microsoft SQL Server publication on the primary database where Replication Agent for Microsoft SQL Server is running.
The Microsoft SQL Server TCP/IP protocol must be enabled.