MSSQL$SHAREPOINT stops for no apparent reason

Discussion in 'Windows Small Business Server' started by Rosewood, Nov 18, 2008.

  1. Rosewood

    Rosewood Guest

    Howdy again...

    Yet another server take over, yet another round of updates to only find
    something broke :)

    This time MSSQL$SHAREPOINT will not stay running. It is set to automatic but
    the service never stays running. If I manually start it, the event viewer
    only shows that it goes in the start state, and that it then goes into the
    stop state.

    I'm not share where the log files that I should be looking for are kept.

    Running WSS 2.0, everything is fully patched in MS update. The BPA just says
    that the service isn't running, but we knew that already.

    Only error I saw on updates was that WSUS couldn't update.

    Every other service looks like it is doing what it should.

    (They never used their companyweb so if there is an easy way to nuke the SQL
    service and rebuilt it from scratch, that is totally doable if that would be
    the quickest path to get it running)
     
    Rosewood, Nov 18, 2008
    #1
    1. Advertisements

  2. What version of WSUS are you working with? Has WSUS3 been installed? And
    perhaps uninstalled again?

    There should be entries in the event logs relating to the Sharepoint
    instance. Look at the ERRORLOG files in Program Files\Microsoft SQL
    Server\MSSQL$SHAREPOINT\LOG too (the one with no number relates to the
    most recent attempt to start the service).
     
    Steve Foster [SBS MVP], Nov 18, 2008
    #2
    1. Advertisements

  3. Hello,

    Thanks for your post and others' input.

    From the symptoms, it seems the SharePoint service is corrupted or
    conflicts with other 3rd party application/service.

    If possible, please also reboot SBS server into "clean boot" mode to see
    whether this issue continues under Clean Boot mode. Please refer to the
    following KB article to test if the issue persists in "clean boot" state.

    How to configure Windows XP to start in a "clean boot"
    statehttp://support.microsoft.com/kb/310353/en-us (Note: this article also
    works for Windows Server 2003 computer)

    Here are some related articles for your reference.

    How to remove and how to install the Windows Small Business Server 2003
    SharePoint Services 2.0 companyweb Web site
    http://support.microsoft.com/kb/829114/en-us

    How to perform a disaster recovery operation of Windows SharePoint Services
    2.0 Companyweb and Windows SharePoint Services 2.0 databases
    http://support.microsoft.com/kb/827701/en-us


    However, if we cannot resolve the issue after we perform the above steps,
    please help me collect MPS report for further investigation:

    1) Please download the MPSRPT_SETUPPerf.EXE from the following link and
    then run this tool to gather some information from the problematic computer:
    http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
    15706/MPSRPT_SETUPPerf.EXE

    2) Double-click on the MPSRPT_SETUPPerf.EXE file.

    [Note] This process may take some time; however, it will not have a
    negative effect on the performance.

    3) A CAB file will be generated in the
    %systemroot%\MPSReports\Setup\Reports\Cab directory called
    %COMPUTERNAME%_MPSReports.CAB. The CAB file will contain the reports
    generated by the MPS Reporting Tool.

    Send the .cab file directly to me at .


    Hope this helps.

    Thank you for your time and cooperation.


    Best regards,
    Robbin Meng(MSFT)

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security
     
    Robbin Meng [MSFT], Nov 19, 2008
    #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.