SQL Server support for System Center 2016 Data Protection Manager

First published on TECHNET on Oct 17, 2016
What versions of SQL Server does DPM 2016 support? The Microsoft article Installing DPM 2016 discusses the Microsoft SQL Server version that can be used together with Microsoft System Center 2016 Data Protection Manager (DPM).

Some key points:

• You cannot install DPM 2016 on SQL 2016 SP1.


• To use SQL 2016, you must immediately install Update Rollup 2 for System Center 2016 DPM.


• DPM 2016 requires SQL Server Management Studio (SSMS) version 16.5 or earlier. SSMS is no longer installed with SQL Server; you must install it. Download and install SQL Server Management Studio (SSMS) version 16.5 . SSMS version 17.0 or later is not supported with DPM 2016. See the article, SQL Server Management Studio 16.5 release , for information about the SSMS 16.5 release.

For more information about how to prepare your SQL Server environment for System Center 2016 DPM, please see the following article: Preparing your environment for System Center 2016 Data Protection Manager