Monday, 7 April 2008

SBS Performance Reports "Page cannot be displayed"

When I attempt to access the Performance reports on an SBS 2003 server, I get the error "Page cannot be displayed".

Based on my experience, the issue might be a bit complex than it appears.
To troubleshoot the issue, we usually need to spend quite some time to perform steps to find the problem cause due to complexity on technical side. I appreciate your understanding and cooperation during the troubleshooting process.

Suggestion 1: This issue may occurs if the files in the
c:\inetpub\monitoring folder are SBS 2003 RTM files. The SBSMonitoring
Database has been updated to SBS 2003 SP1.

You can either reapply SP1 for SBS 2003 or manually update the files.

Windows Small Business Server 2003 Service Pack 1
http://download.microsoft....84-97D755345F59/SBS2003-KB885918-SP1-X86-ENU.EXE

To manually update the files:
1. Extract the files from SBS 2003 SP1 (run command
SBS2003-KB885918-SP1-X86-ENU.EXE /x)
2. Backup c:\inetpub\monitoring
3. Copy:
C:\SP1Extract\cd3\sbs\monitor\reports\configure.htm to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\ctrl_datepicker30.htc to
C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\ctrl_datepicker30.js to
C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\default.aspx to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\error.aspx to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\form-down7x7.gif to
C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\info.gif to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\pcdetail.aspx to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\perf.aspx to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\query.aspx to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\reports.gif to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\spacer.gif to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\stop.gif to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\tabldefs.htm to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\usage.aspx to C:\Inetpub\Monitoring
C:\SP1Extract\cd3\sbs\monitor\reports\usage.dll to C:\Inetpub\Monitoring\Bin
C:\SP1Extract\cd3\sbs\monitor\reports\web.config to C:\Inetpub\Monitoring4.
IISRESET

Then, rerun the CEICW to test this issue.

How to configure Internet access in Windows Small Business Server 2003
http://support.microsoft.com/kb/825763/en-us

Suggestion 2: This issue also occur if under the c:\Inetpub\wwwroot there is a web.config, we can rename that and then try again.

Suggestion 3: If the issue persists, please try to perform the following recommended steps to reinstall monitoring component on SBS:

Reinstall Monitoring component:
=====================
Note: Please make a full backup of the SBS 2003 server before the following steps.

I. Uninstall Monitoring

a. Click Start, click Control Panel, and then click Add or Remove Programs.
b. Select Windows Small Business Server 2003 and then click Change/Remove. The Setup Wizard appears.
c. Click Next to start the wizard.
d. On the Windows Configuration page, click Next.
e. On the Component Selection page, in the Action column, change Server Tools to Maintenance, change Monitoring component to Remove, and then click Next.
f. On the Component Summary page, click Next.
g. 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:

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

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

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

V. Install the Monitoring component

a. In Add or Remove Programs, select Windows Small Business Server 2003 and then click Change/Remove. The Setup Wizard appears.
b. Click Next.
c. On the Windows Configuration page, click Next.
d. On the Component Selection page, in the Action column, change Server Tools to Maintenance, change Monitoring component to Install, and then click Next.
e. On the Logon Information page, click Next.
f. On the Component Summary page, click Next.
g. Click Finish.

Once the SBS Integrated Setup finishes, we need to reinstall SBS SP1. We may also want to run the CEICW to ensure the IIS settings are correct.

No comments: