none
Installation of DPM 2010 fails with remote instance of SQL 2008 R2 RRS feed

  • Question

  • I tried to install DPM 2010 and link it to a remote instance of SQL 2008 R2. It failed with the following message:

    "Report configuration failed.

    Verify that SQL Server Reporting Services is installed properly and that it is running.

    ID: 812"

    I can see no issues with the reporting services on the SQL server, and suggestions will be most welcome.

     

    • Moved by Parag Agrawal Tuesday, August 17, 2010 10:11 AM Setup and install related Qs (From:Data Protection Manager)
    Wednesday, May 26, 2010 2:23 PM

Answers

  • Hey Wim,
     
    As far as I have heard it, it is under investigation, so I suspect we will need to wait for a hotfix rollup or patch or whatever before we can start using R2.  But they are looking into it, the problem is with the SQL team, they work too fast for the rest to follow
     
    Cheers,
     
    Mike Resseler
    "Wim Panhorst" wrote in message news:fc904466-8691-4270-87ee-9afaae4bf430...

    Hi Mike,

    I just created a new DPM 2010 server, and another server with an instance of SQL 2008 (so no R2!). All accounts for the SQL services were domain accounts. This time the installation of DPM 2010 completed successfully. So your assumption of SQL 2008 R2 not supporting DPM 2010 is right. Many thanks.

    Question for Microsoft: I prefer to run SQL 2008 R2, if only for the reason that I do not like a dedicated SQL setup for DPM 2010. Will it be supported, and when?

    Thanks, Wim


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    • Marked as answer by Wim Panhorst Friday, May 28, 2010 6:12 AM
    Thursday, May 27, 2010 6:34 PM
    Moderator

All replies

  • I was just running into this as well. Is your SSRS instance running under a domain account?
    Jeff Graves, ORCS Web, Inc.
    Wednesday, May 26, 2010 2:32 PM
  • You should also check the name of the remote instance you have created.  Try to avoid special characters - notably $ - as this can cause issues especially with remote instances.  I ran into something very similar when testing this and used a remote instance name of MS$DPM2010$.  I created a new instance and gave it the name of MSDPM2010 (the new default name for DPM 2010) and it worked fine.
    Thanks, Chris - [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights
    Wednesday, May 26, 2010 6:12 PM
  • Hi Jeff and Chris,

    SSRS runs under a domain account, and the instance name has no special characters.

    Thanks, Wim

    Thursday, May 27, 2010 7:57 AM
  • Hey Wim,
     
    Did you say SQL server 2008 R2?  Because it is not yet supported for DPM, only SQL server 2008.
    Did you check your IIS configuration? In IIS 7.5, navigate to the "Default Web Site/ReportserverINSTANCEfromDPM" 
    Then click on handler mappings, then go to Edit Feature Permissions and make sure that Read and Script are selected
    If not, restart IIS completely to make sure that it is activated
     
    Cheers,
     
    Mike Resseler
     
     
    "Wim Panhorst" wrote in message news:323232ed-f0f8-4466-b243-43828b4f89b2...

    Hi Jeff and Chris,

    SSRS runs under a domain account, and the instance name has no special characters.

    Thanks, Wim


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Thursday, May 27, 2010 8:19 AM
    Moderator
  • Hi Mike,

    There isn't a path to "ReportserverINSTANCEfromDPM" yet, I don't think that the installation of DPM2010 came that far. Your idea about not supporting R2 is interesting, and I will test it out. I will create a new VM with SQL 2008, and let you know if this changes things.

    Thanks, Wim

    Thursday, May 27, 2010 8:54 AM
  • I ran into that same issue. If you check the DPM install log, you may see something like DPM01$DPMAdministrators group not recognized. It happens when the SSRS service is running under a domain user.

    Also, SSRS 2008 uses http.sys now instead of IIS, so there won't be any vdir in IIS.


    Jeff Graves, ORCS Web, Inc.
    Thursday, May 27, 2010 1:26 PM
  • Hi Mike,

    I just created a new DPM 2010 server, and another server with an instance of SQL 2008 (so no R2!). All accounts for the SQL services were domain accounts. This time the installation of DPM 2010 completed successfully. So your assumption of SQL 2008 R2 not supporting DPM 2010 is right. Many thanks.

    Question for Microsoft: I prefer to run SQL 2008 R2, if only for the reason that I do not like a dedicated SQL setup for DPM 2010. Will it be supported, and when?

    Thanks, Wim

    Thursday, May 27, 2010 3:30 PM
  • Hey Wim,
     
    As far as I have heard it, it is under investigation, so I suspect we will need to wait for a hotfix rollup or patch or whatever before we can start using R2.  But they are looking into it, the problem is with the SQL team, they work too fast for the rest to follow
     
    Cheers,
     
    Mike Resseler
    "Wim Panhorst" wrote in message news:fc904466-8691-4270-87ee-9afaae4bf430...

    Hi Mike,

    I just created a new DPM 2010 server, and another server with an instance of SQL 2008 (so no R2!). All accounts for the SQL services were domain accounts. This time the installation of DPM 2010 completed successfully. So your assumption of SQL 2008 R2 not supporting DPM 2010 is right. Many thanks.

    Question for Microsoft: I prefer to run SQL 2008 R2, if only for the reason that I do not like a dedicated SQL setup for DPM 2010. Will it be supported, and when?

    Thanks, Wim


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    • Marked as answer by Wim Panhorst Friday, May 28, 2010 6:12 AM
    Thursday, May 27, 2010 6:34 PM
    Moderator
  • Hi Mike,

    We have to wait then. I hope though that Microsoft moves a bit fast. It is a bit messy that some products of MS support R2, but others don't. Many thanks for your help.

    Vriendelijke groeten/kind regards,

    Wim

    Friday, May 28, 2010 6:11 AM
  • Hi,

    is there any update to DPM 2010 using SQL Server 2008 R2 yet?

    Thanks, Werner

    Tuesday, August 10, 2010 9:08 PM
  • Hi,

    is there any update to DPM 2010 using SQL Server 2008 R2 yet? +1

    Thanks, Fred Oguer.


    Frédéric OGUER
    Tuesday, August 17, 2010 8:42 AM
  • Any update DPM 2010 using SQL Server 2008 R2?
    Friday, September 17, 2010 11:23 PM
  • Echoing the last 3 posts - any update for DPM 2010 using SQL Server 2008 R2?  Would be nice to not have to install another instance of SQL on this box.

    Thanks!

    JK

    Thursday, October 14, 2010 10:28 PM
  • Echoing the last 4 posts!! - any update for DPM 2010 using SQL Server 2008 R2?  

    jj

    Friday, November 5, 2010 4:04 PM
  • Is there a patch coming soon? I have the same Problem .....
    • Proposed as answer by CCS Mr. Schedel Thursday, November 25, 2010 7:16 PM
    Thursday, November 25, 2010 7:15 PM
  • and up =)

    where is hotfix?


    -=C U=-
    Wednesday, December 1, 2010 9:58 AM
  • Is situation changes? Is hotfix avaliable?
    Monday, December 27, 2010 3:37 PM
  • Hello,

     

    A half a year has past.

     

    I'm getting annoyed:

    SQL 2008 R2 is out since 2010.05.02

    DPM 2010 is out since 2010.05.17

    but still no support or at least a blog post from DPM team, telling us about the progress.

     

    Any news regarding SQL 2008 R2 support?

     

    We don't want to have an another instance of SQL 2008 because of DPM 2010.

     

    Thanks,

    mrgabriel

    Wednesday, January 26, 2011 9:56 AM
  • Echoing the last several posts. 

     

    What’s the hold-up? 

    Thursday, February 10, 2011 10:20 PM
  • Really, no feedback at all?
    Thursday, March 10, 2011 10:14 AM
  • This is simply ridiculous. I am an IT Manager of a Sixth Form College and am using all MS products except for my backup system which is Symantec Backup Exec 2010. Sql 2008R2 onsite and not going to change, so any news on an update would be really appreciated, especially as the majority of my changes are during holiday periods.

    Guess what Easter soon!

    Wednesday, April 6, 2011 7:23 PM
  • I feel the same.

     

    At least a simple feedback telling use to have patience till the SP1 comes out would be great, but this...

    Thursday, April 14, 2011 6:54 AM
  • Since it looks like I need to rebuild my DPM I was wondering if there is any more info on this.  Due to the limitation of SQL 2008 R2 not being supported I didn't have my DPM DB on my main SQL server, I know my fault but still.  It is almost a year since these two products were released and no update?  Are we doomed to wait until DPM 2012 or something to not support SQL 2012 as well?
    Thursday, April 28, 2011 3:38 PM
  • Echo! Anybody here? We want answers M$! We are NOT installing a SQL 2008 instance for just DPM, but would certainly love to get DPM upgraded.
    Wednesday, May 4, 2011 9:58 PM
  • Does anyone know if this issue has been resolved yet? 

    We would like to evaluate DPM without purchasing another SQL server license, hardware platform and incurring the maintenance overhead that goes along with it.  It seems that Microsoft, up in their Ivory Tower, has lost touch with the cost of implementing their software.

    Can we get a little more QA please?

    Friday, May 13, 2011 4:34 PM
  • I hate Symantec, but it looks like I am stuck with it. I have to buy something now, and am not going to deal with reverting SQL 2008 R2 backwards. Way to go MS......
    Sunday, June 26, 2011 7:46 PM
  • Hi All,

    DPM 2012 BETA is released. In this build we support SQL 2008 R2 as SQL backend for hosting DPM databases.

    Please refer to the information below:

    List of resources:

    ·Website:www.microsoft.com/DPM

    ·DPM 2012 Beta can be downloaded fromhttp://www.microsoft.com/download/en/details.aspx?id=27216

    ·If you have any questions, please visit DPM 2012 Beta Forum at –http://social.technet.microsoft.com/Forums/en-US/dataprotectionmanager2012beta

    ·You can log the bugs through Connect Website Link:https://connect.microsoft.com/site840/feedback

    ·More information about features and informative “how to” videos onBlog: blogs.technet.com/DPM


    Thanks, Bortik - [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights
    • Proposed as answer by Bortik [MSFT] Friday, September 16, 2011 3:12 PM
    Friday, September 16, 2011 3:11 PM
  • I have just installad DPM 2010 successfully using SQL 2008 R2 SP1 on a remote named instance!

     

    yes SQL 2008 R2 (maybe SP1 did the trick)

    Wednesday, October 26, 2011 6:57 AM
  • I am running SCDPM 2012 RC and SQL 2008 R2 and still get this error.

     

    The Log shows:

     Exception :  => System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.ReportingException: exception ---> System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. ---> Microsoft.ReportingServices.Library.ReportServerDisabledException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

     

     


    David Baur
    Sunday, November 6, 2011 8:24 PM
  • I did the same, but my schedules do not run authomatically (have to run manually)

    Are you ones fine? Thank you

    Friday, December 16, 2011 4:26 PM