I'm Rob Marshall, a consultant who specialises in the Microsoft System Center Configuration Manager product. I like to share, i do so by blogging and helping out when I can in the MS SMS newsgroups and participating in the ConfigMgr MVP program.
I was awarded and joined the program in 2009. It'd be an understatement to say it has to be one of the best experiences an IT engineer can have, if they really enjoy specialising in a product.
My biggest weapon for troubleshooting is, my formidable knowledge, no, only joking, you, the community. I find if I cannot answer a question, then I can usually find the answer from using Bing\Google, pouring over the documentation, and if that doesn't work, tinkering in mine or someone elses virtual lab.
The blogs pretty much about ConfigMgr, but it is also a platform for me to express my random urges to display something I've stumbled across, and that I imagine would entertain you or what not as equally as it did me.
Useful tips on issues that can surface when installing a (latest) ConfigMgr Service Pack
This document was created to help in troubleshooting Configuration Manager Service Pack 2 (SP2) install failures. This document is not entirely specific to Service Pack 2 and can apply to Service Pack 1 installs, upgrades from SMS 2003 to SCCM, and future service pack or Configuration Manager versions that rely on .mof file compilations, SQL SPNS, provider DLLs, etc.
Section 1 Pre-Upgrade Best Practices
Section 2 General Troubleshooting
Section 3 List of Known Issues and Solutions:
A: SPN issues with SQL B: Time Skew between remote SQL and Site Server C: Re-Registering relevant files / errors attempting to re-register needed files. D. Deleting Temp Files, setting Temp variables. E. Searching for a "bad" custom or customized report F. Checking for pre-existing duplicate reports that are new to SCCM SP2 G. Upgrade fails due to registry setting. H. Site System does not have rights to remote SQL System or Clustered SQL Nodes [Read More...] (Thanks to Jannes Alink, MVP in ConfigMgr for offering up this link)
A: SPN issues with SQL
B: Time Skew between remote SQL and Site Server
C: Re-Registering relevant files / errors attempting to re-register needed files.
D. Deleting Temp Files, setting Temp variables.
E. Searching for a "bad" custom or customized report
F. Checking for pre-existing duplicate reports that are new to SCCM SP2
G. Upgrade fails due to registry setting.
H. Site System does not have rights to remote SQL System or Clustered SQL Nodes
[Read More...]
(Thanks to Jannes Alink, MVP in ConfigMgr for offering up this link)
An issue I saw with a recent primary site upgrade to SP2 was with Asset Intelligence data in the DB causing the ConfigMgr 2007 SP2 to fail to install during the AI section of setup ... we had to identify the offending rows and remove them from the database before we could complete the upgrade. Think this might be a one-off, but if you experience it let me know!