Uninstall SQL 2005

After a successful upgrade from DPM 2007 to DPM 2010 you can safely remove the SQL 2005 instance. The steps are shown below. Steps are for a local instance of SQL.

 
1) Start Program and features. Find SQL 2005 and select uninstall

 
2) Select the MS$DPM2007$ instance, also select the Workstation Components and click next.

3) Check the confirmation window and click Finish.

 
4) On Windows 2008 R2 you could receive the message “the program has known compatibility issues” Click Run Program.

5) When you receive the error. The following applications should be closed before continuing the installation.

6) Stop all related SQL 2005 services
-SQL server (MS$DPM2007$)
-SQL server agent (MS$DPM2007$)
-SQL server Reporting service MS$DPM2007$)

7) Press retry and the de-installation will complete

DPM 2010 SQL (Reporting) service crashes

Checking the event log of the DPM server I found the following errors.

----------error 1------------------
Log Name:      Application
Source:        Report Server Windows Service (MSDPMV3BETA1EVAL)
Date:          5/22/2010 5:55:58 PM
Event ID:      139
Task Category: Startup/Shutdown
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      xxxxxxx.c2ict.com
Description:
The application domain WindowsService_0 failed to start. Error: Microsoft.ReportingServices.Diagnostics.Utilities.EvaluationCopyExpiredException: The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.
----------error 1------------------

----------error 2------------------
Log Name:      Application
Source:        Report Server Windows Service (MSDPMV3BETA1EVAL)
Date:          5/22/2010 5:55:58 PM
Event ID:      136
Task Category: Activation
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      xxxxxx.c2ict.com
Description:
The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired.  A license is now required.
----------error 2------------------

----------error 3------------------
Log Name:      Application
Source:        Report Server Windows Service (MSDPMV3BETA1EVAL)
Date:          5/22/2010 5:55:57 PM
Event ID:      107
Task Category: Management
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      xxxxxx.c2ict.com
Description:
Report Server Windows Service (MSDPMV3BETA1EVAL) cannot connect to the report server database.
----------error 3------------------

The service manager shows also that the SQL and SQL reporting services could not start and stopped

Checking the installed SQL instances shows that there is a second instance still active from the previous (beta) version of DPM 2010.

This instance can successfully be removed using the remove program wizard in the control panel.
Select remove.

 

Select the old/expired instance

DPM 2010 upgrade Advisor

Now that the final version is (nearly) available for download it time to plan the upgrade.

There are various versions of Operating system, SQL and DPM from which you can upgrade to DPM2010. These different versions also require different upgrade scenarios. The upgrade advisor developed by the Microsoft DPM team can help you with that. Enter your current configuration and the upgrade path will be displayed.

 

 

 

 

 Download link to the DPM 2010 Upgrade Advisor