SBS Monitoring Issues

From: Fred Orcutt (anonymous_at_discussions.microsoft.com)
Date: 08/29/04 

Date: Sat, 28 Aug 2004 19:05:18 -0700

My SBS2003 server has been experiencing a significant
problem with monitoring. The SQLAgent$SBSMonitoring
service is set for auto startup under a local system
account, but will not start on boot. When trying to start
it, the message appears that it started and then stopped.

Reports are transmitted as configured but the content
states as follows:
--------------------------------

Server Error in '/' Application.
---------------------------------
The resource cannot be found.
Description: HTTP 404. The resource you are looking for
(or one of its dependencies) could have been removed, had
its name changed, or is temporarily unavailable. Please
review the following URL and make sure that it is spelled
correctly.

Requested Url: /monitoring/perf.aspx
------------------------------------------

The following appears in EV after any unsuccessful attempt
to start up the service. I cannot determine any obvious
way to satisfy the requirement report in the event.

------------------------------------------
Event ID: 103
Source: SQLAgent$SBSMonitoring

SQLServerAgent could not be started (reason:
SQLServerAgent must be able to connect to SQLServer as
SysAdmin, but '(Unknown)' is not a member of the SysAdmin
role).

-------------------------------------------

Additionally, the CEICW will not complete, indicating
firewall settings cannot be configured. I have
uninstalled and reinstalled IIS, but same result. Also,
the default web site regurlarly stops and must be
restarted.

Expert help is appreciated!!

Thanks,

Fred Orcutt

Relevant Pages

  • Re: SQL Server and Agent Accounts
    ... I log in to the server as a sysadmin. ... Here is a scenario that I tested: I created a Windows account called ... Apparently when SQL Agent logs in to the publisher it uses Domain\Maer. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQLAgent$SBSMONITORING
    ... The SQLSERVERAGENT service would be there if you had installed Full SQL ... Server 2000 from your Premium Technologies cd as a default instance (which ... Microsoft Small Business Server Support ... "Simon" wrote in message ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Kill SPs then sqlserveragent stop working
    ... Don't kill processes you don't know for sure are safe. ... Microsoft SQL Server MVP ... SQLserverAgent Service on local computer. ...
    (microsoft.public.sqlserver.server)
  • Re: Server Agent startet nicht mehr nach SP3a ohne Fehlermeldung!
    ... SQLServerAgent could not be started (reason: ... mit Server '' kann nicht hergestellt werden. ... aber wohl nicht den Agent. ... die mystische Fehlermeldung hat mich wohl doch etwas ...
    (microsoft.public.de.sqlserver)
  • Re: SQLServerAgent cannot start
    ... SERVER instance via Enterprise Manager. ... Did you recently change your computer password (not SQLSERVER ... > SQLServerAgent could not be started (reason: ... > If I look at the SQL Server Agent Logs via Enterprise Manager, ...
    (microsoft.public.sqlserver.server)