Tables that you want to participate in replication should have primary key.
Publication can contain tables and primary key only.
Default setting should be used. Triggers must be disabled/deleted in all subscriber
Databases.
SQL user should be either sysadmin or member of Administrators,
SQLRUserGroupMSSQLServer, SQL server browser user on the machine where SQL server is
installed.
Confirm that the SQL Server agent service is up and running.
Always choose option “Create a snapshot immediately and keep the snapshot
available to initialize the subscriptions” from within the
Publication Wizard.
