Upgrading Your ConfigMgr 2007 SQL 2005 Database Backend To SQL 2008

 

Provided here you will find the steps necessary to upgrade your ConfigMgr 2007 SQL Server 2005 backend to SQL Server 2008.

 

Note: This was tested on the following: Windows 2008 Enterprise Server Service Pack (SP) 1, ConfigMgr 2007 SP1 and SQL 2005 Server SP 2.

 

1. Apply the appropriate required hotfix below:

 

ConfigMgr 2007 RTM – No Service Pack

http://support.microsoft.com/kb/955229

 

ConfigMgr 2007 SP1

http://support.microsoft.com/kb/955262

 

2. Insert the SQL 2008 Server installation media and start Auto run if it does not start automatically or double click on Setup.Exe

 

3. Select “OK” at the Microsoft SQL Server 2008 Setup dialog box stating:

 

SQL Server 2008 setup requires Microsoft .NET Framework and an updated Windows Installer to be installed

To install these prerequisites and continue with Setup, click Ok. To exit Setup, click Cancel.

 

4. At this point the files will then be extracted and the Setup task process bar will start loading the installation components and may take several minutes to complete.

 

5. Next the Microsoft .NET Framework 3.5 SP1 Setup dialog box will appear. Review the license agreement and select ‘I have read and ACCEPT the terms of the License Agreement” and then select “Install” to begin.

 

6. The Download and Install Progress screen will appear and the install will begin and this process will take some time to install and can take from 5 to 15 minutes depending on your server speed and internet connectivity speed.

 

7. At the Setup Complete Microsoft .NET Framework 3.5 SP1 Setup dialog box stating: Microsoft .NET Framework 3.5 SP1 has been installed successfully select “Exit”

 

8. Reboot the server to finish installing the updates.

 

9. Log back onto the server and repeat step # 2 if necessary and allow several seconds for the SQL Server 2008 dialog box stating: Please wait while SQL Server 2008 Setup processes the current operation message disappears.

 

10. At the SQL Server Installation Center task list dialog box select “Installation” or select “Upgrade Documentation” for additional upgrade information.

 

11. From the Installation task pane select “Upgrade from SQL Server 2000 or SQL Server 2005” and wait for the message box in step # 9 to disappear.

 

12. At the SQL Sever 2008 Setup dialog box for the Setup Support Rules select “OK” to continue unless you have any “Failed” or “Warning”  issues that need to be resolved. If this is the case leave the dialog box open and then correct the issues to resolve them and select “Re-run” to initiate the checks again.

 

13. After the message box in step # 9 disappears at the Product Key task leaf enter your product key in the space provided and select “Next” to continue.

 

14. At the License Terms task leaf review the license terms and select “I accept the License Terms” and then select “Next”

 

15. At the Setup Support Files task leaf select “Install” to begin the upgrade process which will take just a few minutes to complete.

 

16. After the message box in step # 9 disappears at the Setup Support Files dialog review the Setup Support Rules task leaf status for any “Failed” or “Warning” status messages and then select “Next” to continue.

 

17. At the Select Instance task leaf select “Next” to continue.

 

18. At the Select Features task leaf accept the defaults or change them as needed and then select “Next” to continue.

 

19. At the Instance Configuration task leaf select “Next” to continue.

 

20. At the Disk Space Requirements task leaf select “Next” to continue.

 

21. At the Server Configuration task leaf select “Next” to continue.

 

22. At the Full-Text Upgrade task leaf accept the default of “Import” or select “Rebuild” or “Reset” as needed and then select “Next” to continue.

 

23. At the Error and Usage Reporting task leaf select “Next” to continue.

 

24. After the Upgrade Rules task leaf  completes select “Next” to continue.

 

25. At the Ready to Upgrade task leaf review your summary information or copy and paste the contents to a text file for later reference select “Upgrade” to start the upgrade process

 

26. The Upgrade Progress task leaf will then appear and will take quite some time to conclude up to an hour in some cases then select “Next” at the “Setup Process Compete” task pane.

 

27. At the Complete task leaf review the installation status and review the “Supplemental Information:” and then select “Close” to complete the install.

 

Notes:

 

  • When you choose to upgrade your SQL server to SQL 2008 the previous versions program group and files are not removed by design and you must uninstall the pervious version using Programs and Features to remove them

 

  • SQL 2008 is not backward compatible with SQL 2000 or SQL 2005 and as a result you must upgrade any workstations or servers to the new version to resolve any comparability issues.

 

  • To avoid having to compete the first few steps of the upgrade process above you can download and install Microsoft .NET Framework 3.5 SP1 and Windows Installer 4.5 before beginning the installation found below.

 

Microsoft .NET Framework 3.5 SP1

http://go.microsoft.com/fwlink/?LinkId=120550

 

Windows Installer 4.5

http://support.microsoft.com/KB/942288

 

 

 

Published Sunday, October 05, 2008 2:41 PM by dhite
Filed under:

Comments

No Comments