DPM 2025 install fails with ID 812 — SSRS refuses to execute ReportSRV10.dll (Server 2025 + SQL/SSRS 2022)

Our IT Department was setting up a new server and installing DPM, but this was failing. The symptom was DPM setup passes Inspect and SQL detection, then fails during report deployment with ID: 812. The DPMSetup.log shows a SOAP CreateReport failure, and SSRS LogFiles show:

Error while loading code module: ‘ReportSRV10, Version=1.0.523.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’. Details: Could not load file or assembly ‘ReportSRV10 …’ or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418)

Our team figured out how to get it get around the error and they posted this to Microsoft.

DPM 2025 install fails with ID 812 — SSRS refuses to execute ReportSRV10.dll (Server 2025 + SQL/SSRS 2022) – Microsoft Q&A

Microsofts AI agreed with the fix and suggests these steps:

The installation issue you are facing with DPM 2025, specifically Error ID 812, occurs when SQL Server Reporting Services (SSRS) refuses to execute the ReportSRV10.dll due to restrictions imposed by the Code Access Security (CAS) policy. This error typically arises during the report deployment phase of the installation process.

To address this issue, you can follow these steps:

  1. Confirm the Presence of ReportSRV10.dll: Check that the ReportSRV10.dll file is located at C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin\ReportSRV10.dll.
  2. Update rssrvpolicy.config: Modify the rssrvpolicy.config file to include a FullTrust CodeGroup that targets the ReportSRV10.dll, allowing it the necessary permissions to execute.
  3. Adjust NTFS Permissions: Ensure that both NT AUTHORITY\NETWORK SERVICE and DOMAIN\DPMADMIN have Read & Execute permissions on the ReportSRV10.dll file.
  4. Restart SSRS: After applying the above changes, restart the SSRS service to ensure the new policy settings take effect.
  5. Install ReportSRV10.dll into the GAC: Use the System.EnterpriseServices.Internal.Publish.GacInstall() method to install the ReportSRV10.dll into the Global Assembly Cache (GAC).
  6. Re-run the DPM Installation: Finally, restart SSRS once more and attempt to run the DPM setup again.

By following these steps, you should be able to resolve the installation failure. It may also be beneficial for Microsoft to enhance the DPM installer to automatically handle SSRS trust configurations for ReportSRV10.dll and to include checks for SSRS custom assembly trust prior to installation.

Let us know if this helped you…

Comments

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Translate »