.NET Runtime Optimization error on SQL Server 2005

I posted this on the .NET Framework inside Sql Server forum as well. Sorry if the cross-post offends anybody.

I upgraded my primary production server this morning to SQL 2005. Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:

Source: .NET Runtime Optimization Service

EventID: 1101

.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

I am a little stumped since we did not install Reporting Services. We only installed Database Services, Integration Services and Workstation Components. I'm open to any suggestions on this. This does not seem to be negatively affecting our server, but I do want to resolve it as soon as possible.

Thanks,

Kevin

I'm getting the same message. Now I'm unable to modify or create tables.|||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|||

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

|||Have you try to stop/start ".Net Runtime Optimization Server v2.0.50727_X86" yet? This service usually set to "manual" and not started.|||I have the same problem and none of the above works. Any other ideas from anyone?|||

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!!!

|||

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.

|||

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

|||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|||

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

|||thanks. but i see that doesn′t work for SQL2k5? We have it :(

regards|||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.|||

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

|||

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?