it says "Running" under the status but down in details it says "No replicated transactions are available.". I checked few tables and it seems that it has been loaded.
I found the solution on many forums, here are all the steps:
1. Delete the whole replication including, first delete the subscriber then delete the publisher and then the distributer (make sure u delete the distributer by running select * from sysdatabases and u don’t want to see the distribution database (to delete the distributer make the database offline and then delete)
2. Create a login (Ex: replication_admin) with sysadmin privileges in publisher, subscriber and in distribution database and make the that login ad dbo for publisher and subscriber databases
3. Share the snapshot folder (Ex: \\servername\sharedname\) and gave enough permissions to sql service logins and the login under which u want r going to setup replication
4. Create the distributor, gave the snapshot shared folder while configuring the distributer, run the log reader agent and snapshot agents under sql service logins
5. Create the publisher and gave the replication_admin login for CONNECT TO DISTRIBUTER option
6. Check the replication monitor for any issues
7. Configure the subscriber and gave the sql service account login for CONNECT TO PUBLISHER option (if u r using pull subscription)
8. My publisher and subscriber servers runs under the same sql service account permissions (login and password is same for both)
Hope the solution will help you to resolve the issue!!
Replication Monitor
Posted - 12/21/2012 : 15:58:26
