Re: SBS Monitoring Issues
From: Fred Orcutt (anonymous_at_discussions.microsoft.com)
Date: 08/29/04
- Next message: BobStone: "Move SBS 2003 to new hardware"
- Previous message: Javier Gomez [SBS MVP]: "Re: range of ports in NAT"
- In reply to: David Copeland [MSFT]: "Re: SBS Monitoring Issues"
- Next in thread: David Copeland [MSFT]: "Re: SBS Monitoring Issues"
- Reply: David Copeland [MSFT]: "Re: SBS Monitoring Issues"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 29 Aug 2004 15:14:51 -0700
David,
Thanks for taking a deeper look at this for me. At
the 'go' command, I get the following return:
"Message 7105, Level 22, State 6, Server Sticker-
17e2br\SBSMONITORING, procedure sp_addsrvrolemember, Line
50
Page <1:72>, slot 31 for text, ntext, or image node does
not exist"
Not sure if this indicates a syntax error on my part or
more substantive.
No, unfortunately, no backup :(.
Also, Sharepoint Central and companyweb have disappeared
from IIS list of webs.
Thanks,
Fred
>-----Original Message-----
>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
>>>>
>>>
>>>
>>>.
>>>
>
>
>.
>
- Next message: BobStone: "Move SBS 2003 to new hardware"
- Previous message: Javier Gomez [SBS MVP]: "Re: range of ports in NAT"
- In reply to: David Copeland [MSFT]: "Re: SBS Monitoring Issues"
- Next in thread: David Copeland [MSFT]: "Re: SBS Monitoring Issues"
- Reply: David Copeland [MSFT]: "Re: SBS Monitoring Issues"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
