Cannot install Monitoring Services in Small Business Server 2003 R2 (MSDE install Error)
Long Story:
I installed SBS Standard fresh on this machine following a guide (http://www.msexchange.org/tutorials/Installing-and-Configuring-SBS2003.html) which recommended installing all updates to the OS before installing SBS, which I did. Apparently, this is bad since Windows Update installs incorrect versions for some items. As a result, my Companyweb site, WSUS, and Monitoring didn't work. This server is in production, so resinstalling is no longer an option.
(screen shot 1) In Server Admin, when I click Monitoring and Reporting->Set up Monitoring Reports and Alerts, I get an error instructing me to reinstall it.
(screen shot 2) I run SBS Add/Remove, and set Server Tools to 'Maintenance' and Monitoring to 'Reinstall' (I have also tried removing/installing)
(screen shot 3) It asks for source files, which I point it to (I have the updated R2 CD, mentioned in the guide above)
(screen shot 4) Install progresses normally
(screen shot 5) Final screen shows failure, with message "MSDE 2000 Service Pack 4 did not install. For additional instructions, see the SQL Server 2000 Service Pack Web site at http://go.microsoft.com/fwlink/?LinkId=46241".
The link in the error is invalid, so no help there. I have MSDE 2000 SP4 installed, which may be the problem. I don't see anywhere to uninstall it though.
Is there a registry key somewhere that is or isn't set that needs to be? Is there a procedure that can force it? All the things I see online just say to remove and install it.
I had tried manually installing before, but just tried it again with the same results. It still says MSDE 2000 Service Pack 4 did not install, as above. It IS installed already, since the Sharepoint site works perfectly.
After installing SQL 2005 Express (MSDE 2005), my companyweb site broke. I ended up uninstalling SQL 2005 Express, then uninstalling Intranet and Monitoring. After a reboot, I installed SQL 2005 Express first, then reinstalled Intranet and Monitoring. All seems working fine now.
Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).
http://www.microsoft.com/downloads/details.aspx?familyid=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
Then reinstall monitoring
Good Luck!