error with SQL 2019

Question

Hi.

I am trying to download a report from SSRS 2019 in word format and fails with error as below:

An error occurred during rendering of the report. (rrRenderingError)

The type initializer for 'MS.Utility.EventTrace' threw an exception.

Requested registry access is not allowed.

Same case with Excel. Only PDF works.

The cases when I am able to download in word format is when I remove the execution account that is used for the reports.

Other case is when I use the same execution account in the service account. This also works.

But this seems like a workaround and in our organization we have service account as a Group Managed Service account that needs to be used for reporting service. The execution account is different and its an application account that we are using. This execution account has admin access on the server and appropriate SQL Server access as well.

I am thinking if there is some other permissions that needed for the execution account? Or anything else that you guys know of ? Let me know please

thanks

Answer 1

Hi @tom geo ,
Check in the URL (once you click on excel) whether the format is EXCELOPENXML/WORDOPENXML. If yes change it to EXCEL/WORD.

Or you could open rsreportserver.config file and enable EXCELOPENXML format, WORDOPENXML. format, Excel, Word format. Look for the Render section, enable or disable the export formats that you want your users to have access to, as shown in the figure below:

2017 and newer version rsreportserver.config path: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServe

Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Joyzhao-MSFT

Thank you so much for the answer, I was able to do the same method as you described and was able to get the download to WORD format. But the format is WORD 97-2003, .doc not .DOCX.

And do you know the reason why this is happening ? This never happened on SQL Server 2014 version. Is there something missing with SQL Server 2019 version?

This is how I changed in my report config file: