error with SQL 2019

tom geo 41 Reputation points
2021-03-09T10:13:22.95+00:00

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

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-03-10T06:18:50.15+00:00

    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:

    76116-01.jpg

    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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. tom geo 41 Reputation points
    2021-03-10T08:37:12.9+00:00

    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:

    76282-image.png

    0 comments