I just reinstalled a DPM server and restored the database. Everything seems to be working, except when I try to viewer the "Tage Management" report.

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
The EXECUTE permission was denied on the object 'ufn_MM_GetPgLabels', database 'DPMDB_DKODPM01', schema 'dbo'.

If I view the "Recovery Point Status" report it Works fine.

I can't figure out what user/Group is missing permissions on SSRS or the database?

Hi,

I have never heard or seen that before - lucky you.

Did you run DPMSYNC -Sync after you restored the DPMDB ?

Yes I did.

I solved it by adding the local "DPMR$Servername" account to the local security Group "DPMDBAdministrators$Servername".

When looking in http://servername/Reports_DPM , under the DPMReports_randomnumbershere, there is the DPMReportDataSource that shows the account used for DPM reports.

• Marked as answer by mbe-dk Monday, February 18, 2013 12:43 PM

Hi,

in SQL Server Management Console set db_owner rights on DPMDB for DPMDBReaders$...

Cheers Matthias

• Proposed as answer by Matthias Schmitz Thursday, November 07, 2013 1:56 PM

mbe-dk 's solution worked immediately for me.