CLR Initialization permanently failed.

• Anders Hansen

  Ten Centuries

  Points: 1211

  More actions

  December 18, 2008 at 4:45 am

  #204206

  Hi

  Will try and post this here as well as MSDN forum. (http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/6e697961-4148-46a3-a369-bf6d85db0aa6). Need to see if i should turn to use SSC more than MSDN for SQL server questions.. 😉

  I have a problem with my local SQLExpress installation that came along with Visual Studio.

  When i try to load my VS DB Project in VS2008 Team System 2008 Database Edition, it fails because CLR Initialization fails in the local sql server.

  I have read http://social.msdn.microsoft.com/forums/en-US/sqlnetfx/thread/a77dbc59-790c-47f2-84a3-154638c95806/, and suspect it to be a problem with having .Net 2.0 SP2 installed?

  Can anyone confirm if this can be a problem, and if so how do i fix it? I can not uninstall 2.0 SP2, since i have some other apps that don't work with SP1. 🙂

  Do i need to update something in the local sql express installation?

  I hope somebody can help me further here.

  Best regards

  /Anders

  My setup:

  Visual Studio 2008 (Team System Database and Developer Edition) (9.0.30729)

  SQL Server Express (9.0.4035)

  .Net Framework SP2 (2.0.50727.3053)

  The error i receive is :

  Msg 6512, Level 16, State 27, Line 1Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80004005. You need to restart SQL server to use CLR integration features.

  And the select statement

  select * from sys.dm_clr_properties

  gives

  CLR initialization permanently failed

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  December 18, 2008 at 7:41 am

  #914540

  I responded to your post on the MSDN Forums already.

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]