Error in SQL Reports Server Saving as Word or Excel

Error in SQL Reports Server Saving as Word or Excel

If you have recently upgraded the server your SQL Reports is installed on to Microsoft Windows 2019, then you might be getting this error when trying

Moving files up a folder level
Security Incident Response and Data Acquisition
IIS with ASP.NET support check

If you have recently upgraded the server your SQL Reports is installed on to Microsoft Windows 2019, then you might be getting this error when trying to save a report as either Word or Excel.

Requested registry access is not allowed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Requested registry access is not allowed.

Cause:
This is caused by a bug that pops up on systems with SQL Reports server installed and an in-place upgrade to Server 2019 has been performed.

Resolution:
Edit the rsreportserver.config file and change these lines:

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="true"/>
<Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>

Notice you want “Excel” to be visible and “ExcelOpenXML” to be false. You can do the same for the lines about Word.

What’s the difference? With EXCELOPENXML the file is saved with the extension .xlsx, with EXCEL it is .xls, and .doc versus .docx It’s not a perfect solution but until the bug is fixed by Microsoft it is the best solution.

 

COMMENTS

WORDPRESS: 0