Greg Mason
asked on
SBS2K3 Server Monitoring error
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
Date: 9/23/2010
Time: 3:34:29 PM
User: N/A
Computer: (server name hare)
Description:
Server Status Report:
URL: http://localhost/monitoring/perf.aspx?reportMode=0
Error Message: Cannot open database requested in login 'SBSMonitoring'. Login fails.
Login failed for user '(domain name)\Administrator'.
Stack Trace: at usage.globalFn.connectData
at usage.frmPerf.renderReport
at usage.frmPerf.renderReport
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
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
Date: 9/23/2010
Time: 3:34:29 PM
User: N/A
Computer: (server name hare)
Description:
Server Status Report:
URL: http://localhost/monitoring/perf.aspx?reportMode=0
Error Message: Cannot open database requested in login 'SBSMonitoring'. Login fails.
Login failed for user '(domain name)\Administrator'.
Stack Trace: at usage.globalFn.connectData
at usage.frmPerf.renderReport
at usage.frmPerf.renderReport
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That didn't work either, although I am loath to re-install SQL since it will effect production and probably just make things worse..
We told the client the entire O/S will need to be re-installed from scratch to fix the issue. No one on the Microsoft support blog site has even addressed the question (typical) for a week! The only response I got was from here!
We told the client the entire O/S will need to be re-installed from scratch to fix the issue. No one on the Microsoft support blog site has even addressed the question (typical) for a week! The only response I got was from here!
ASKER
Good effort and might have solved the issue in some circumstances. Just not this one.
Thanks gem555. Sorry I was not able to help. I am surprised others did not "jump in", although that may indicate it is a unique problem.
Cheers!
--Rob
Cheers!
--Rob
ASKER
Client doesn't want to spring for paid monitoring, Is there anything else that might work?