Upgrade DPM 2012 SP1 to DPM 2012 R2

Yesterday I downloaded System Center Data Protection Manager 2012 R2. I extracted the ISO file and started the splash screen.

Upon clicking the link to install DPM another screen similar to the earlier versions appears and you click next. With this install you have the option to install using SQL local or clustered.

If you choose local it defaults to the SQL instance created by DPM 2012 (unless you changed it)

When I clicked Check and Install the checks run through and then DPM 2012 R2 fails with an error that the SQL instance is not valid.

When I checked the logs I noticed it was complaining about the protocol TCP. I went to SQL Configuration Manager and I got the same WMI error saying it couldnt open. I then opened up and elevated prompt and ran the following:

mofcomp.exe “C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”

After that I could open up SQL Configuration Manager, I enabled TCP for the SQL instance and then restarted all the services. I then went back to the DPM 2012 R2 install and clicked the Check Again button and voila, DPM 2012 R2 upgraded my existing DPM installation and completed successfully.

Hope it helps.


3 thoughts on “Upgrade DPM 2012 SP1 to DPM 2012 R2

  1. Lester Clayton November 29, 2013 / 10:39 am

    Thanks very much for the information. While I didn’t get the exact same error messages as you, The solution you provided worked (had to use a different path because of different SQL Version).

    My command line: mofcomp.exe “c:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof”

    My error: The instance provided is not a SQL Server instance. Please provide a SQL Server instance.

  2. Andreas Eid January 6, 2014 / 12:19 am

    Thank you, same error here, your solution works perfect.

  3. dc May 12, 2014 / 12:08 pm

    Saved me an awful lot of troubleshooting time.. thank you.

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