This mystery often starts with the land of Replication Montor being very unhappy, providing a lot of red errors. Unhappy-land in Replication Monitor can in this instance be relatively easily fixed. If you manage to keep your cool and look deeper into the errors, you would probably see something like this: Could not find stored … Continue reading Replication procs missing!
Month: April 2019
I ran into an issue with transactional replication setup that I thought I would mention here, as I spent quite some time to discover the cause. In my setup the server SQL01 uses SQL02 as distributor. When I set up publication on a database in SQL01, the Log Reader Agent is created in the distributor … Continue reading Log reader fails with authentication error
