Sunday, February 10, 2013

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

When you want to use DPM 2012 local SQL instance, you most likely let DPM to install SQL Server 2008 R2 from the System Center 2012 DVD and host the DPM database on this instance.

Nethertheless you can use an existing local instance of SQL 2012 Server on the computer that you are installing DPM. In this post I will show you how to install DPM 2012 SP1 (On W2K8R2 OS) using local SQL 2012 SP1 instance.

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.

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: Your installation will failed :) Because you need to install SQL 2K8R2 SP2...

Not really, because if you try to install SQL2K8R2 SP2, wizard will tell you that your SQL components are already upgraded.

So just launch again DPM 2012 SP1 installation and this time you won't get any error message. Installation has completed successfully :)

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