Thursday, March 7, 2013

How to install DPM2012 SP1 on W2K12 with Local SQL 2012 SP1 instance

In the previous post here, I show you how to install DPM 2012 on W2K8R2 OS with local SQL 2012 SP1 instance. On this post I will do the same on W2012 OS. The good news is that this is exactly the same procedure :)

Before you begin installation, make sure that features .NET Framework 4.0 and .NET Framework 3.5 are installed.

Step 1: Install SQL2012 SP1 with Reporting Service on your DPM server
Launch your SQL 2012 SP1 DVD or ISO.

# Feature Selection, you need to select:
  • Database Engine Services
  • Reporting Services - Native
  • Management tools - Basic / Complete (Optional)

# Instance Configuration :
  • Named Instance: YourSQLNamedInstance (e.g LOCALDPM)

# Server Configuration: It's a sandbox, so for SQL accounts, I will use the same domain account for each role.

# Database Engine Configuration :
  • Choose your Authentication mode : Windows authentication mode
(You may choose Mixed mode if you want, you will have to provide a password for SA account) 
Don't forget to add your account or your group to be SQL server administrators.

# Reporting Services Configuration :
  • Choose Install and configure

Then Next, Next, Next, Install... :)

Step 2: Now it's time to Install DPM 2012 SP1
Launch your DPM 2012 SP1 DVD or ISO.

# Prerequisites check: Select Use an existing Instance of SQL Server 
Type the name of your SQL instance: YourDPMServerName\YourSQLInstance
Then click on Check Again

If you passed prerequisite check, the "Next" button is no more Grey-out, Click on Next

# Installation Settings: Click on Next (again)

 # Summary of Settings: Review Summary of Settings and click Install

# Installation: Completed successfully.

At last, you may take a look in the SQL Server Management Studio. Yes your DPM DB is here. Good Job :)