Tuesday, June 10, 2008

Reporting services 2005 - Could not load file or Assembly 'Microsoft.ReportingServices.Designer

"Could not load file or Assembly 'Microsoft.ReportingServices.Designer, version=9.0.242.0, CUlture=neutral, publickeyToken='' or one of its dependencies. The system cannot fidn the file specified" . If you have encountered this error while creating Report server project in visual studio 2005, here is the solution.

  1. Make sure the business intelligence addin (as part of SQL server 2005 express edition(SQLEXPR_TOOLKIT.EXE) is installed in the same directory as you have installed the visual studio 2005.
  2. By default the addin is installed in C:\
  3. Copy the contents of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory as visual studio 2005 installtion folder ( for ex. D:\Program Files\Microsoft Visual Studio 8\Common7\IDE if the visual studio installation is in D: drive)
  4. After copying the content to specific folders, we have to re register the reports package.
  5. For registering the package, Click on start button and then click Run.In the Open text box, type the following, and then press ENTER:
    "\Common7\IDE\devenv.exe" /setup /resetskippkgs ( is visual studio installationg path for ex. D:\Program Files\Microsoft Visual Studio 8\)
  6. Click OK.
  7. Click Start, and then click Run.
    In the Open text box, type the following, and then press ENTER:
    "Folder Path\Common7\IDE\devenv.exe" /resetskippkgs
    Click OK. If there are no errors, Visual Studio .NET or Visual Studio 2005 starts with no warnings and the problem is resolved

No comments: