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.