Damilola's Blog on Ease of Administration

Talking about Installing DPM 2010 (Remote SQL 2008)-Step-by-Step
June 2, 2010, 3:53 pm
Filed under: DPM, SQL | Tags: ,


Installing DPM 2010 (Remote SQL 2008)-Step-by-Step

Finally I get the chance to fiddle around one of my favorites..I Got it stored up
Systems Centre Data Protection Manager 2010 a welcome relief to manage your Infrastructures’ backup and disaster recovery. You can get the RTM here  http://technet.microsoft.com/en-us/evalcenter/bb727240.aspx
Below is a step by step guide on How to Install the Product Using a remote/existing Instance of SQL 2008 w/SP1
Before I begin, I would like to mention some important notes
1. The Account you plan to use on the remote SQL should be a member of the Local Administrator on Both Servers (DPM and Remote SQL), this is just for the installation purpose especially on the remote instance so it can be removed from the remote sql after installation.
2. The Installation Account must be a member of the sysadmin role on the SQL instance you plan to use.
3. The SQL Instance (Either default or named) must have an un-allocated SRSS attched to it (by un-allocated that infers not in use by another application such as share-point) and the reporting services mode should be in native mode not share point integrated mode.
PS: when using a named instance, ensure the following protocols are enabled (for the instance) Named Pipes, TCP/IP and Shared Memory .
PS: Well in my case to avoid issues and for proper troubleshooting i just installed a new named instance and dedicated it to DPM (that’s the best i could do for my favorite!)
4. Finally do ensure your SQL 2008 is patched at least SP1….with regards to using R2 i am yet to test on that and maybe i’ll update when i get more info or do an actual test.
5. For system requirements for DPM server you could have a quick scheme through technet’s guide http://technet.microsoft.com/en-us/library/ff399554.aspx
6. If you plan to to use the DPM console on your desktop then follow this step before you install DPM http://www.scdpmonline.org/dpm-console-on-your-desktop.aspx
So lets get down to the Business of the day!
Pre-Installation Steps
On Remote SQL Server
1. Insert your dvd/ point to the installation folder (from a share or local system), locate the SQLPreinstaller folder
2. Double click on the SQLPreinstaller package with the correct version of your SQL (x64/x86)
3.Wait for the installation to complete and click close.
On DPM Server
1. Insert your dvd/ point to the installation folder (from a share or local system), locate the setup.msi and double click on it
2. on the Splash screen select install Data Protection Manager
3. Accept the agreement and click next
4.Click next on the welcome page
5.On the prequisites check page, ensure evrything is green before moving on else the installation will not continue
*Not much worry as DPM contains the package or link to the prequisite needed just incase any one is missing!
6.On the product registration page enter your details and move on
7.On Installation settings page ensure to select an existing instance of SQL in the SQL server settings path, also you may choose to cahnge the default installation path or accept the default and move on.
8.On the SQL settings page, specify the name and instance of the remote SQL and also a valid account (with priviledges listed above) and move on to the next page
9.On security settings page, enter the password for the restricted local user accounts that DPM will create and move on
10. Select you Microsoft update opt-in and CEIP settings on the next two pages and move on
11.Examine the Installation Summary and click install
12. Wait and ensure no errors are encounterd and yeah u are half way to the finish line.
Update (march 3rd/2011) : I just tried the dpm 2010 with a remote SQL 2008R2 and ..no luck, there is no direct support as at today :(. However if you install dpm 2010 and then upgrade your sql to R2 from 2008 Sp1 it works very well. 🙂
Hope you find this helpful!

2 Comments so far
Leave a comment

Nice to see you have been busy

Comment by kingsley

lovely blog, really impressive.
that’s your track to being an MVP

Comment by jumoke

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: