none
Upgrading to DPM2010 RRS feed

  • Question

  • Hi,

    we are upgrading to DPM2010 from DPM2007SP1 on local SQL2005 instance, when the setup checking the database sittings it saying that it will use the existing SQL2008 instance and it asks for the instance name?! When I put the instance name on format of ServerName\InstanceName the below error will appeared

    DPM Setup cannot query the SQL Server Reporting Services configuration.

    Verify that the Windows Management Instrumentation (WMI) service is running, and that your SQL Server Reporting Services installation is not corrupt.

    ID: 898


    Kind Regards, Reda Kotb Network Administrator Direct: +966 2 6572029 ext 808 reda.kotb@ibscoksa.com
    Monday, December 26, 2011 11:15 AM

Answers

  • Dear Wilson,

     

    After changing the registry Key Value to 0, the first option is active, I will complete the upgrade and let you know if there is any issues.

     

    Thank you. In advance.


    Kind Regards, Reda Kotb Network Administrator Direct: +966 2 6572029 ext 808 reda.kotb@ibscoksa.com
    • Marked as answer by Reda Ghazi Monday, February 20, 2012 11:34 AM
    Tuesday, December 27, 2011 8:51 AM

All replies

  • Hi Reda,

    DPM 2010 can be installed only on a SQL 2008 instance. What is happening is that we are querying WMI for SQL 2008 instance we can't find it.

    Just do the upgrade but let DPM 2010 install SQL. Part of the upgrade process is to copy the DPMDB on SQL 2005 and port it to SQL 2008.

     


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Monday, December 26, 2011 8:45 PM
  • Hi Wilson,

    Thank you for the reply, in the SQL server sittings there is two options to select; the first one is inactive for selection which is use the dedicated DPM2010 instance of SQL server......

    The other one is only active and it is selected which is: use an existing instance of SQL server 2008. when click next and put the SQL server information it given the error (DPM Setup cannot query the SQL Server Reporting Services configuration.

    Verify that the Windows Management Instrumentation (WMI) service is running and that your SQL Server Reporting Services installation is not corrupt.

    ID: 898)

     


    Kind Regards, Reda Kotb Network Administrator Direct: +966 2 6572029 ext 808 reda.kotb@ibscoksa.com
    Tuesday, December 27, 2011 6:50 AM
  • When you installed DPM 2007 did you let DPM install SQL or SQL was already installed?

    Currently, do you also have SQL 2008 installed on this DPM box?


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, December 27, 2011 6:54 AM
  • SQL was alredy installed, and the installed SQL is 2005 which we DPM2007 is using.
    Kind Regards, Reda Kotb Network Administrator Direct: +966 2 6572029 ext 808 reda.kotb@ibscoksa.com
    Tuesday, December 27, 2011 7:01 AM
  • Can you check the value for key RemoteYukon under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Data Protection Manager\Setup?


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, December 27, 2011 7:20 AM
  • the value of key RemoteYukon is 1.


    Kind Regards, Reda Kotb Network Administrator Direct: +966 2 6572029 ext 808 reda.kotb@ibscoksa.com
    Tuesday, December 27, 2011 7:26 AM
  • If there are no jobs running, stop DPM service, change that key to 0, start DPM server and then start the installation/upgrade.

    Check if the first option is no longer grayed out.

     

     


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, December 27, 2011 7:29 AM
  • Dear Wilson,

     

    After changing the registry Key Value to 0, the first option is active, I will complete the upgrade and let you know if there is any issues.

     

    Thank you. In advance.


    Kind Regards, Reda Kotb Network Administrator Direct: +966 2 6572029 ext 808 reda.kotb@ibscoksa.com
    • Marked as answer by Reda Ghazi Monday, February 20, 2012 11:34 AM
    Tuesday, December 27, 2011 8:51 AM