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
Category: Error messages
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
