Tuesday, February 21, 2012

The file 'microsoft.reportviewer.winforms version 9.0.0.0 culture neutral publickeytoken..cannot be opened.



The file 'microsoft.reportviewer.winforms version 9.0.0.0 culture neutral publickeytoken..cannot be opened. Do you want to remove the reference to it from the Recent list?


Recently I did a SQL Server install and everything went fine. But then I tried to run a disk usage report on one the databases and got the above mentioned error

According to a ticket with Microsoft and this is a known issue.
http://connect.microsoft.com/SQLServer/feedback/details/523972/sql-2008-r2-nov-ctp-management-studio-reports-fail-on-opening

You can verify this by checking if you have the following folder.
"C:\Program Files (x86)\Microsoft Visual Studio 9.0\ReportViewer"

There are two workarounds for this issue.
1) Download and install the Reporting Services Report Viewer 9.0. You can download this package from the Microsoft Download Center or by using the following link:
 http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6ae0aa19-3e6c-474c-9d57-05b2347456b1

2) Additionally you can install "Business Intelligence Development Studio" using the same installation media that you used to install SQL Server. You can also download this from Microsoft's website. I guess you didn't install this while installing SQL Server.

1 comment: