SSRS 2016: Export to Excel issue

Moisés Mora 0 Reputation points
2023-08-10T16:57:25.5033333+00:00

When I try to export to Excel an SSRS Report, I have the following error:

User's image

Attached is the version of SSRS installed:

User's image

I am using the Virtual Service Account as a Service Account. I read in other forums that when a Virtual Service Account and an Execution Account are used, SSRS has problems exporting to Excel. I have the same configuration in other virtual machines, but I do not have this issue.

I also have the issue exporting to Word. If someone have any idea about this issue, that would be helpfull to me.

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.
{count} votes

2 answers

Sort by: Most helpful
  1. Junior Galvão MVP 76 Reputation points
    2023-08-10T21:55:49.9366667+00:00

    Moíses,

    You commented on the user account being used in SSRS.

    Does this user account have permission to create the create files?


  2. Anonymous
    2023-08-11T01:30:08.3166667+00:00

    Hi @Moisés Mora

    I found a similar thread where someone with the same problem mentions that using Process Monitor (procmon) shows ReportingServicesService.exe getting ACCESS DENED errors for the following keys. This key is only accessible when SSRS is running and disappears when it is not. Changes made to its permissions will be preserved.

    Computer\xxxx\xxx\Software\Microsoft\Avalon.Graphics

    You may grant the execution account (not the account that runs the service) Read access to this key to see if the issue can be resolved.

    https://stackoverflow.com/questions/45864808/ssrs-reports-exporting-to-excel-gives-rrrenderingerror-error-the-type-initial

    Best regards,

    Aniya


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.