Update Collection Membership

·         On the Start menu, click SMS Administrator Console.
·         In the console tree, expand Site Database, expand Collections, and then click All Systems.
·         On the Action menu, point to All Tasks, and then click Update Collection Membership.
·         Click OK, and then on the Action menu, click Refresh.
·         Update the membership of the All Windows XP Systems collection.

Verify an SMS 2003 SP2 Installation
·         Start menu, point to All Programs, point to Systems Management Server, and then click SMS Administrator Console.
·         In the console tree, click Site Database, and then on the Action menu, click About Systems Management Server.
        The version of SMS displayed is SMS 2.50 SP2 (4160) which is SMS 2003 SP2
·         In the console tree, expand Site Database, and then click Site Hierarchy.
        The version of SMS installed on the local site server is 2.50.4160.2000 which is SMS 2003 SP2
·         Close the SMS Administrator Console window.

Prepare to Upgrade SMS 2003 SP2 to SCCM 2007
·         Click Start, Run, type in CMD, and hit Enter., In the command prompt, type in
        C:\SCCMCD\SMSSetup\Bin\I386\Setup.exe /prereq and hit Enter.
When complete, notice that there are two warnings displayed. One warning is for a missing update, KB897667. The   second is indicating that the Active Directory schema has not been extended for SCCM.
·         Start C:\SCCMCD\SMSSetup\Bin\I386\Extadsch.exe.
·         In the Microsoft System Center Configuration Manage Installation Prerequisite Check dialog box, click Run Check. Now   there will be only one warning displayed.

Create a backup of the SMS site database
·         From SQL Server Management Studio connect to the local SQL Server, SMSServer.
·         In the tree pane, expand Databases, right-click SMS_MCM, and then point to Tasks.
·         Click Back Up.
·         In the Database box, verify that SMS_MCM is listed, and then click Add.
·         In the File name box, add SMSTest to the end of the supplied path, and then click OK.
·         Click OK.
·         Right-click Databases, and then click New Database.
·         In the Database name box, type MCMBackup and then click OK.
·         In the tree pane, right-click MCMBackup, and then point to Tasks.
·         Point to Restore, and then click Database.
·         In the From database box, click SMS_MCM.
·         In the To database box, click MCMBackup.
·         In the tree pane, click Options.
·         Under Restore options, click Overwrite the existing database.
·         Under Restore the database files as, for .MDF type C:\SMSData\MCMBackup.mdf and for .LDF type   C:\SMSData\MCMBackup.ldf and then click OK

Test an upgrade of the SMS site database
·         Start a command prompt, and change the directory to the C:\SCCMCD\SMSSetup\Bin\I386 folder by typing in CD
·         Type Setup.exe /testdbupgrade mcmbackup
·         Click Begin TestDBUpgrade.
·         When Setup.exe terminates, open C:\ConfigMgrSetup.log.
·         Scroll to the bottom of the log file to see TestDBUpgrade is done.

Installing the SCCM 2007 setup
·         Start C:\SCCMCD\Autorun.exe.
·         Click Finish to complete the setup.

Verify SCCM 2007 Installation
·         Open C:\ConfigMgrSetup.log.
·         Open SMS Administrator Console.
·         In the tree pane, click SMS Console – SMSSERVER.
·         In the tree pane, expand SMSServer, and then click Site Management.
·         The version of SCM installed on the local site server is 4.00.5578.0000 which is SCCM 2007 beta 2.

Upgrading Clients to SCCM 2007
·         In the tree pane, expand SMSSERVER, expand Computer Management, expand Reporting, and then click Reports.
·         In the results pane, click Count SMS client versions, and then in the Actions pane, under Count SMS client versions, click Run.
·         Click OK to use the only reporting point in our site. We can see the old version in all the clients
·         In the tree pane, expand Collections, and then click All Windows XP Systems.
·         In the Actions pane, click Install Client and Click Next.
·         Click Always install (repair or upgrade the existing client), and then click Next.
·         Click Finish.

To verify the Advanced Client upgrade in the client machine goes toStart Task Manager.
We can notice that Ccmsetup.exe is running. This is the installation program for the client. When the Advanced Client has been upgraded to SCCM 2007, CcmExec.exe (SMS Agent Host) will appear, and then ccmsetup.exe will terminate. OpenControl Panel, start Systems Management. The Systems Management Properties dialog box appears. Notice the SMS Client Version listed. It should display 4.00.5578.0000, which is for SCCM 2007.