Observe the following 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 functionality also present in Microsoft SQL Server 2005.
You cannot simultaneously use Microsoft replication and Replication Agent on the same Microsoft SQL Server database. Be sure to 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.