Category Archives: SQL

SCCM: Workaround for CB1610 replica MP issue (sp_BgbConfigSSBForRemoteService)

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 https://technet.microsoft.com/en-us/library/hh846234.aspx and https://sccmentor.com/2015/05/19/installing-a-replica-mp-in-configmgr-2012/… Read More »

SCCM 1606 + SQL 2016: Report subscription failed

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 ‘EXCEL’ is not… Read More »

SCCM Backup – Part 3 SQL Full backup

Why do we need site backup, and also need SQL Full back..because double backup for safety reason? 🙂 Site backup only backup the site database, that’s why it call “site backup”. If you use custom reports, or if you have any other database on the same server, you should run a SQL full backup, and of course do… Read More »