After Reinstalling MS SQL 2005, SBSMonitoring page fails to Displa

Discussion in 'Windows Small Business Server' started by Jim, Apr 22, 2007.

  1. Jim

    Jim Guest

    Been following all the threads in this newsgroup on SBSMonitoring failure --

    We get this page result in the Server Management Monitoring and Reporting
    service:

    The page cannot be displayed
    An error occurred on the page you are trying to view.

    --------------------------------------------------------------------------------

    To work around this problem, perform the following steps. After each step,
    try again to access the page.

    Ensure that the MSSQL$SBSMONITORING service is started.
    Ensure that the server is not low on memory or disk space.
    Restart the server.
    Verify that the server is functional and that there are no system-wide
    problems.
    Run the Set Up Monitoring Reports and Alerts task in the Server Management
    Monitoring and Reporting taskpad.


    We followed all suggestions given in this message and checked this SBS 2003
    technical discussions group for similar type failures -- no actions suggested
    fix the problem.

    We had to re-install MS SQL 2005 because we had to remove the drive it was
    installed on (Drive D:). The SBSMonitoring Database is active and shows OK in
    the MS SQL Server Management Studio along with the Sharepoint SQL set.

    All other SBS system areas look to be functioning without error.

    What can be done to troubleshoot this further?
     
    Jim, Apr 22, 2007
    #1
    1. Advertisements

  2. Hi Jim,

    Thanks for posting here.

    From the description, I understand the issue is that Monitoring and
    reporting page fails to display. If I am off base, please don't hesitate to
    let me know.

    Let us refer to the following steps to troubleshoot the issue:

    1.Check if MSSQL$SBSMONITORING service is started.

    2.I recommend you to follow these steps to reinstall monitoring features:

    a. Open Server Management.

    b. Click Monitoring and Reporting.

    c. Click Set Up Monitoring Reports and Alerts.

    d. Click Next and select Reinstall monitoring features.

    e. Click Yes to confirm.

    f. Follow the steps to complete the task.

    After doing these steps, the health monitor will be reconfigured and the
    SQL database will be reset.

    3.please check if the content of the following folder is there:

    C:\inetpub\monitoring

    4.Based on my research, this issue may occur if Local Service and Network
    Service accounts do not have Full Control to the "Temporary ASP.NET Files"
    folder.

    To resolve this issue, follow these steps:

    a.Add Local Service and Network Service account Read & Execute, List Folder
    Contents, and Read permissions to
    %windir%\Microsoft.NET\Framework\v1.1.4322.

    b.Add Local Service and Network Service account Full Control permission to
    %windir%\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files.

    5.please check ASP extension. I suggest that we check the following:

    a.Open Internet Information Service Manager.

    b.Open Web Service Extensions.

    c.In the right panel, make sure that "ASP.NET v1 1.4322" is allowed. If
    not, right click it and select Allow.

    d.Click Start->Run, type "iisreset" (without the quotation marks) and click
    OK.

    6. Open a Command Prompt window, type the following commands:

    cd c:\Program Files\Microsoft Windows Small Business Server\Monitoring

    regsvr32 sbsmon.dll

    7.Uninstalled/reinstalled asp.net using

    C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322>aspnet_regiis.exe -ua

    C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322>aspnet_regiis.exe -ir -enable

    check the issue again

    8.check monitoring virtual directory using asp.net v1.1.4322

    a. On the SBS server, click Start, click Run, type "inetmgr" and click OK.

    b.go to default web site ->monitoring,right click and select properties,go
    to ASP.NET tab,check the ASP.NET version.


    9.please check identity for the application pool. Please change it to run
    under Network Service, run "iisreset" and see if this helps. To change the
    identity for the application pool, follow these steps:

    a. On the SBS server, click Start, click Run, type "inetmgr" and click OK.

    b. Expand your server\Application Pools, right-click DefaultAppPool and
    click Properties.

    c. On the Identity tab, select Network Service on the Predefined accounts
    list.

    d. Click OK.

    e. On the SBS server, click Start, click Run, type "iisreset" and click OK.

    10.we should run the following command to connect to the SBSMonitoring
    instance running on your SBS server:

    osql -S servername\sbsmonitoring -E

    check if there is ->


    11.If the problem persists, we may have to reinstall the monitoring and
    reporting component.

    reinstall the monitoring and this instance. Please refer to the following
    steps.

    I. Uninstall Monitoring

    1. Click Start, click Control Panel, and then click Add or Remove Programs.
    2. Select Windows Small Business Server 2003 and then click Change/Remove.
    The Setup Wizard appears.
    3. Click Next to start the wizard.
    4. On the Windows Configuration page, click Next.
    5. On the Component Selection page, in the Action column, change Server
    Tools to Maintenance, change Monitoring component to Remove, and then click
    Next.
    6. On the Component Summary page, click Next.
    7. Click Finish.

    II. Uninstall Microsoft SQL Server Desktop Engine (SBSMONITORING)

    In Add or Remove Programs, select Microsoft SQL Server Desktop Engine
    (SBSMONITORING) and then click Remove. A dialog box appears. To confirm
    that you want to remove, click Yes.

    III. Rename the folder
    Start Windows Explorer, and then locate and rename the following folder:


    1.C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING

    to C:\Program Files\Microsoft SQL Server\Old.MSSQL$SBSMONITORING

    2.Rename c:\inetpub\monitoring to monitoring.old

    IV. Use Registry Editor to delete the following registry key:

    HKEY_LOCAL_MACHINE\Software\Microsoft\SmallBusinessServer\Monitoring

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SBSMonitoring

    and Delete IIS Virtual Directory

    1. Open IIS, expand servername, Web Sites, Default Web Site

    2. Delete Monitoring

    V. Please check there is no entry named Microsoft Health Monitor 2.1 in the
    Add/Remove programs. If there is, please click to remove it. Then, please
    check the C:\WINDOWS\system32\wbem\HealthMonitor folder is deleted. If not,
    please delete it.

    VI.Install the Monitoring component

    1.In Add or Remove Programs, select Windows Small Business Server 2003 and
    then click Change/Remove. The Setup Wizard appears.

    2.Click Next.

    3.On the Windows Configuration page, click Next.

    4.On the Component Selection page, in the Action column, change Server
    Tools to Maintenance, change Monitoring component to Install, and then
    click Next.

    5.On the Logon Information page, click Next.

    6.On the Component Summary page, click Next.

    7.Click Finish.

    Rerun the Monitoring/Reporting wizards

    12. if issue persists,based on my experience, it may occur if the
    Monitoring and Reporting component does not work well with WMI or the WMI
    mof files are not correctly registered. I would suggest a re-register of
    all the mof files:

    C:
    CD\Windows\System32\wbem

    for /f %s in ('dir /b *.mof') do mofcomp %s

    for /f %s in ('dir /b *.mfl') do mofcomp %s

    for /f %s in ('dir /b *.dll') do regsvr32 /s %s


    If the issue persists, please help me collect the following information for
    analysis:

    gather the Monitoring Configuration

    Monitoring Configuration %sbsprogramdir%\Support\MCW.log


    MSDE_SBSMonitoring Log
    %sbsprogramdir%\support\MSDE_SBSMonitoring.log

    SBS Monitoring Error Log %programfiles%\Microsoft SQL
    Server\MSSQL$SBSMonitoring\LOG\errorlog


    Please compress all the files and send to me at


    I appreciate your time. I am happy to be of assistance and look forward to
    your reply.


    Best regards,

    Jacky Luo (MSFT)
    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security
    ====================================================
    PLEASE NOTE: The partner managed newsgroups are provided to
    assist with break/fix issues and simple how to questions.
    We also love to hear your product feedback! Let us know what you think by
    posting

    from the web interface: Partner Feedback
    from your newsreader: microsoft.private.directaccess.partnerfeedback.

    We look forward to hearing from you!
    ====================================================
    When responding to posts, please "Reply to Group" via your newsreader
    so that others may learn and benefit from this issue.
    ====================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.
    ====================================================
     
    Jacky Luo [MSFT], Apr 23, 2007
    #2
    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.