Microsoft, Small Business Server 2003 R2, Service Pack 2, Monitoring and Reporting fails, Monitoring Configuration Wizard, "An error occurred while running the wizard"

Monitoring & Reporting in Server Management displays

The Page Cannot be displayed
An error occurred on the page you are trying to view.

To work around this problem, perform the following steps.  After each setep, try again to access the page.

     *Ensure that the MSSQL$SBSMONITORING service is started
     *Ensure that the server is not low on memory or disk space.
     *Restart the server
     *Verify that the server is functional and that there are no system-wide problems.
     *Run the Set Up Monitoring Reports an dAlerts task in the Server Management Monitoring and Reporting taskpad.


MSSQL$SBSMONITORING is running
plenty of hard disk and memory
server restarted plenty of times
there are other errors, but I'll get to that.

When I run the Set Up with the Monitoring Configuration Wizard, it fails, reporting:

An error occurred while running the wizard.

x  Configuring Data Store
x  Configuring Data Collection
x  Configuraing Alert Threshjolds
x  Configuring Reports

It fals on every count.


When I try to browse the Monitoring Website from IIS within the Default Website tree, it begins to generate the report by asking me to Create Your Server Usage Report.  It fails when I click CREATE REPORT.


Other errors in the eventlog are:

Event Type:      Error
Event Source:      Service Control Manager
Event Category:      None
Event ID:      7034
Date:            8/15/2007
Time:            3:12:44 PM
User:            N/A
Computer:      SERVER
Description:
The IIS Admin Service service terminated unexpectedly.  It has done this 1 time(s).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type:      Error
Event Source:      W32Time
Event Category:      None
Event ID:      29
Date:            8/15/2007
Time:            8:37:00 AM
User:            N/A
Computer:      SERVER
Description:
The time provider NtpClient is configured to acquire time from one or more time sources, however none of the sources are currently accessible.  No attempt to contact a source will be made for 15 minutes. NtpClient has no source of accurate time.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type:      Error
Event Source:      ServerStatusReports
Event Category:      None
Event ID:      1
Date:            8/15/2007
Time:            3:43:44 PM
User:            N/A
Computer:      SERVER
Description:
Server Status Report:
      URL:            http://localhost/Monitoring/usage.aspx?dateFrom=8/1/2007&dateTo=8/14/2007&extended=1
      Error Message:      Cannot open database requested in login 'SBSMonitoring'. Login fails.
Login failed for user 'LINDBERG\administrator'.
      Stack Trace:         at usage.globalFn.connectDataSource(Boolean pingFirst)
   at usage.frmUsage.renderReportWorker()
   at usage.frmUsage.renderReport()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


I've looked pretty extensively and can't seem to find any solution.  One thing that has been mentioned is reinstalling, and using extracted disks, but I'm not clear which disks people are talking about.

Any help on this would be much appreciated.

tHAnks

ScottStart Free Trial