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 Server100Sharedsqlmgmproviderxpsp2up.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.