Primary Microsoft SQL Server Configuration and Verification

Review the procedures for configuring and verifying 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 2005 (90) or Microsoft SQL Server 2008 (100).
• 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” with the password “sybase,” and grant permissions to the user.
• 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 Microsoft SQL Server Analysis Service.
• Enabling TCP/IP
  Enable TCP/IP.
• Installing the Microsoft SQL Server JDBC Driver
  Install the Microsoft SQL Server JDBC driver.