Preparing the Remote SQL Instance

If you plan to use a remote SQL instance for your DPM installation (that is, SQL Server that is running on a system other than the local DPM server you are installing), you need to ensure that the following features are installed on the target SQL server:

• Database Engine services (both subsections)

• Reporting Services

• Management Tools—Basic

• Management Tools—Complete

• SQL Client connectivity SDK

Once the remote SQL instance has been installed, ensure the following:

• Reporting Services is configured and linked to the remote SQL instance.

• The SQL Agent service is running and set to Automatic startup.

• A Windows Firewall exception is created for SQLServer.exe.

• The Named Pipes protocol is enabled.

Get Microsoft® System Center 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.