Observe the following requirements for Microsoft SQL Server:
Replication Agent supports only Microsoft SQL Server 2005 Service Pack 2 and later, and the database compatibility level must be set to “SQL Server 2005 (90)”.
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.