Earlier today I opened a topic on Red-Gate forums, about one issue I found while testing the soon-to-be-discontinued SQL Monitor Hosted service. That is a great service, and it was free while in beta, but unfortunately I did not have enough time to play with it (or write about it). Altough I really wish they extend the product a couple more months, I will post this message with the hope that it could help someone on the future – either with Hosted or On-Premise versions of SQL Monitor.
I was having some errors while trying to set up the monitoring on my Windows Server 2008R2 box, all related to the registry key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones”
It turns out the server did NOT have a valid TimeZone configured. It is easy to check this by cliking on the clock on the taskbar. Once the correct timezone was selected, this error stopped happening, resuming monitoring activities.
See the full post here: http://www.red-gate.com/MessageBoard/viewtopic.php?p=69395#69395