none
Can DPM share a remote SQL Instance with other System Centre Products? RRS feed

  • Question

  • Firstly, apologies if this has been answered elsewhere but I can't seem to find a definitive line on it.

    I am about to install and start implementing DPM 2012 R2 and have restricted access to SQL instances and the creation of. Can DPM share a SQL instance? Mainly can it share an instance shared with other System Centre products?

    Does it really need a dedicated DB engine and Reporting services instance?


    Tuesday, May 13, 2014 9:58 PM

Answers

  • Hi,

    No, Each DPM server requires it's own dedicated instance name.  You can have a single remote SQL server, but with seperate instances for each DPM server, or other System Center products.

    Make sure that names of your instances does not contains an underscore in the instance name.

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

    Hope this helps.



    Note: This posting is provided 'AS IS' with no warranties or guarantees, and confers no rights. Please take a moment to "Vote as Helpful" and/or "Mark as Answer", where applicable. This helps the community, keeps the forums tidy, and recognises useful contributions.

    Wednesday, May 14, 2014 6:27 AM

All replies

  • Hi,

    No, Each DPM server requires it's own dedicated instance name.  You can have a single remote SQL server, but with seperate instances for each DPM server, or other System Center products.

    Make sure that names of your instances does not contains an underscore in the instance name.

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

    Hope this helps.



    Note: This posting is provided 'AS IS' with no warranties or guarantees, and confers no rights. Please take a moment to "Vote as Helpful" and/or "Mark as Answer", where applicable. This helps the community, keeps the forums tidy, and recognises useful contributions.

    Wednesday, May 14, 2014 6:27 AM
  • Spot on, thanks Matthias
    Wednesday, May 14, 2014 8:52 PM
  • Hi,

    What's new in System Center 2012 - DPM

    Starting with DPM 2012 we added support for multiple DPM servers to share one instance of SQL Server for DPMDB.   You should not use that shared instance for any other purpose.


    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, May 14, 2014 11:47 PM
    Moderator