Solved

SBS2K3 Server Monitoring error

Posted on 2010-09-23
6
357 Views
Last Modified: 2012-06-27
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.connectDataSource(Boolean pingFirst)
   at usage.frmPerf.renderReportWorker()
   at usage.frmPerf.renderReport()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
Comment
Question by:Greg Mason
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 77

Accepted Solution

by:
Rob Williams earned 500 total points
ID: 33749295
There was a recent similar question where it was suggested some of the web sites may have been updated to .NET 2.0 and if that wasn't the case reinstalling monitoring was suggested:
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_22765670.html
0
 

Author Comment

by:Greg Mason
ID: 33872380
Tried it. No joy.

Client doesn't want to spring for paid monitoring, Is there anything else that might work?
0
 
LVL 77

Assisted Solution

by:Rob Williams
Rob Williams earned 500 total points
ID: 33875662
You could try re-installing the monitoring components as per:
http://msdn.itags.org/microsoft-sbs/36137/
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:Greg Mason
ID: 33910580
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!
0
 

Author Closing Comment

by:Greg Mason
ID: 33910586
Good effort and might have solved the issue in some circumstances. Just not this one.
0
 
LVL 77

Expert Comment

by:Rob Williams
ID: 33914405
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
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question