I have a server running SBS 2003 SP2.
I activated server monitoring about 6 months ago and it ran pretty well up until about one month ago when it failed. I tried re-running the Monitoring Configuration Wizard and it now failes.
The error message is "An error occurred while running the wizard". The
Configuring Data Store, Data Collection and Alert Threshold are all
checked at completion but Configuring Reports fails. if I do not check Receive a
daily performance report in e-mail, Configuring Reports completes
successfully. Checking to Elect to receive usage reports will also cause
Configuring Reports to fail. Specifing in an internal or external email
address has the same result, it fails.
Here's the error log:
Event Type: Error
Event Source: ServerStatusReports
Event Category: None
Event ID: 1
Time: 3:34:29 PM
Computer: (server name hare)
Server Status Report:
Error Message: Cannot open database requested in login 'SBSMonitoring'. Login fails.
Login failed for user '(domain name)\Administrator'.
Stack Trace: at usage.globalFn.connectData
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp