Failed to initialize the Common Language Runtime

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Failed to initialize the Common Language Runtime

Author

Topic

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-11-17 : 15:38:29

[code]
CREATE ASSEMBLY UserDefinedFunctions
FROM N'D:\myproject\bin\UserDefinedFunctions.dll'
WITH PERMISSION_SET = safe;
[/code]

Msg 6511, Level 16, State 82, Line 1
Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x8007000e. You may fix the problem and try again later.

Anyone ever seen this? That HRESULT seems to point to a memory issue, but I freed up a bunch of RAM and still get the same error.

I haven't yet bounced either SQL or the Server as that needs to be scheduled.

Should I read this:
a) We will allow you to fix the problem and try again later.
-or-
b) You might be able to fix the problem and, if you do, try again later.

Jay White

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-11-17 : 16:42:34

Are the compatibilty level of your database and of the master database both set to 90?

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-11-17 : 17:36:35

Yeah ... both the same ... the database was created on this server with this master.

Jay White

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-11-18 : 02:13:07

I assume you have the clr enabled on the server? what does sp_configure say?

SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-11-18 : 02:15:24

Actually, this hresult signifies an OOM. Is this server under heavy load?

see: http://msdn2.microsoft.com/en-us/library/ms679717.aspx

EDIT: oops, just noticed that you already mentioned it's an OOM. need to read more carefully!

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-11-20 : 08:32:27

Bouncing the SQL Server service resolved this ... odd.

Jay White

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources