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!
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
Lets start with a simple issue that I have struggled with a few times. I try to start SQL Server Configuration Manager and is met with this puzzling message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later … Continue reading Disagreeable WMI Provider
Thanks for joining me! I will very soon start putting TSQL-scribles, thoughts, ideas and information that I need to remember and keep easily available. Good company in a journey makes the way seem shorter. — Izaak Walton
