Installing a SQL Server locally on the DPM server

This recipe will cover the installation process of a local SQL Server that is collocated with the DPM server on the same operating system.

Getting ready

SQL Server is a core component for System Center Data Protection Manager. It is of major importance that the installation and design of SQL Server is well planned and implemented. If you have an undersized installation of SQL Server, it will provide you with a negative experience while operating the System Center Data Protection Manager.

Note

Before continuing the installation of SQL, please read the Planning DPM pre-installation tasks recipe in Chapter 1, Pre-installation Tasks.

How to do it…

Make sure that your operating system is fully patched and rebooted before you start the installation of SQL Server 2012 and that the DPM Admins group is a member of the local administrators group. Now take the following steps:

Insert the SQL server media and start the SQL server setup. In the SQL Server...