Primary Microsoft SQL Server Configuration and Verification

Configure and verify the primary Microsoft SQL Server database for replication.

• 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.
• Disabling Microsoft SQL Server Replication
  A Microsoft SQL Server publication cannot be created in the primary database used by Replication Agent for Microsoft SQL Server, and you cannot simultaneously use Microsoft replication and Replication Agent on the same Microsoft SQL Server database.
• Creating a Microsoft SQL Server User and Granting Permissions
  Create a Microsoft SQL Server user named ra_user, and grant permissions to it.
• Enabling Remote DAC
  Enable remote DAC.
• Obtaining the Microsoft SQL Server DAC Port Number
  Obtain the Microsoft SQL Server DAC port number.
• Verifying the Version of the Microsoft Filter Manager Library
  Confirm that the Microsoft Filter Manager Library version is 5.1.2600.2978 or later, to make the primary transaction log files readable for Replication Agent.
• Making the Primary Transaction Log Files Readable for Replication Agent
  Install and set up the sybfilter driver so that Replication Agent can read the primary transaction log files.
• Stopping the Analysis Service
  Terminate the SQL Server Analysis Service if it is running.
• Enabling TCP/IP
  Enable TCP/IP.
• Installing the Microsoft SQL Server JDBC Driver
  Install the Microsoft SQL Server JDBC driver.