none
DPM 2012 SP1 and SQL Server 2012 SP1

    Question

  • HI,

    We are trying to install DPM 2012 SP1 (New Install) on to a remote SQL 2012 SP1 server. All OS's are also Server 2012.

    We have installed Reporting services locally on to the DPM server and ran through the configuration to point it to the SQL 2012 server/Instancex. This has creates new databases for reporting services.

    Next we try and run the DPM installation and point it to same sql 2012 server/Instancex. During the install, we see the following error: Information : Got Error Message: Service ReportServer$INSTANCEX is not installed. The SQL Server 2008 Reporting Services installation is not valid.Uninstall SQL Server 2008 Reporting Services and then run the program again.

    Bit confused. Any ideas what it is trying to say here? Can Reporting services be installed on the same server but point to remote DB server? Why is it complaining about SQL server 2008 reporting services not being installed when SQL server 2012 reporting services are installed?

    Many Thanks.

    Wednesday, August 28, 2013 5:46 PM

Answers

  • Hi,

    DPM 2012 does not support split SQL engine and SQL reporting services servers - DPM is looking for reporting services on the same instance.   DPM 2012 R2 (still in beta) will support separate servers for SQL engine and SQL reporting instances.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, August 28, 2013 9:07 PM
    Moderator

All replies

  • Hi,

    DPM 2012 does not support split SQL engine and SQL reporting services servers - DPM is looking for reporting services on the same instance.   DPM 2012 R2 (still in beta) will support separate servers for SQL engine and SQL reporting instances.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, August 28, 2013 9:07 PM
    Moderator
  • It seems as though the SQL DB for DPM must be clustered in order for this to work.

    Can you please confirm this?

    Thanks.

    Tuesday, October 22, 2013 2:55 PM
  • It seems that you need the cluster for it to work. Now, the good news seems to be that you can share the SSRS instance among a primary and secondary DPM Servers. I have tested and was able to run reports from both DPM servers without an issue. I couldn't find documentation to tell whether that is officially supported or not.

    Any ideas?


    MCITP, MCSE, MCTS

    Tuesday, November 19, 2013 6:55 PM