Verifying the Compatibility Level of Microsoft SQL Server

Verify that the database compatibility level is set to Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012.

Replication Agent supports Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, and Microsoft SQL Server 2012. To verify the compatibility level:

  1. In the Microsoft SQL Server Management Studio, right-click your primary database and select Properties.
  2. In Database Properties, click Options, and verify that the compatibility level is "Microsoft SQL Server 2008 (100)." If it is not, select that compatibility from the drop-down list, and click OK.
Parent topic: Primary Microsoft SQL Server Configuration and Verification