Video Tutorial: How to deploy Office 2013 App-V package with System Center 2012 Configuration Manager

I made a video tutorial on how to deploy a virtual Office 2013 application to a Windows 8 desktop client with System Center 2012 Configuration Manager SP1 Beta.

Check it out on youtube!


Installing SCCM 2012 Prerequisites

Recently I had to install several SCCM 2012 servers with different Site Server Roles. So I thought it would be a good idea to do this unattended with the help of a batch file. I created the following table that might be handy to sort out all the different prerequisites command lines.

Because it was kind of difficult to edit the table in the post editor I created a picture of the table and included an extra table with the specific command lines so you can copy it for your own purpose.

PreReq Command Line
NET Framework 3.51 Core ServerManagerCmd.exe   -install NET-Framework-Core
NET Framework 3.51 Full ServerManagerCmd.exe   -install NET-Framework
Default IIS configuration ServerManagerCmd.exe   -install Web-WebServer
Remote Diff Compression ServerManagerCmd.exe   -install RDC
ISAPI Extensions ServerManagerCmd.exe   -install Web-ISAPI-Ext
Windows Authentication ServerManagerCmd.exe   -install Web-Windows-Auth
IIS 6 Metabase Compat ServerManagerCmd.exe   -install Web-Metabase
IIS 6 WMI Compat ServerManagerCmd.exe   -install Web-WMI
IIS 6 Mgmt Compat ServerManagerCmd.exe   -install Web-Mgmt-Compat
ASP.NET ServerManagerCmd.exe -install Web-Asp-Net
Dynamic Content Comp ServerManagerCmd.exe -install Web-Dyn-Compression
Static Content Comp ServerManagerCmd.exe   -install Web-Static-Content
Default Document ServerManagerCmd.exe   -install Web-Default-Doc
BITS ServerManagerCmd.exe   -install BITS
WDS ServerManagerCmd.exe   -install WDS
BranchCache ServerManagerCmd.exe   -install FS-BranchCache
Network Policy Server ServerManagerCmd.exe   -install NPAS-Policy-Server
NET Framework 4.0 dotNetFx40_Client_x86_x64.exe   /q /norestart
WSUS 3.0 SP2
WSUS 3.0 Update

Hope this helps with your own SCCM implementations.
Best regards,

SCCM 2012 Software Update Synchronization Fails with Unknown SQL Errors

Yesterday I started to configure the Site Server role Software Update Point in SCCM 2012 at a large Dutch Accounting company. We have installed a Central Administration Site with a dedicated SQL 2008 R2 server and a Primary Site also with a dedicated SQL 2008 R2 server. Both SQL environments were installed by the company DBA team.  After configurering the Software Update Point role I started a manual synchronization of the Classifications and Products I selected. I opened the WSUS synchronization log file wsyncmgr.log to see how synchronization occured. When synchronization started I noticed some strange error messages saying:

*** *** Unknown SQL Error!
Failed to sync update 9703dec9-deaf-4566-b966-aeca447a4ba4. Error: Failed to save update a9d8e639-6d3e-4d7c-9ded-0a15c078cc8b. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate

After some seaching on the Internet (thanks to Carl Tsigakis from Microsoft) I found a similar issue at this blog and another one

Then I checked my database settings because the DBA team moved also my SCCM databases to separate locations for the MDF and LDF files for performance reasons. Indeed my database settings where different than they should be. I dubble checked it with my own lab environment. So here is what I checked and changed:

1. Check the database ownership in SQL Management Studio using the query:

  • Exec sp_helpdb
2. Changed the database ownership back to ‘sa’ using the query:

  • USE [SCCM_Db] GO EXEC sp_changedbowner ‘sa’
3. Check the TRUSTWORTHY property on the SCCM database.

  • Right click on SCCM database
  • Select options and look for trustworthy property in the list of DB options
4. Change the TRUSTWORTHY property on the SCCM database using the SQL query:


After changing back the database ownership to ‘sa’ and set the TRUSTWORTHY property to ON, I was able to synchronize successfully. Because I had the exact same databases settings for my Primary Site I changed them also.

Yet another lesson learned “Watch carefully to the database ownership and trustworthy property when you move SCCM databases after the installation!!!

Hope this helps for you.
Best regards