Enable SQL Tracing for ConfigMgr

Allows logging of SQL statements being executed for components interacting with the Site Database
• Set SQLEnabled to 1 to enable SQL Tracing, 0 to disable


You can enable SQL tracing by setting the following value:
On 64-bit systems: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\SMS\Tracing\SQLEnabled = 1
On 32-bit systems: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\SQLEnabled = 1

From <http://support.microsoft.com/kb/2488396>

In the logs you will be able to see following type of entires: SQL>>>

sql tracing enabled

Full and Clean reinstall of a ConfigMgr Client + script

Check to see if ccmexec is running in the Task list. If it is, stop it.

Deinstallation of Clients:  Ccmsetup.exe /uninstall

Run CCMSETUP.exe /Uninstall

Via Task Manager wait until CCMsetup is done. Check Task manger and see that the process finishes.

Use WBEMTEST and try to connect to namespace root\ccm. Namespace should be unavailable

  • Check to see if SMSCFG.INI  was deleted.
  •  Check to see if REG Keys were deleted (e.g HKLM\Software\Wow6432Node\Microsoft\SMS, or HKLM\Software\Microsoft\SMS etc.)
  • Check if the folders were deleted(e.g. C:\Windows\SysWOW64\CCM or C:\Windows\System32\CCM or C:\Windows\CCMetc.)
  • Check and confirm that the following registry entries and folder structure does not exist, delete if exists(Not to implement if this is a ConfigMgr Site Server).


               – HKLM\System\CurrentControlSet\Services\clisvcl

               – HKLM\System\CurrentControlSet\Services\ccmexec

               – HKLM\Software\Microsoft\CCM

               – HKLM\Software\Microsoft\NAL

               – HKLM\Software\Microsoft\SMS

               Folder Structure:


              – Windows\ccm

               – Windows\ccmsetup  

              For ConfigMgr 2007:

              – Windows\System32\ccm

               – Windows\System32\ccmsetup  


You can also use CCMClean and CCMDelCert:

Download – CCMClean.exe (Download SMS 2003 toolkit and run it to install all the files – go to the installation directory, it includes CCMClean.exe )

Ccmdelcert.exe wasn’t included in the System Center Configuration Manager 2007 Toolkit, but you can still use the version in the SMS2003 Toolkit 2.

You can download that here: http://technet.microsoft.com/en-us/sms/bb676787.aspx



Here is also a scripted version

net stop ccmexec
net stop ccmsetup
C:\Windows\ccmsetup\ccmsetup.exe /uninstall
timeout /T 180 >nul
rd c:\windows\ccm  /S /Q
rd c:\windows\ccmcache /S /Q
rd c:\windows\ccmsetup  /S /Q
del c:\windows\smscfg.ini
reg delete HKLM\software\Microsoft\ccm  /f
reg delete HKLM\System\CurrentControlSet\Services\clisvcl   /f
reg delete HKLM\System\CurrentControlSet\Services\ccmexec   /f
reg delete HKLM\Software\Microsoft\NAL   /f
reg delete HKLM\software\Microsoft\CCMSETUP /f
reg delete HKLM\software\Microsoft\SMS /f
reg delete HKLM\software\Microsoft\Systemcertificates\SMS\Certificates /f
timeout /T 180 >nul
rd c:\windows\ccm  /S /Q
shutdown /r /t 300

Client Verbose and Debug Logging

Verbose und Debug Logging on clients (MP as well)  :

Enable Debug Logging

 1.      Stop the SMS Agent Host service:

           a.       Click Start, point to Programs, point to Administrative Tools, and then click Services.

           b.      In the Services screen, locate the SMS Agent Host service.

           c.       Right-click the SMS Agent Host serxvice, and then click Stop.

2.      Click Start, click Run, type regedit in the Open box, and then click OK.

3.      In Registry Editor, add the following key:


4.      Add a new value under this key::

                    ·         Value name: Enabled

                    ·         Value: True

                    ·         DataType: REG_SZ

5.      Restart the SMS Agent Host service.


Enable Verbose Logging

For verbose logging change the value of Loglevel to 0 at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\CCM\Logging\@Global\Loglevel

You need to configure  Permissions with Full Control on this Reg Key.


         Data type: UInt32

The level of detail that the log will capture. Possible values are shown below. The default value is 1.


Verbose logging


Normal logging


No logging

Client side reference registry(For ConfigMgr 2007)

For X86 systems

–          HKLM\Software\Microsoft\CCM\Logging\@GLOBAL

For X64 systems

–          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\CCM\Logging\@GLOBAL


Configuration Manager 2012 SP2 and R2 SP1 is out

Configuration Manager 2012 SP2 and R2 SP1 is out

Announcing the availability of System Center 2012 R2 Configuration Manager SP1 and System Center 2012 Configuration Manager SP2

System Center 2012 R2 Configuration Manager SP1 and System Center 2012 Configuration Manager SP2 are now generally available and can be downloaded on the Microsoft Evaluation Center. These service packs deliver full compatibility with existing features for Windows 10 deployment, upgrade, and management.