SQL Server 2005 tranactional replication
Posted on 2009-07-05
I have become totally frustrated trying to setup a transactional replication between 2 SQL servers. Currently, I have the publication pushing to the secondary machine with only 1 small table. When I view the Relication Monitor, the message "The concurrent snapshot for publication 'trsmain' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for the publication." That's as far as I can get. I have rebooted both servers multiple times with the same results.
Where am I going wrong?