Pages

mandag 26. august 2013

DPM 2012 SP1: Install with local SQL 2012

Before installation, join the server to your domain and add Windows Feature .NET Framework 3.5.1. Also install all Windows Updates.

Step 1: Install SQL Server

Features to select:
  • Database Engine Services
  • Reporting Services - Native
  • Management Tools (Optional)

Instance Configuration:
Choose Named instance: LOCALDPM

Server Configuration:
Specify domain accounts for SQL Server Agent, Database Engine and Reporting Services and set them all to Automatic Startup.

Database Engine Configuration:
Remember to add installation account and/or SQL Admins group to SQL Server administrators.

Reporting Services Configuration:
Select Install and Configure.

After installation, restart if needed, then upgrade to SQL Server 2012 SP1 (if you did not use a slipstreamed media). Also run Windows Update.

Verify connection to the Instance by using SQL Server Management Studio.

Step 2: Install DPM

Prerequisites check:
Select Use an existing instance of SQL Server and type in the machine and instance name, example: DPMSERVER\LOCALDPM, then click Check and Install. If you have to restart, do so, but try Check Again first to see if you can continue without a restart.

If you get an error message stating that it is unable to create a registry key for MaxAllowedParallelBackups, I suggest to open up Registry Editor, find the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Data Protection Manager, export the key to a file, delete the key, and then import it again. After this click Try Again in the DPM installer.

After installation, verify that the DPM database exist by using SQL Server Management Studio. Also remember to run Windows Update.

Update 28. august 2013:

Step 3: Clean UP

After installing DPM you will find that some features of SQL Server 2008 R2 was installed, as pointed out by Julien De Freitas in the comment below. What was installed was some SQL Server 2008 R2 Shared features, and not SQL Server 2008 R2 Instance features.

When we install SQL server we choose various Instance features, like the Database Engine Services and the Reporting Services. In SQL Server Management Studio, when connected to the DPM instance, we can se a version number after the instance name in Object Explorer. With SQL server 2012 SP1 the version number is 11.00.3000 (or higher if you also installed updates). A complete list of version number can be found here.

You will see that the version of the instance that DPM use is indeed SQL Server 2012 SP1. This is the instance version and we can have multiple instances on the same server with different versions. If we open SQL Server Configuration Manager and look at SQL Server Services, we will find a list of SQL Services on this server. Each instance may have more than one service (like Reporting Services and Agent) but they all have the instance name at the end. You will probably find that the only instance is the one used by DPM. So this concludes that DPM did not install a SQL Server 2008 R2 instance, it used the existing instance that we created before installing DPM.

In adition to instance features, we can choose to install shared features, like Management Tools. What the DPM installer does, and this is outlined by Microsoft under SQL server requirements for DPM, is that it installs additional programs, which are not required for DPM:

Microsoft SQL Server Compact 3.5 SP1
Microsoft SQL Server Compact 3.5 SP1 Query Tools
Microsoft SQL Server 2008 R2 Native Client
Microsoft Visual Studio Tools for Applications 2.0
Microsoft Office 2003 Web Components

This is not instance features, but shared features, and sadly it is in the older version of SQL server. Even if the features do exist already in a newer version, it will install these older version.

Why Microsoft do this is not easy to tell, maybe they should clean up the installer or make it smarter, but the good news is that they are not requierd for DPM, so you can uninstall them.

I did so, and I uninstalled in this order:

Microsoft SQL Server Compact 3.5 SP2 ENU
Microsoft SQL Server Compact 3.5 SP2 Query Tools
Microsoft SQL Server 2008 R2 (64-bit) (Select All shared features)
Microsoft SQL Server 2008 R2 Native Client
Microsoft SQL Server 2008 R2 Management Objects
Microsoft Visual Studio Tools for Applications 2.0 - ENU

And DPM is still happy, even without those components :)