How to Unlock SCCM ConfigMgr Collections Packages Programs Endpoint Manager. I thought of sharing one of the interesting TechNet threads as it’s not easy to find these details through Google or Bing. TechNet Forum Link.
Please Note “Editing the DataBase Directly is NOT Supported ”. Always take backup before performing this activity.
Latest Post – Free ConfigMgr Training Part 2 | 20 Hours Of Technical | SCCM HTMD Blog (anoopcnair.com).
How to Unlock SCCM ConfigMgr Collections Packages Programs Endpoint Manager?
Note! Following activities should be performed before attempting any of these changes in SQL tables.
1. Disable and stop the Windows Management service. (Don’t forget to enable and start the services )
2. Stop both the SMS_EXECUTIVE and SMS_SITE_COMPONENT_MANGER
Extracts from Forum Thread !!! (Note! TMP = site of OLD central site and IT1 = Site code of “Current/Existing” central site)
Collections Repair (Unlock procedure)
I ran the following SQL query to list all of the data in the table Collections:
select * from collections
I noticed that all of the column “Flags” values were set to a value of 2 instead of 18. I referenced the following article: http://www.myitforum.com/articles/1/view.asp?id=396 .
I ran the following SQL query to correct a single row and saw the result:
update Collections set Flags=’18’ where SiteID=’IT100A2C’
Once I saw it worked, I ran the following query to update all rows whose names began with IT1 and reset the value to 18.
update Collections set Flags = ’18’ where SiteID like ‘it1%’
Packages Repair (Unlock procedure)I ran the following SQL query to list all of the data in the table SMSPackages:
select * from SMSPackages
I ran the following SQL query to replace all rows with a SourceSite value of TMP and change it to IT1 :
update SMSPackages set SourceSite=’IT1‘ where SourceSite=’TMP‘
Advertisements Repair (Unlock procedure)
I ran the following SQL query to list all of the data in the table ProgramOffers:
select * from ProgramOffers
I ran the following SQL query to replace all rows with a SourceSite value of TMP and change it to IT1:
update ProgramOffers set SourceSite=’IT1‘ where SourceSite=’TMP‘
Note – This post is provided “AS IS” with no warranties, confers no rights, and is not supported by the author.
Author
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…