?
Solved

.Net Runtime Optimization Service failed to compile

Posted on 2008-10-02
1
Medium Priority
?
5,869 Views
Last Modified: 2013-11-07
I am getting this error on a new Sql 2005 server I am building.  I am not a SQL person, but I'm installing it none the less.  I had installed 2 database instances and SP2 on both, rebooted and no errors (execpt for Schannel, but I have another thread for that).  Only after I installed the Workstation Compnents and reapplied SP2 to them did the following did the errors appear.  This is my log of the install:

Install SQL Workstation components
                     Run sql setup
      Select Workstation components, books online and development tools.
      Default install path c:\program files\microsoft sql server
      Rerun SP2 to upgrade client components
      Reboot
      Check Logs
      Getting error after installing Workstation components and Rerunning SP2
      
                     Event Type:      Error
.      Event Source:      .NET Runtime Optimization Service
      Event Category:      None
      Event ID:      1101
                     Date:            10/1/2008
      Time:            12:10:56 PM
      User:            N/A
      Computer:      SAMEDAY2
      Description:
      .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile:              Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
      
.      
.      For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Then I tried to reinstall .net 2.0:
      In add/remove programs
      Tried to remove .net 2, said could not due to would affect other programs
      Clicked Change instead. Several event viewer info entries
      Also did Change on Visual studio.
      Reboot
      Still errors, but seems not as often.

Here's a post I found:

Suggestion from http://blog.mechanised.com/2008/09/event-log-error-fix-for-rs-errors-after.html
To Fix, drag
C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Design.dll
to
C:\WINDOWS\assembly

To install the offending library to the GAC.
Double check all is fine:

C:\WINDOWS\microsoft.net\Framework\v2.0.50727\ngen executeQueueditems

Cannot drag to folder is read only
Executed executeQueueditems without copy dll to see what it did.  A ton of entries scrolled by for several minutes.  Lot of file not founds.

Reboot 2:42 to make sure nothing else messed up

No more errors, but .net Runtime Optimization service is now set to Manual and not started, previously it was started.  Started it manually, but it stops after a few seconds.

I did not finish trying the above suggestion since the instructions on installing to the GAC are missing and I don't know what that is.

I have not installed any ot the post SP2 cumulative updates as I don't want to mess anything else up and I'm not sure which one to apply.
0
Comment
Question by:Brian_MB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
Brian_MB earned 0 total points
ID: 22746447
Gave up on a solution for this.  Tried installing reporting services etc and several other "fixes" found on the net.  Nothing worked.  Came across this post:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125659
 
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question