Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

.Net Runtime Optimization Service failed to compile

Posted on 2008-10-02
1
Medium Priority
?
6,024 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
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 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