Monthly Archives: March 2017

Migrating from Windows Internal Database (WID) to External SQL (WSUS 4 on Server 2016)

The following are the steps I used to migrate from a WSUS 4 Windows Internal Database on Server 2016 to SQL Server 2016 hosted on another Windows Server 2016 server. First, stop the WSUS and IIS Admin services Stop-Service -Name “IISADMIN” … Continue reading

Posted in Uncategorized | Leave a comment

ConfigMgr – Find Package or Deployment Name by ID

The following SQL will allow you to find the package or deployment name based on the Deployment ID/Offer ID. SELECT CollectionID ,OfferID ,Description FROM DeploymentSummary WHERE OfferID = ‘PKG00000′ Where PKG00000 is the ID of the deployment you’re trying to find.  

Posted in Uncategorized | Leave a comment

ConfigMgr 1606 Move Database from SQL 2008 to SQL 2016 on separate server

The following steps are how I moved an existing Windows Server 2008 R2/SQL 2008 ConfigMgr database residing on the site server to a separate standalone install on Windows Server 2016/SQL 2016. Install SQL 2016, only “Database Engine Services” and “Reporting … Continue reading

Posted in Uncategorized | Leave a comment