Category Archives: SQL Server 2017

What to do when Endpoint Manager upgrades don’t go as planned. Hint: logs

Introduction Anyone that spends time with ConfigMgr knows that it’s an amazingly resilient product, and not only that, upgrades tend to go without a hitch. I needed to upgrade one of my old labs to test new functionality, but when … Continue reading

Posted in 1910, 2006, detach database, SQL Server 2017 | Leave a comment

How can I install System Center Configuration Manager (Current Branch) version 1902 on Windows Server 2019 with SQL Server 2017 – Part 6

Introduction This multi-part guide will show you how to install the latest baseline version of Configuration Manager from Microsoft. The latest available baseline version is System Center Configuration Manager (Current Branch) version 1902 as of April the 10th 2019. I … Continue reading

Posted in 1902, baseline version, SQL Server 2017, Windows Server 2019 | Leave a comment

How can I get BitLocker Recovery Keys from the ConfigMgr database in SCCM?

Introduction Microsoft released the mother of all releases when it comes to SCCM Technical Preview recently and that was Microsoft System Center Configuration Manager Technical Preview version 1905. It contained many features including one which I’m interested in, namely Microsoft … Continue reading

Posted in 1905, MBAM, SQL Server 2016, SQL Server 2017 | 10 Comments

ConfigMgr log files help you when you least expect it, oh and SCCM 1904 TP is out !

Introduction Another month has gone by and Microsoft have just released SCCM 1904 TP (Technical Preview). Technical Preview releases are released for testing new features for SCCM and are only applicable for LAB environments. To get TP 1904 you can … Continue reading

Posted in 1904, SQL Server 2016, SQL Server 2017 | 3 Comments

Upgrading the SQL Server 2012 Client Agent with PowerShell to support TLS 1.2 for SCCM installations

Introduction This is a quick post to highlight a small update to my Install SQL Server 2017.ps1 script used to install SCCM 1902 with SQL Server 2017 on Windows Server 2019 published recently. I’ve added a new section to deal … Continue reading

Posted in 1902, baseline version, PowerShell, SQL Server 2017, TLS | Leave a comment

Install SQL Server 2017 PowerShell script – download it here

Introduction In case you missed it I wrote a PowerShell script to install SQL Server 2017 CU5 here. You  can install SQL Server 2017 with SSMS and Reporting Services using this PowerShell script. The original blog post was created to … Continue reading

Posted in PowerShell, SQL Server 2017 | Leave a comment