SCCM by Davis: “DCOM error related to SCCM” plus 19 more

DCOM error related to SCCM
SCCM 2012 SP1 Upgrade Checklist
Garth Jones wrote a new post, Inventory of Video card with Sound card
Chris Nackers wrote a new post, Windows 8 DeDuplication = Awesome
Google Fiber Now Proposed for Residents of Provo, Utah
OpenStack Winning Converts Among Large Enterprises
Bruce McCall joined the group System Center Configuration Manager 2007
Technical Lead became a registered member
Jennifer Shaffer joined the group SCCM Right-click tools
Garth Jones wrote a new post, Video card with Sound card.
Video card with Sound card.
Guenther Raudaschl joined the group Configuration Manager Queries, Reports, and MOFs
Guenther Raudaschl joined the group ConfigMgr 2012 Application Exports
Guenther Raudaschl joined the group Application Deployment
Guenther Raudaschl joined the group System Center Configuration Manager 2012
Guenther Raudaschl joined the group Operating System Deployment
Guenther Raudaschl joined the group SCCM Right-click tools
Guenther Raudaschl joined the group Script Gallery
Garth Jones wrote a new post, Video Card Details Inventory v2
Michel Boudreault became a registered member

Posted: 04 Mar 2013 10:10 AM PST

Artigo bem completo explicando funcionamento do SCCM em relação ao DCOM.

http://windoh.wordpress.com/2012/05/23/dcom-error-related-to-sccm/

SCCM 2012 SP1 Upgrade Checklist

Posted: 03 Mar 2013 09:08 PM PST

Alright, everyone else has a checklist — time for mine . Here's how we're installing SCCM 2012 SP1. Once again, this is based off of my internal documentation, so it's not as polished as it really should be for the open web. I've been putting off blogging for so long — it's time to just get something out there and see if it helps anyone.

Overview

Configure Site Backups
Spin Up a SQL Server Test VM
Test the Database Upgrade
Disable Site Maintenance Task
Backup Boot Image Customizations
Upgrade from WAIK to ADK
Install WSUS Hotfix
Run the Prereq Checker
Run the SP1 Install

You can download an actual excel checklist from the John Puskar Github Repo.

This is going to be a long post…

Step-By-Step

Configure Site Backups

Administration -> Site Configuration -> Sites -> CAS -> Settings -> Site Maintenance
Backup Site Server -> Edit
Enable this task
Set paths -> Local Drive -> F:\Backups
Start time — 5mins from now. Latest start time -> 1hr after start time.
OK to save.
Wait and get the backup.

Spin Up a SQL Server Test VM

80GB Free space
Install MS SQL — same version as the one which produced the database backup.
Install MS SQL Server 2012 Native Client. Download from here. You have to click 'download', then ignore the text file that gets downloaded and scroll to the middle of the download confirmation page. Microsoft® SQL Server® 2012 Feature Pack

Test the Database Upgrade

Login to the test server using a domain account that has local administrator and SQL sysadmin privileges.
Copy the SCCM Site Backup folder from SCCM server to test server.
Open SQL Server Management Studio.
Right-click the SQL Server and choose 'attach'.
Navigate to the backup folder and select the MDF file found in the site server backup folder.
Click OK to attach the db.
In SQL Server Management Studio, navigate to Security -> Logins.
Right-click the account or group which represents your current login and choose 'properties'.
Choose 'User Mapping' from the left-pane, then select your attached site server database.
Check the box next to the site database backup in the 'map' column.
Check the 'db_owner' box in the bottom pane.
Click OK to save changes.
Open a command prompt as administrator and navigate to .\sccm2012sp1\smssetup\bin\x64.
Run setup.exe /testdbupgrade <dbname> (ex: cm_cas)
Prerequisite checker should pass.
Click 'next' to attempt the upgrade.
Watch task manager for the sqlservr.exe process' CPU usage. It will spike for 20mins or more.
When the sqlservr.exe process seems to be idle, open the file C:\configMgrSetup.log. It should read 'Successfully upgraded the SCCM database'.

Disable Site Maintenance Task

Open SCCM Console on the CAS and navigate to Administration -> Site Configuration > Sites.
Right-click the CAS site and choose 'Site Maintenance'.
Select the task 'Delete Aged Client Operations'.
Click the 'disable' button and confirm that the column labeled 'Enabled' reads 'No' next to the task.
Click 'OK' to save changes.

Backup Boot Image Customizations

Run the following commands and confirm that the files are actually copied.

MKDIR C:\backups  MKDIR C:\backups\bootimages  MKDIR C:\backups\bootimages\Extra  IF EXIST "C:\Program Files\Microsoft Configuration Manager\OSD\Extra" XCOPY /e /y "C:\Program Files\Microsoft Configuration Manager\OSD\Extra" C:\backups\bootimages\extra\  XCOPY /y "C:\Program Files\Microsoft Configuration Manager\bin\x64\osdinjection.xml" C:\backups\bootimages\

Upgrade from WAIK to ADK

Obtain the ADK Downloader, and download the full ADK installer. The downloader is available here: Windows Assessment and Deployment Kit (ADK) for Windows 8
Uninstall WAIK from control panel.
Run the ADK installer.
Choose to install the following features
- Deployment Tools
- Windows Preinstallation Environment (Windows PE)
- User State Migration Tool (USMT)

Install WSUS Hotfix

Download the following hotfix and install.

KB2734608

Run the Prereq Checker

Navigate to .\smssetup\bin\x64 and double-click 'prereqchk.exe'.
You will probable see a SQL Server process memory allocation error, but that should be the only issue.

Run the SP1 Install

WOOOOOOOO!
Run the following command:
```
cmd /c mkdir C:\SCCMDownloads-SP1
```
Navigate to .\smssetup\bin\x64 and double-click 'setup.exe'.
On the 'Getting Started' screen, choose to 'Upgrade this Configuration Manager site'
On the 'Product Key' screen, enter the licensing information and click 'next'.
On the 'Microsoft Software License Terms' screen, choose 'I accept' and click 'next'.
On the 'Prerequisite Licenses' screen, accept all the license terms and click 'next'.
On the 'Prerequisite Downloads' screen, choose the download required files to C:\SCCMDownloads-SP1 and click 'next'.
On the 'Server Language Selection' screen, click 'Next'.
On the 'Client Language Selection' screen, click 'Next'.
On the 'Settings Summary' screen, confirm that the box reads 'Setup Type – Upgrade', then click 'Next'.
On the 'Prerequisite Check' screen, click 'Begin Install'.
Complete the wizard.

One thing I noticed is that database replication doesn't work well until all the site servers are upgraded. Good luck!

Garth Jones wrote a new post, Inventory of Video card with Sound card

Posted: 18 Apr 2013 07:41 PM PDT

For full details please see

http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740

select distinct
R.Netbios_Name0 as 'Name',
[…]

Comments: 0

Chris Nackers wrote a new post, Windows 8 DeDuplication = Awesome

Posted: 18 Apr 2013 02:22 PM PDT

Posted in HCIDKIDT Server 2012 Windows 8!-- Start Shareaholic LikeButtonSetTop Automatic --!-- End Shareaholic LikeButtonSetTop Automatic --I do really love my Asus Zenbook, it's the fastest lightest laptop I've […]

Comments: 0

Google Fiber Now Proposed for Residents of Provo, Utah

Posted: 18 Apr 2013 02:25 PM PDT

Google is continuing the expansion of its high-speed Internet and cable TV Google Fiber service by proposing plans to deploy it next in Provo, Utah.

OpenStack Winning Converts Among Large Enterprises

Posted: 18 Apr 2013 02:22 PM PDT

Major enterprises, including BestBuy, Comcast, HubSpot and Bloomberg, are making major commitments to OpenStack for their IT infrastructures.

Bruce McCall joined the group System Center Configuration Manager 2007

Posted: 18 Apr 2013 01:03 PM PDT

Comments: 0

Technical Lead became a registered member

Posted: 18 Apr 2013 12:43 PM PDT

Comments: 0

Jennifer Shaffer joined the group SCCM Right-click tools

Posted: 18 Apr 2013 12:20 PM PDT

Comments: 0

Garth Jones wrote a new post, Video card with Sound card.

Posted: 18 Apr 2013 11:50 AM PDT

For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct
R.Netbios_Name0 as 'Name',
R.User_Name0 as […]

Comments: 0

Video card with Sound card.

Posted: 18 Apr 2013 11:50 AM PDT

For full details please see

http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740

select distinct       R.Netbios_Name0 as 'Name',      R.User_Name0 as 'User',      CS.Manufacturer0 as 'Manufacturer',       CS.Model0 as 'Model',      BIOS.SerialNumber0 as 'Serial',      SD.Name0 as 'Processor',       RAM.TotalPhysicalMemory0 as 'Memory',      VC.Name0 as 'Video Card',       VC.VCRam as 'Video Card RAM',      Sound.Description0 as 'Sound card'  from        dbo.v_R_System R       inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId       inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID       inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId       inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.ResourceID = R.ResourceId       left outer join dbo.v_GS_SOUND_DEVICE Sound on Sound.ResourceID = R.ResourceId       left outer join (          select                   VC.ResourceID,              VC.Name0,              Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'VCRAM'          from               dbo.v_GS_Video_Controller VC           Where              VC.Name0 != 'ConfigMgr Remote Control Driver'              and VC.AdapterRam0 is not null) VC on  R.ResourceID = VC.ResourceId   where       SD.CompatibleIDs0 = 'ACPI\Processor'