SQL Archives - Sandy's blog

How to query Infineon firmware TPM (Microsoft Advisory ADV170012) in ConfigMgr

October 19, 2017August 2, 2024Sandy Zeng3 Comments

If you don’t know what is this about, you must read this https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/ADV170012 Additional, in this article https://support.microsoft.com/en-us/help/4046783/bitlocker-mitigation-plan-for-vulnerability-in-tpm, it said When TPM-based protector is used to protect the operating system volume, the security of the BitLocker protection is affected only if the TPM firmware version is 1.2. But the script what Microsoft provided doesn’t include […]

SCCM: Workaround for CB1610 replica MP issue (sp_BgbConfigSSBForRemoteService)

January 9, 2017July 5, 2020Sandy Zeng2 Comments

Before you read this, please understand Microsoft does NOT supported this kind of direct SQL edit, so please do not use this “workaround” in production. This is also a knowing issue, hotfix from Microsoft will come later. UPDATED: KB4010155 update rollup fix this issue. https://support.microsoft.com/en-us/help/4010155/update-rollup-for-system-center-configuration-manager-current-branch-v I have been testing replica MP based on […]

SCCM 1606 + SQL 2016: Report subscription failed

November 14, 2016July 5, 2020Sandy Zeng18 Comments

Today my lovely handsome colleague Antti told me that SCCM report subscription doesn’t work, when tried to create report subscription send email attach with excel. Errors Web.Services.Protocols.SoapException: A delivery error has occurred. —> Microsoft.ReportingServices.Diagnostics.Utilities.DeliveryErrorException: A delivery error has occurred. —> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidExtensionParameter: One of the extension parameters is not valid for the following reason: The value […]