none
Upgrading DPM 2012 SP1 to DPM 2012 R2 fails (DPM Setup is unable to connect to the specific instance of SQL Server Reporting Service (ID: 33431) RRS feed

  • Question

  • The Background:

    1.  DPM 2012 SP1 was originally installed on a server with local SQL 2008 R2 instance (SQL was installed as part of DPM)

    2.  SQL database was upgraded to SQL 2012 SP1

    Now I want to upgrade DPM 2012 SP1 CU3 to R2.  It is throwing the following error.  Any help would be appreciated. 

    Friday, November 1, 2013 3:08 AM

Answers

  • well guys, i hope u are well, but i found the solution:

    spent 2 days for that, tried different solutions, restoring vm from snapshot etc

    i have 2012 server os upgraded from 2008R2 SP1

    DPM 2012 SP1 upgraded from 2012 version, and builtin SQL upgraded to 2012.

    SQL server is also upgraded to SP1 and latest CU

    SQL 2008R2 removed manually.

    when doing upgrade DPM 2012 to R2 version from 2012 sp1, log have the following error entry (log location C:\Program Files\Microsoft System Center 2012 R2\DPM\DPMLogs) and same error popups in GUI

    Information : Querying WMI Namespace: \\DPMserver\root\Microsoft\SqlServer\ReportServer\RS_MSDPM2012\v10\admin for query: SELECT * FROM MSReportServer_ConfigurationSetting WHERE InstanceName='MSDPM2012'

    v10 is SQL server 2008 R2

    correct one is v11 (SQL 2012 )

    so we will now check the wmi

    open wbemtest, connect to \\DPMserver\root\Microsoft\SqlServer\ReportServer\RS_MSDPM2012

    run the following query: "SELECT * FROM __NAMESPACE" without the quotes

    u will see two instances of ReportServer

    V10 and v11

    select V10 and press delete

    that's all after that DPM setup will continue

    Tuesday, May 27, 2014 11:34 AM

All replies

  • Hi

    Do you have the correct name in for the SQL instance?

    Tuesday, November 5, 2013 8:49 AM
  • Same error - saw on a SQL profiler trace that the install was executing the following:

    SELECT IS_MEMBER('BUILTIN\Administrators')

    SELECT IS_SRVROLEMEMBER('sysadmin')

    It then immediately logs out of SQL and throws the above error.  Both SQL functions return a 1 (true) from Mgmt Studio under the same identity (domain admin).

    SQL 2012 (11.0.3128) DPM 2012 R2 fresh install on Server 2012 

    Also, the more info link on the window returns a page not found

    http://technet.microsoft.com/en-us/library/ee958049.aspx

    Wednesday, November 6, 2013 1:43 AM
  • I solved my issue by installing SQL reporting services - it was trying to connect to port 80 afterward on the same host and that was causing the error.  
    Wednesday, November 6, 2013 3:45 AM
  • Hello Ben,

    I have the same issue but I am not able to solve it like you say. What do you mean by installing SQL reporting services? You should have installed it before upgrading. So what do you mean reinstalling, repair or uninstall and install again?

    Please specify exactly what you have made.

    Thanks and best regards

    Christo

    Saturday, November 16, 2013 9:11 AM
  • Hello,

    I have the same issue as Christo, SQL reporting services is already installed.

    Alex

    Wednesday, November 20, 2013 3:56 PM
  • Check that reporting services is using the same instance name as SQL server. Look in Windows Service manager, via computer management, or services.msc, and check that the name in brackets for SQL Server Reporting Services matches that for SQL Server.

    Also check that Report Server is configured, look for warning symbols in the Reporting Services Configuration Manager.

    Friday, December 13, 2013 5:02 PM
  • Same exact scenario as above. Reporting services installed, running and no errors. SQL Server 2012 SP1, DMP 2012 SP1
    Thursday, January 9, 2014 8:49 PM
  • Has anyone found a fix?  I have checked everything mentioned here and all is working or setup correct, yet still get the error.  I successfully installed DPM 2012 R2 on our primary DPM server, but cannot get the secondary to install due to the error above.  It is odd as these are identical setups, so finding the problem has been frustrating.

    BF

    Saturday, March 15, 2014 6:09 PM
  • Only thing that worked for me was to backup the SQL DB and Agent jobs, uninstall DPM, uninstall SQL, install SQL 2012 but this time as the default instance instead of a named instance, install DPM 2012 SP1, restore DB and jobs, then upgrade to DPM 2012 R2. This worked well for the server but the agents had to be manually upgraded afterward.
    Wednesday, March 19, 2014 3:13 AM
  • well guys, i hope u are well, but i found the solution:

    spent 2 days for that, tried different solutions, restoring vm from snapshot etc

    i have 2012 server os upgraded from 2008R2 SP1

    DPM 2012 SP1 upgraded from 2012 version, and builtin SQL upgraded to 2012.

    SQL server is also upgraded to SP1 and latest CU

    SQL 2008R2 removed manually.

    when doing upgrade DPM 2012 to R2 version from 2012 sp1, log have the following error entry (log location C:\Program Files\Microsoft System Center 2012 R2\DPM\DPMLogs) and same error popups in GUI

    Information : Querying WMI Namespace: \\DPMserver\root\Microsoft\SqlServer\ReportServer\RS_MSDPM2012\v10\admin for query: SELECT * FROM MSReportServer_ConfigurationSetting WHERE InstanceName='MSDPM2012'

    v10 is SQL server 2008 R2

    correct one is v11 (SQL 2012 )

    so we will now check the wmi

    open wbemtest, connect to \\DPMserver\root\Microsoft\SqlServer\ReportServer\RS_MSDPM2012

    run the following query: "SELECT * FROM __NAMESPACE" without the quotes

    u will see two instances of ReportServer

    V10 and v11

    select V10 and press delete

    that's all after that DPM setup will continue

    Tuesday, May 27, 2014 11:34 AM
  • This absolutely fixed my issue.  I had upgraded my version of SQL and was then trying to upgrade DPM 2012 to 2012R2 and I could not figure out where the installation was querying old version of the reporting services.

    DPM Log Before:

    [6/4/2014 2:53:32 PM] Information : Query WMI provider for path of configuration file for SQL Server 2008 Reporting Services.
    [6/4/2014 2:53:32 PM] Information : Querying WMI Namespace: \\DPMServer\root\Microsoft\SqlServer\ReportServer\RS_MSDPM2012\v10\admin for query: SELECT * FROM MSReportServer_ConfigurationSetting WHERE InstanceName='MSDPM2012'
    [6/4/2014 2:53:32 PM] * Exception :  => System.Management.ManagementException: Provider load failure

    DPM Log After:

    [6/4/2014 3:25:36 PM] Information : SQL Server 2008 R2 SP2 instance MSDPM2012 is not present on this system.
    [6/4/2014 3:25:36 PM] Information : Query WMI provider for SQL Server 2008.
    [6/4/2014 3:25:36 PM] Information : Querying WMI Namespace: \\DPMServer\root\Microsoft\SqlServer\ComputerManagement11 for query: Select * from SqlServiceAdvancedProperty where ServiceName='MSSQL$MSDPM2012' and PropertyName='Version'
    [6/4/2014 3:25:36 PM] Information : SQL Server 2008 R2 SP2 instance MSDPM2012 is present on this system.
    [6/4/2014 3:25:36 PM] Information : Inspect context initialized with
    SQL Server namespace: \\{0}\root\Microsoft\SqlServer\ComputerManagement11
    Reporting namespace: \\{0}\root\Microsoft\SqlServer\ReportServer\RS_{1}\v11\admin
    SqlServerDetected: True
    [6/4/2014 3:25:36 PM] Information : Check if SQL Server 2012 Service Pack 1 Tools is installed.
    [6/4/2014 3:25:36 PM] Information : Inspect.CheckSqlServerTools : MsiQueryProductState returned : INSTALLSTATE_DEFAULT
    [6/4/2014 3:25:36 PM] Information : **********************************************************************************

    Thanks for This FIX!

    Wednesday, June 4, 2014 10:33 PM
  • This worked, Thank You.
    Friday, February 20, 2015 9:00 AM