it.blo.gg

2. Run the following select statement to find the Distribution Points in this state: select * from dbo.DistributionStatus where InsStr2 = '3010'

3. Once identified then Delete a record an affected DP with: delete from dbo.DistributionStatus where ID = <DPID of affected DP identified by above command>

Source:

https://social.technet.microsoft.com/Forums/en-US/127b59c0-d9fc-4224-be8f-03efe9a97544/distribution-point-configuration-status-sms-client-restart-might-required?forum=configmanagerdeployment

[11/13/2013 10:03:06 AM] Information : Querying WMI Namespace: \\dpm01\root\Microsoft\SqlServer\ComputerManagement10 for query: Select * from SqlServiceAdvancedProperty where ServiceName='MSSQL$MSDPM2012' and PropertyName='Version'

[11/13/2013 10:03:06 AM] * Exception :  => System.Management.ManagementException: Invalid class

[11/13/2013 10:03:06 AM] Information : Getting the error code for check : SqlServer and result : 67141632

[11/13/2013 10:03:06 AM] Information : Found Error Code:SqlNotInstalled and Severity: Error

[11/13/2013 10:03:06 AM] Information : Got Error Message: The instance provided is not a SQL Server instance. Please provide a SQL Server instance.

[11/13/2013 10:03:06 AM] Information : Got Error Message: The prerequisite (SQL Server 2008) required to perform this check is missing.

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

http://social.technet.microsoft.com/Forums/en-US/469634e4-eb9b-4c01-8664-fa53cb804763/reinstalling-dpm-keep-failing-and-cant-regonize-our-sql-server-2008-r2?forum=dataprotectionmanager

Import-Module smlets ; Add-PSSnapIn SMCmdletSnapIn ;

#Delete the existing data from the CSV Clear-Content -Path "E:SMAdminCSVUsers.csv"

#retrieve all users from the CMDB and cycle through them

$users = (get-scsmclass Microsoft.AD.User$ | get-scsmobject)

foreach ($user in $users)    

{        

$UserName = $user.UserName               #get the username, used to identify the person        

$Domain = $user.Domain                   #get the domain, this is required for a CSV import        

$ID = $user.ID                           #get the users guid, we will use this to create the ID for the settings object         $setPref = 'Pref.'                       #used as a prefix for the localsetting object id        

$setID = $setPref,$ID                 

$setID = [string]::join('',$setID)       #combine the users guid and Pref. to make the id for localesettings        

if ($user.City -like "Shanghai") {$timezone = 'China Standard Time'}        

elseif ($user.City -like "Dhaka") {$timezone = 'Central Asia Standard Time'}        

else {$timezone = 'W. Europe Standard Time'}        

$locale = '1033'                         #setting the locale, in this case it's English (United States)        

$data = $UserName, $Domain, $setID, $timezone, $locale  #put it all into an array        

[string]::join(',',$data) | ForEach-Object {Add-Content -Value $_ -Path "E:SMAdminCSVUsers.csv"};   #convert the array to a string and append to the csv

}

#once all users have been added to the csv, import it into the CMDB using the xml mapping file.   

Import-SCSMInstance -DataFileName "E:SMAdminCSVUsers.csv" -FormatFileName "E:SMAdminCSVUserImport.xml"

#Remove any automatically created localization settings, the script has create new ones for everybody

get-scsmclass System.UserPreference.Localization$ | get-scsmobject -filter {DisplayName -notlike "%-%"} | remove-scsmobject -force

Remove-PSSnapIn SMCmdLetSnapIn;

Remove-Module smlets;

REG ADD HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\CCM\CcmExec /v ProvisioningMode /t REG_SZ /d false /f

REG ADD HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\CCM\CcmExec /v SystemTaskExcludes /t REG_SZ /d "" /f

Please read more here: http://www.windows-noob.com/forums/index.php?/topic/5618-damaged-client-after-setup-no-self-singed-cert/

MSI: Action 17:10:36: Rollback. Rolling back action: ccmsetup 2012-12-12 17:10:36 2192 (0x0890)

MSI: Warning 25101. Setup was unable to delete WMI namespace ccm\dcm The error code is 80041002 ccmsetup 2012-12-12 17:10:37 2192 (0x0890)

File C:\WINDOWS\ccmsetup\{F5EAB9A8-E852-429F-92BC-BB82712ACA9B}\client.msi installation failed. Error text: ExitCode: 1603 Action: CcmCreateWmiNamespaces. ErrorMessages: Setup was unable to create the WMI namespace CCM The error code is 80041002  ccmsetup 2012-12-12 17:12:31 2192 (0x0890)

This indicates that there is something wrong with WMI on the client. I tried to find a way to repair WMI on Windows XP and found a solution where you should delete %windir%\system32\wbem\repository and restarting the "Windows Management Instrumentation" service. DO NOT perform this step, it will make the computer very unstable. Instead run the following commands in a Command Prompt to rebuild the WMI components.