Re: SBS Monitoring Issues

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Date: Sun, 29 Aug 2004 15:54:39 -0500

Fred,

Sorry, I missed that part in the text.. saw the error message.. I was able
to reproduce the 103 event message after removing the BUILTIN\Administrators
from having login rights to the sbsmonitoring instance.. and then re-adding
it.. but not putting the BUILTIN\Administrators group back into the SysAdmin
role

If you are logged on to the server as Administrator.. are you still able to
logon to the sbsmonitoring instance using the following

osql -E -S servername\sbsmonitoring

If so trying doing the following at the > prompts

> sp_addsrvrolemember N'BUILTIN\Administrators', sysadmin
> go

Then see if the sqlagent$monitoring will start.

Do you have backups of the sbsmonitoring databases? 

-- 
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:23d901c48dec$cc64c190$a601280a@phx.gbl...
> David,
>
> As mentioned in my original post, sqlagent$sbsmonitoring
> is set for auto start as a local system account.  However,
> it doesn't start at boot and won't start thereafter.  It
> terminates immediately after attempting to start it going.
>
> That's the problem I'm trying to resolve.
>
> Fred Orcutt
>
>>-----Original Message-----
>>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
>>>
>>
>>
>>.
>>