SSRS 2012 to 2019 - error while previewing

Pedro Soares 396 Reputation points
2021-05-05T11:13:37.723+00:00

Hi,

I'm currently migrating SQL Server 2012 to 2019. On reporting services, after I open a SSRS solution and trying to preview a report, I'm getting the following error:

Details: Could not load file or assembly 'System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.

Any idea on what might be causing this issue and how to solve it?

Thank you

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,816 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
0 comments
Accepted answer
  1. Pedro Soares 396 Reputation points
    2021-05-05T13:43:44.34+00:00

    Fixed it. I needed to install .Net 3.5 which includes 2.0. I had to go to Turn Windows features on or off and specificy the SxS directory of the OS, after install it, the error was gone. Probably a more precise error message would be great :-)

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-05-06T01:32:01.87+00:00

    Hi @PedroSoares-4915 ,
    I'm sorry for the late reply.
    If you have any questions, please feel free to let me know.
    Best Regards,
    Joy

    0 comments
  2. Pedro Soares 396 Reputation points
    2021-05-06T11:26:45.087+00:00

    No problem, it was better this way.

    Cheers