Server 2012 R2 Datacenter (virtual).
Installed SQL server 2012 SP1 locally, with all default settings.
Changed accounts according to DPM requirements for agent, server and reporting services

DPM setup complains as below, reporting service is running and, I believe, it is configured correctly, any clue ?
(error log is available, but does not give me valuable information).

EDIT:

Just realized that reporting services relies on web server so I installed IIS and fiddled a little with reporting services encryption key which brought me to the next error as follows:

Pasted from error log (just prior to error):
Information : Querying WMI Namespace: \\dpm01\root\cimv2 for query: SELECT * FROM Win32_Service WHERE Name='SQLSERVERAGENT'
Information : Sql Agent account name = ad\DPM01$
..
Information : Add user: ad\DPM01$ to local group: Distributed COM Users on server: DPM01

I don't know the ad\DPM01$ user, however it looks like it is the builtin Local System
I also tried to add this builtin to the group manually, but DPM still reports error.

Is DPM really designed to be so complicated and giving so much headache ?

Anyone able to help me out ?

• Edited by EuroEager Sunday, October 20, 2013 4:52 PM

Hi,

i had the exact same reporting services error, i fixed it by running reporting services config manager and clicking apply in the web service url tab, created a new database in the database tab and then apply in the report manager url tab.

• Proposed as answer by istvanh Monday, October 21, 2013 6:04 PM
• Marked as answer by EuroEager Tuesday, October 22, 2013 7:04 PM

Thanks, what about the funny account which the wmi query returned at my installation ?
If I do the same query from Powershell it returns the accountname as LocalSystem (after I changed it to this of course), anyway the installer insists on ad\DPM01$ and tries to add that one to the Distributed COM Users group which, of course, does not work.

My DPM machine name is DPM01 and my domain is like ad.<mydomain>.<tld> and the NetBIOS name is the same as domain name (mydomain).
I feel that the accountname ad\DPM01$ mixed up of my subdomain and machine name.

Is this a bug in the installer ?

Someone can point to a really simple installation procedure for DPM (and only DPM, not the rest of the System Center) on a domain member server 20012 R2 ?
From what I have read it should not be necessary to install SQL server (DPM install will install this by itself ?) or IIS (DPM installs this one as well ?)
I have been struggling with this for days now.

• Edited by EuroEager Monday, October 21, 2013 7:09 PM

Finally tried to use a domain user account instead of LOCALSYSTEM for SqlServer and agent, setup runs perfect this time.

Checked the installation log and the line following the same query regarding SqlServerAgent now shows as expected: Information : Sql Agent account name = <mydomain>\<mydomainuser>

I have no clue why this seemed to detect the non-correct and non-existing ad\DPM01$ on earlier installation (see earlier in this thread).

However, I have now given the SqlServer and agent perhaps far to much privileges, how can I reduce this without jeopardizing the DPM again ?

Microsoft: Using LocalSystem (as recommended by the setup as one alternative) seems to expose a strange bug, please respond !

• Marked as answer by EuroEager Tuesday, October 22, 2013 7:04 PM

I had the same issues with ID 812 and managed to resolve it by setting the default ports on both web service URL and reporting services URL.

Thanks man , helped 100%

Thank you! Prob solved!

• Edited by Michael K1 3 hours 34 minutes ago

Thank you! Prob solved!

• Edited by Michael K1 Friday, January 09, 2015 9:07 AM