Re: SBS 2003 Usage Report

Hello Bruce,

Thank you for kind update.

First I want to explain that since we have performed some troubleshooting
steps and the issue remains. I think this problem may be a little complex
and our troubleshooting maybe time-consuming. So if you would like to call
CSS for assistance, I would be appreciate and think it is a more effective
ways. To obtain the phone numbers for specific technology request please
take a look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Here is the summary of the this post:

Symptom:
==============
Usage reports are not being generated

What Robert and I did:
================
1. KB915148
2. Verify the Monitoring VD settings in IIS
3. Add Network Service to SQL sysadmin
4. Rerun the Setup Monitoring Reports and Alerts Wizard
5. Install SBS 2003 sp1 again
6. Reinstall Health Monitor

Thank you for your understanding.

Best regards,

Terence Liu(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

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

--------------------
| Newsgroups: microsoft.public.windows.server.sbs
| From: v-terliu@xxxxxxxxxxxxxxxxxxxx (Terence Liu [MSFT])
| Organization: Microsoft
| Date: Mon, 10 Sep 2007 10:44:50 GMT
| Subject: Re: SBS 2003 Usage Report
| X-Tomcat-NG: microsoft.public.windows.server.sbs
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
|
| From: Bruce Wilkinson [mailto:bruce.wilkinson@xxxxxxxxxx]
| Sent: Friday, September 07, 2007 22:15
| To: Terence Liu (CS&S)
| Subject: RE: Follow Up For Microsoft SBS Public Newsgroup Post [SBS 2003
| Usage Report] with Terence Liu (40139887)
| Importance: High
|
| Terence:
|
| I followed your guidance on the Health Monitor and the monitoring
component
| of SBS 2003. I still can't get usage information. I tried the process you
| described a second time, except I removed the Health Monitor, then
removed
| the monitoring component of SBS, then cleaned the registry and folders,
| then reinstalled the Health Monitor and the monitoring component of SBS.
I
| still don't have usage data, I'm getting errors regarding perflib,
perfmon
| and PSched. I would have attached the event logs (application & system),
| but they are too large. Is there another way I can get the files to you.
| Maybe if you see the errors, you can tell what the problem is.
|
| Note, SharePoint services (http://companyweb) no longer works.
|
| Bruce
|
| ________________________________________
| From: Bruce Wilkinson
| Sent: Wed 08/22/2007 8:52 AM
| To: Terence Liu (CS&S)
| Subject: RE: Follow Up For Microsoft SBS Public Newsgroup Post [SBS 2003
| Usage Report] with Terence Liu (40139887)
| Terence:
|
| I did install SP1 using the sequence described on the Microsoft webpage
| about a year ago. I checked
| HKLM/Software/Microsoft/SmallBusinessServer/ServicePackNumber. The value
is
| 1.
|
| Bruce
|
| ________________________________________
| From: Terence Liu (CS&S) [mailto:v-terliu@xxxxxxxxxxxxx]
| Sent: Wed 08/22/2007 5:13 AM
| To: Bruce Wilkinson
| Subject: RE: Follow Up For Microsoft SBS Public Newsgroup Post [SBS 2003
| Usage Report] with Terence Liu (40139887)
| Hello Bruce,
|
| Thank you for your email.
|
| You had installed Windows server 2003 sp2 on SBS 2003, however, you may
not
| completely applied SBS 2003 sp1.
|
| On the SBS server, click Start, click Run, type "regedit" (without the
| quotation marks) and click OK. Navigate to
| HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer, and check the
| data of the registry value ServicePackNumber. Is it set to "1"? If not,
| then this problem will occur because SBS 2003 SP1 has not been completely
| installed. To successfully install SBS 2003 SP1, we must install all five
| updates listed below. Additionally, the updates must be installed in the
| sequence listed.
|
| Downloading and Installing Windows Small Business Server 2003 Service
Pack 1
|
http://download.microsoft.com/download/e/0/f/e0fee8ce-768d-41c0-8871-9bc48e0
| b3fc3/ToDownLoadFilesandReadInstructions.htm
|
| Note: Since Windows server 2003 sp2 is already installed, you can skip
the
| A step. If you had installed Exchange 2003 sp2 on SBS, you can skip the C
| step.
|
| A. Service Pack 1 for the Windows Server 2003 operating system
| B. Windows SharePoint Services 2.0 Service Pack 1
| C. Exchange Server 2003 Service Pack 1
| E. Windows XP SP2 for Client Deployment
| F. Windows Small Business Server 2003 Service Pack 10
|
| After you applied the whole SBS 2003 SP1, please run CEICW
|
| Go through the follow KB and Rerun CEICW carefully.
|
| How to configure Internet access in Windows Small Business Server 2003
| http://support.microsoft.com/kb/825763/en-us
|
| Then, go to the other steps.
|
| I agree with you, the steps will take several hours, please feel free to
| take your time.
|
| Additional, all the steps are complex, I suggest you backup your SBS
before
| we do the steps.
|
| Backing Up and Restoring Windows Small Business Server 2003
| http://go.microsoft.com/fwlink/?LinkId=49916
|
| If there's anything else I can do for you, please do not hesitate to let
me
| know.
|
| Thank you and have a nice day,
|
| Best regards,
|
| Terence Liu
|
| From: Bruce Wilkinson [mailto:bruce.wilkinson@xxxxxxxxxx]
| Sent: Tuesday, August 21, 2007 23:42
| To: Terence Liu (CS&S)
| Subject: RE: Follow Up For Microsoft SBS Public Newsgroup Post [SBS 2003
| Usage Report] with Terence Liu (40139887)
|
| Terence:
|
| The problems didn't start until I installed Windows Server 2003 SP2.
| Shouldn't I start there rather than reinstalling SBS 2003 SP1? Will
Windows
| even let me install SP1? The server component has had SP2 applied. I
think
| Exchange has been too.
|
| I will need to schedule this for a time when the library will not be
open.
| This server runs the library management software and the process you're
| talking about will take several hours.
|
| Bruce
|
| ________________________________________
| From: Terence Liu (CS&S) [mailto:v-terliu@xxxxxxxxxxxxx]
| Sent: Tue 08/21/2007 5:40 AM
| To: Bruce Wilkinson
| Subject: Follow Up For Microsoft SBS Public Newsgroup Post [SBS 2003
Usage
| Report] with Terence Liu (40139887)
| Hello Bruce,
|
| Thank you for your email. I'm sorry for the delay response due to the
| weekend.
|
| Since Robert is on vacation, I will work on this issue with you.
|
| Based on my research, I suggest we try the following steps to see if we
can
| resolve this issue:
|
| 1. Install SBS 2003 sp1 again
| Please perform the steps in the following document to install SBS 2003
sp1:
| Downloading and Installing Windows Small Business Server 2003 Service
Pack 1
|
http://download.microsoft.com/download/e/0/f/e0fee8ce-768d-41c0-8871-9bc48e0
| b3fc3/ToDownLoadFilesandReadInstructions.htm
|
| Including:
| Windows Server 2003 Service Pack 1
| Windows SharePoint Services 2.0 Service Pack 1
| Exchange Server 2003 Service Pack 1
| Windows XP SP2 for Client Deployment
| Windows Small Business Server 2003 Service Pack 1
|
| Note: If you had installed windows 2003 sp1 or sp2, please skip the
Windows
| Server 2003 Service Pack 1 installation step.
|
| 2. Please reinstall the Health Monitor on SBS and then reinstall SBS
| Monitoring component
|
| Reinstall Health Monitor
| =================
| Note: Please make a full backup of the SBS 2003 server before the
following
| steps.
|
| a. Remove Health Monitor from Add/Remove programs Microsoft Health
Monitor
| 2.1
| b. Reboot
| c. Run Setup from "cd-rom drive:\disk3\HEALTHMON21\I386"
| d. Reboot
|
| Reinstall monitoring component
| ================
|
| 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.
|
| Hope these steps will give you some help.
|
| Thanks and have a nice day!
|
| Best regards,
|
| Terence Liu
|

.

Relevant Pages

  • RE: Monitoring and Reporting not working
    ... I understand that Monitoring and reporting ... Specify "Windows SharePoint Services" as the Extension name. ... Program Files\Common Files\Microsoft Shared\web server ... please try to reinstall monitoring component ...
    (microsoft.public.windows.server.sbs)
  • RE: Server Status Report not working
    ... Using Microsoft Exchange Server 2003 Recovery Storage Groups ... Documentation by Alphabetical List for Windows Small Business Server 2003 ... Server Status Report not working ... Click Monitoring and Reporting. ...
    (microsoft.public.windows.server.sbs)
  • Re: Question about monitoring in SBS2K3 Prem. vs. SBS2K
    ... Am I going to have to load Windows SBS2K to ... > databases for analysis and report generation. ... Also new in the Windows Server 2003 family are two new security groups ... >>The report in Monitoring and Reporting works, but I am looking for the ...
    (microsoft.public.windows.server.sbs)
  • Re: Monitoring and Reporting
    ... reconfigure monitoring report and it started working. ... I understand that you unable to get SBS ... On the SBS server, click Start, click Run, type "regedit" (without the ... Downloading and Installing Windows Small Business Server 2003 Service Pack ...
    (microsoft.public.windows.server.sbs)
  • SecurityFocus Microsoft Newsletter #154
    ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
    (Focus-Microsoft)
Loading