.NET Runtime Optimization error on SQL Server 2005

.NET Runtime Optimization error on SQL Server 2005

• Denis Pitcher

  I have the same problem and none of the above works. Any other ideas from anyone
  
  
  
  
  

• Ecrofirt

  We just applied SP1 for SQL Server 2005 on our production server after a successful installation on our test servers and started to get the same error:

  .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile

  We haven't attempted any type of fix yet, waiting to see if anyone else has fixed it yet.

  
  

• smargroth

  The problem was fixed when I reinstalled Sql Server. Apparently some error during installation, couldnt figure it out.

  I think the sequence of installation matters. When I install an XP machine, I stick to the following installation sequence:

  Xp->SP2->IIS->MSOffice->OfficeSP->MS Sql Server 2000->Visual Studio->MSDN->VSS->Enterprise Library

  Probably This sequence doesnt work for Sql Server 2005

  
  

• Pratyush

  I have the same problem, after Installing SQL 2005 SP1 on Clustermachines.

  However my SQL-Cluster has a problem moving groups, which I hold responsible for failing to install the SP1 on the Database Engines.

  I have 32 Bit Machines.

  I find interesting though that my BTS 2006 Machines that use the SQL Servers have the same Problem too, even they don't have any SQL Server on it themselves.

  Is it feasable to believe that the Problem is maybe in some other Patch we installed that affects the SQL Client Components

  I have also installed the Hotfix NDP20-KB918642-X86_bugfix.exe which is supposed to fix the annoying Shim Database Error Message (you know it ).

  Any new suggestions, workarounds, patches

  
  

• lance p

  Looks like I am getting this error message after installing service pack 1 on SQL 2005. So uninstall and re-install is the answer I tried to repair the .NET 2.0 framework, but still get the error. Not sure if this is a show stopper, but this is a new server with fresh install of everything. I would hate to have an error like this cause problems in the future.
  

• pd_tch

  Hello,

  I am running my Asp.Net website on IIS5.1 and Sql Server 2005 for about 6 months now, and it works fine on 3 machines.

  I recently installed another machine with identical configuration and created the project from VSS. I get the above error whenever I try to debug. As soon as I start debugging, the .NET Runtime Optimization Service enters stopped state with above error. The following is the exact error in Application Event Viewer:

  .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

  Any help would be greatly appreciated!!!

  
  

• ChrisCo

  Hi
  how do you have reinstalled the SQL Server
  Do you have deinstalled/installed the server or how
  We have 3 Instances with diffrent DB’s and i don’t want to crash them.
  
  Thanks for help
  
  

• Eric Liprandi

  Hi,
  
  try to restart the .NET RuntimeOptimization service. If this does not help you can also work without the service temporary. If you have a maintainance windows and can make a reboot of your server, that would be my next step.
  
  HTH, Jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• Minherz

  I'm getting the same message. Now I'm unable to modify or create tables.
  

• nemo kao

  Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet This service usually set to "manual" and not started.
  

• GlennZarb

  Hi,

  Just come across this after seeing the same error in my event log during standard system reviews. I don't have any noticeable effects, but when reviewing the full sequence of .Net optimisations there are two distinct groupings of compilations, one where the version is clr_optimization_v2.0.50727_32 and one where the version is clr_optimization_v2.0.50727_64 . As I'm running an x64 box might it be that this error is not a problem as it seems to be occuring on the 32bit version of the optimisation and not on the 64bit version

  Would be interesting to know what systems people are running that this error is occuring on, 32bit or 64 bit.

  HTH someone else.

  Regards

  Nick

  DBA - United Co-op Ltd

  MCDBA

  
  
  

• cometta

  Best bet is to identify the instance has to be un-installed. In add-remove programs the instances are shown separately. What I did was to stop the sql server in question and save all the LDF and MDF files in a separate folder.

  After uninstalling I made sure that corresponding directories and registry entries were completely removed. Then I verified that I am in the correct order, and initiated the installation. I have mentioned the order of installation in my previous message. No need to uninstall .Net framework 2.0 incase already installed. Also, verify that the latest OS service pack is in place before initiate the install.

  Once complete, I copied the LDF and MDF files back into the data folder and re-attached the databases. That worked for me.

  Hope I have answered your question

  
  

• Erick-Flores

  Hi

  I have just installed Reporting Services 2005, SP1, and Rollup fix 2153. Also I have rebooted the machine and I am still getting the event log message which was posted at the beginning of this thread. Do we have a status or resolution for this.

  Thanks

  Steve

  
  
  

• AbhilashN

  thanks. but i see that doesn’t work for SQL2k5 We have it :(
  
  regards
  
  
• .NET Runtime Optimization error on SQL Server 2005