Moving the SCUP database after installation

After installing System Center Updates Publisher (SCUP) 2011 configuration must be done. SCUP can be connected to a WSUS or SCCM/ConfigMgr 2007 and/or 2012 installation. Just use Update Server or ConfigMgr Server for that. Something else that must be done is moving the SCUP database. This because the database is placed in the active user profile. Oops! In this blogpost I will explain (in a few steps) what must be done.
 

 

By default the SCUPDB.SDF is placed in the [C:\Users\<username>\AppData\Local\Microsoft\System Center Updates Publisher 2011\5.00.1727.0000] folder. This can be checked at Advanced options. To move the database just close the SCUP console. Open the Scup2011.exe.config file, which can be found in the SCUP installation folder.
 

For example: Beneath <Scup.Properties.Settings> and <setting name="SSCEDataFile" serializeAs="String"> add the following line:

<value>D:\SCUP2011\5.00.1727.0000\scupdb.sdf</value>



This way the database is expected on another location. Just move the SCUPDB.SDF file to the same location configured in the Config file. After configuring both steps start the SCUP console again. Have a look at Advanced options again, and see above results. The database is moved to a better place now!

Integrate System Center Updates Publisher (SCUP) 2011 with ConfigMgr

With System Center Configuration Manager (ConfigMgr) and WSUS integrated, it's possible to install and use System Center Updates Publisher (SCUP) 2011 also (free usage). With SCUP 2011 you can create and install packages that's not in WSUS by default. That way updates from DELL, HP and ADOBE (for example) can be used in your existing WSUS installation for deploying to clients. By default there are some catalogs that can be imported in SCUP 2011. Manually created packages from JAVA (for example) can be used also.

First download and install SCUP 2011 from the following website:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11940
Microsoft DotNet 4.0 is needed on the server to have SCUP 2011 installed.

After that install the following hotfix on the server (needed for the Signing certificate):
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=20689 (x86)
or http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=12390 (x64)

When SCUP 2011 is installed successfully choose Options. Choose "Enable publishing to an update server" and create an Signing certificate also. On the next tab select "Enable Configuration Manager integration". Now open a Management Console with the Certificates component in it.

The Signing certificate created will be available in the WSUS Certicate folder after configuraton. Choose copy, and past in on both "Trusted Root certification" and "Trusted Publishers". There is also the choice to save a local copy from it. That way it can be published bij Group Policy if needed for client computers. The Management Console can be closed after that.

Best thing now is to reboot the server, and open the SCUP 2011 console again. Now it's time to import the default catalogs and create additional packages yourself. After synchronization these updates will be available in ConfigMgr. Just select the updates needed, choose Assign and Publish to create them. When synchronization with WSUS is done, they will be available in ConfigMgr.

Kent Agerlund, ConfigMgr MVP, wrote a great getting starting guide to System Center Updates Publisher 2011 up on his blog. Check it out here
http://blogs.technet.com/b/jasonlewis/archive/2011/06/13/scup-2011-installation-amp-configuration-guide.aspx