SQL Server Home
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: DataDesigners.dll & DataProjects.dll
4/7/2009 8:09:34 PM
User(s) can reproduce this bug
When I installed(many times) management tools in sql server 2008 standard edition always I have error messages in Erorror log and they not appear later:
. NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: C: \ Program Files \ Microsoft SQL Server \ 100 \ Tools \ Binn \ VSShell \ Common7 \ Tools \ VDT \ DataDesigners.dll. Error code = 0x8007000b
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Tools\VDT\DataProjects.dll . Error code = 0x8007000b . NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: C: \ Program Files \ Microsoft SQL Server \ 100 \ Tools \ Binn \ VSShell \ Common7 \ Tools \ VDT \ DataProjects.dll. Error code = 0x8007000b
1.What is description about DataDesigners.dll & DataProjects.dll .I found that they are V data tool but nothing more.
2. If they are not compiled and installed successfully how that will impact SQL server functionality?
SQL Server 2008 - Standard Edition
Tools (SSMS, Agent, Profiler, etc.)
Windows Server 2008
Operating System Language
Steps to Reproduce
1.install management tools in sql server 2008 standard edition
2.wait 15 min Microsoft.net Framework Ngen v2.050727_x86 service to stop
Always these 2 messages appears.
1.I can not ngen display them.
2.when I run: ngen install "C: \ Program Files \ Microsoft SQL Server \ 100 \ Tools \ Binn \ VSShell \ Common7 \ Tools \ VDT \ DataProjects.dll" I have error message
ailed to find dependencies of image C:\Program Files\Microsoft SQL Server\100\T
ools\Binn\VSShell\Common7\Tools\VDT\DataProjects.dll because this image or one o
f its dependencies is not a valid Win32 application.
Compiling assembly C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSSh
Error compiling C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Com
mon7\Tools\VDT\DataProjects.dll: An attempt was made to load a program with an i
ncorrect format. (Exception from HRESULT: 0x8007000B)
3. Nothing helped:Stop/start Microsoft.net Framework Ngen v2.050727_x86 service.
4.re-insatll .net framework 3.5 sp1
5. un-insall/re-install sql server(I'm working with VMWare in one place, but the problems appears in server machine also).
1.how to resolve these error messages
2. or explanation how that will impact sql server. In sql server management studio I still can not see something wrong.
3. What they(DataDesigners.dll & DataProjects.dll) are for?
to post a comment.
Please enter a comment.
on 10/12/2010 at 10:48 PM
Thanks for reproting this issue.
DataDesigners.dll & DataProjects.dll are used for the Table/View/Query designers in SSMS. These are Native DLLs and thus cannot be NGEN'ed. We have fixed these to not NGEN in the SQL setup.
on 9/6/2010 at 6:27 AM
I have the same errors after installing SQL Server 2008 R2 enterprise edition on a windows 2008 Enterprise SP2.
on 6/17/2010 at 10:46 AM
I am getting this error also with SQL 2008 BIDS R1 and R2
Fault bucket 693428785, type 5
Event Name: CLR20r3
Response: Not available
Cab Id: 0
Has anyone else run into this error before and is there a resolution out there? If I load the report to the report server, the report will render correctly. This only happens when trying to preview in VS 2008
on 5/6/2010 at 7:39 AM
I was trying to install System center essentials 2010 rtm and i get this problem in my log files. I had completely removed sql server express, did a normal uninstall and a manual uninstall and still get this problem :( so guessin that is why my sce 2010 saying failed on sql server database services prerequsite installation failed .
on 4/8/2010 at 3:15 AM
This error occurs when running SQL Server 2008 SP1 slipstreamed also
on 12/10/2009 at 11:11 AM
The issue manifested as SQL Management Studio 2008 would launch and then freeze up. Event viewer reports the same two errors. The problem persists after a full unistall and reinstall of all SQL Server related products.
on 12/1/2009 at 6:13 PM
I have the same errors after installing SP1 over SQL Server 2008 Express with Advanced Tools on a w2k3 se sp2 x32.
I've restarted .NET Runtime Optimization Service. Will see if it appears again.
Same problem discussed here:
on 4/24/2009 at 12:51 PM
I just installed SQL Server 2008 SP1 over SQL Server 2008 RTM on a Windows server 2003 box with the same results.
ngen provides no details.
to post a workaround.
Please enter a workaround.
on 7/19/2011 at 11:24 AM
After much frustration I noticed that on my X64 system both the x64 and x86 versions of the service "Microsoft .NET Framework NGEN v2.0_50727" were running. I stopped the service "Microsoft .NET Framework NGEN v2.0_50727_x86" and reapplied SQL sp2 with success!!!!!!!!!
© 2013 Microsoft