Networknet.nl Blog
Stay Connected
SMS
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
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
SMS Report – Delete Computer Object
Jun 13th
This report will delete a computer object from the SMS database. Use this report if you restage a computer with the same name. Normal process will take more than 30days to age to stale the record.
// *********************************************************************************
//
// Created by SMS Export object wizard
//
// Thursday, May 31, 2007 created
//
// File Name: Delete Computer Object.MOF
//
// Comments :
//
//
// *********************************************************************************
// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
Category = "Networknet-LocalIT tasks";
Comment = "Author:Ivan1980@Networknet.nl
\nCreate date: 5/30/2007
\nDescription: This report will delete a computer object from the SMS database. Use this report if you restage a computer with the same name. Normal process will take more than 30days to age to stale the record.
\n
\nNote: Select the computer you will restage and click Display. When report is displayed it will show 0 rows!";
GraphXCol = 1;
GraphYCol = 2;
MachineDetail = FALSE;
MachineSource = FALSE;
Name = "Delete Computer Object";
NumPrompts = 1;
RefreshInterval = 0;
ReportParams = {
instance of SMS_ReportParameter
{
AllowEmpty = FALSE;
DefaultValue = "";
PromptText = "Computername";
SampleValueSQL = "begin
\n if (@__filterwildcard = '')
\n SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0
\n else
\n SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS
\n WHERE SYS.Netbios_Name0 like @__filterwildcard
\n ORDER By SYS.Netbios_Name0
\nend";
VariableName = "comp";
}};
SecurityKey = "";
SQLQuery = "exec sp_RemoveComputerObject1 @comp";
StatusMessageDetailSource = FALSE;
};
// ***** End *****
