Troubleshoot subscriptions that have not materialized.
Creating replication definitions or function replication definitions
Marking tables or stored procedures for replication
Creating connections to the destination databases
Creating articles, if you are using them
Creating and validating publications, if you are using them
Marking text, unitext, or image columns for replication, if you are replicating text, unitext, and image columns.
Creating direct and indirect routes, if the destination database is connected to a Replication Server different from the primary database’s Replication Server
Creating logical connections, if you are using warm standby applications
Other subscriptions to the same replication definition and replicate database have not yet processed
No connection to the primary Replication Server because of an incorrect login
Primary Replication Server down or out of stable queues
Stable Queue Manager (SQM), Stable Queue Transaction interface (SQT), and Distributor (DIST) threads down
Primary data server down, incorrect login, out of stable queues, or rows selected with holdlock
RepAgent problem
Route problem
Destination Replication Server—incorrect login or out of stable queues
Destination Replication Server Data Server Interface (DSI) problem—use admin who, dsi or admin who, sqm to determine what the specific problem is
Incorrect user privileges on destination database
If the subscription is still not materialized, analyze the error log again or complete any of the steps you have skipped.