Stay Connected
Posts tagged 2003
SMS 2003: Error 25100
Mar 16th
I am still managing a SMS 2003 environment and last week we encountered following message on one of the SMS 2003 clients. The message appeared in Application Eventviewer and SMS client did not report back to our SMS Primary site:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 3/10/2009
Time: 12:17:06 PM
User: NETWORKNET\Ivan
Computer: IVAN-VM01
Description:
Product: SMS Advanced Client — Error 25100. Setup was unable to create the WMI namespace CCM
The error code is 80041002
To fix the problem see my cmd script below which was used by the local IT contact:
@echo off
REM Ivan Versluis
REM Date: 2009/03/11
REM Description: FIX WMI Database for SMS Client
c:
cd %windir%\system32\wbem\
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
net stop winmgmt
rmdir /s /q repository
rmdir /s /q Logs
mkdir Logs
net start winmgmt
rundll32 wbemupgd, UpgradeRepository
rundll32 wbemupgd, CheckWMISetup
rundll32 wbemupgd, RepairWMISetup
pause
(No Ratings Yet)
Loading ...How to shrink the SMS_SITENAME database SMS 2003?
Jan 24th
The SMS 2003 infrastructure I am managing has one singe SMS database which became 4 GB. 1GB data and 3GB log. Today I planned the database maintenance and managed to shrink the files with 3GB. Open the Enterprise Manager or Microsoft SQL Server Management tools and make sure the database option is set to Auto Shrink = Auto (enhancement for the future).
Run the following sql script:
USE [SMS_123]
GO
DBCC SHRINKFILE (N‘SMS_123_log’, 0, TRUNCATEONLY)
GO
Another useful script can be found here which will create a stored procedure and show all table space sizes with rows and MB used.
exec sp_show_huge_tables
(No Ratings Yet) Loading ...Microsoft MCSA 2003 certified
Jan 23rd
Yesterday I successfully passed the 70-292 Microsoft exam. Somewhere in 2004 I finished all requirements for MCSA 2000 and in 2005 I passed my last exam for MCSE. 
It was three years ago I did my last one for Microsoft and before 31 of March 2008 I will need to pass 70-292 & 70-296 to upgrade my current MCSA/MCSE 2000 certificates. After 31st of March both of the upgrade exams will retire. I managed to pass the first one, but Microsoft put a lot of effort to enhance their exams and they even changed to one provider Thomson Prometric Test Center (I had issues with the new tool and couple times delay of minutes before new question was on the screen). Be prepared!!!
The 70-292 was a tough one even for a system administrator with years of working experience; sus1.0 has been discontinued for a while but the questions were there.
I used one eBook (MCSE Core Required Exams in a Nutshell O’Reilly Media) and netfresco.com 70-292 study notes website to prepare myself for the exam.
(No Ratings Yet) Loading ...
