Re: SBS Monitoring Issues

From: David Copeland [MSFT] (davidcop_at_online.microsoft.com)
Date: 08/29/04 

Date: Sun, 29 Aug 2004 05:40:40 -0500

Fred,

For the 103 error regarding sqlagent$sbsmonitoring can you check in
Start/Administrative Tools/Services and see if the service is running and
should be configured to run as Local System. You should be able to right
click on the service and select Properties and then click on the Log On tab
to set it to logon as Local System account (interact with desktop should not
be checked).

With the SBSMonitoring instance it does need to be running in order to run
it's scheduled jobs to do things such as remove entries that are older than
90 days (by default) from the database. 

-- 
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Newsgroups:
SBS v4.x : microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Fred Orcutt" <anonymous@discussions.microsoft.com> wrote in message 
news:20c301c48d6c$a1d98cb0$a501280a@phx.gbl...
> 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: Caching of websites - does it exist on SBS2003?
    ... Only one use on the SBS lan is affected? ... That would imply the local system, not the server. ... reason there is a great delay in seeing the changes take effect IF they are ...
    (microsoft.public.windows.server.sbs)
  • Re: Backup SBS2003 Wizard
    ... SBS Backup usually runs under Local System. ... page in the Server Management shows: ...
    (microsoft.public.windows.server.sbs)
  • WMI works except process create (urgent)
    ... A service running under the Local System account is failing to create a ... The same program works on another W2K3 server as well as on many W2K ... I've compared DCOM an WMI Control security settings to other ... admin) other than Local System. ...
    (microsoft.public.win32.programmer.wmi)
  • Re: Public folders not creating in AD - help!
    ... I mentioned that originally...everything with local system account is ... Do you know if the server needs a restart after switching ... >> switched to native mode, and when I create a public folder, I can't mail ... >> don't see my new public folder in there. ...
    (microsoft.public.exchange.admin)
  • Re: HELP! CreateProcessWithLogonW issue
    ... If your service is started under Local System account, ... in Windows Server 2003 and XPSP2 - the CreateProcessWithLogonW API is ... > Does anyone know how to deal with this Server 2003 security issue? ...
    (microsoft.public.dotnet.framework.aspnet.webservices)