Cannot start the MSSQL$SBSMONITORING & SQLAgent$SBSMONITORING Services

Discussion in 'Windows Small Business Server' started by AllenM, Apr 18, 2006.

  1. AllenM

    AllenM Guest

    For those of you who are familiar with my last posting regaarding my SBS
    2003 Premium server totally crashing this is a direct result from that as I
    can no longer start these services. The errors I get in the Application
    Event Log

    MSSQL$SBSMONITORING
    Source: SmallBusinessServer
    Category: SBS Monitoring
    Event ID: 4104
    Could not connect to the monitoring database. This can occur when there are
    multiple connections to the database. Wait a short period of time, and then
    try again. If this error persists, run the Monitoring Configuration Wizard,
    and select Reinstall monitoring features.

    When I try to restart the service the error I get is:
    The MSSQL$SBSMONITORING service on Local Computer started then stopped. Some
    services stop automatically if they have no work to do. For example the
    Performance Log and Alerts.


    SQLAgent$SBSMONITORING
    Source: SQLSERVERAGENT
    Category: Alert Engine
    Event ID: 322
    The data portion of event 19002 from MSSQLSERVER is invalid.

    When I try to restart the service the error I get is:
    Could not start the SQLAgent$SBSMONITORING service on local Computer. Error
    1068. The dependency service or group failed to start.

    OK I know why the SQLAgent does not start as because it is a dependencie of
    the MSSQL$SBSMONITORING service.
     
    AllenM, Apr 18, 2006
    #1
    1. Advertisements

  2. Allen,

    Take a look in the \program files\microsoft sql
    server\mssql$sbsmonitoring\log directory and see if the errorlog file shows
    any problems.

    Are any other instances running? like mssql$sharepoint?

    --


    Hope that helps,
    David Copeland
    Microsoft Small Business Server Support

    This posting is provided "AS IS" with no warranties, and confers no rights.


    SBS Newsgroups:

    SBS v4.x: microsoft.public.backoffice.smallbiz
    SBS 2000: microsoft.public.backoffice.smallbiz2000
    SBS 2003: microsoft.public.windows.server.sbs
     
    David Copeland [MSFT], Apr 19, 2006
    #2
    1. Advertisements

  3. AllenM

    AllenM Guest

    Hey Dave,
    Thanks for the input. Yes I do have other instances of MSSQL$ running
    including mssql$sharepoint. Seems these are the only two I'm having issues
    with. I do have many logs there and have viewed them however they are hard
    to decipher and to translate what they mean. Any other ideas greatly
    appreciated.
     
    AllenM, Apr 20, 2006
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.