Create assembly problem on SQL2005
in [Server Configuration]
|
Prev: ddl statement is not allowed
Next: error 904 Database %ld cannot be autostarted during server shutdown or startup.
From: artek on 15 Sep 2006 12:01 Hello, when I try to create an assembly: Create assembly LibSql FROM 'c:\SQLNET\LIBSQL\LIBSQL.dll' WITH PERMISSION_SET = External_Access I got the following error Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131522. You need to restart SQL server to use CLR integration features. select @@version outputs: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Server configuration 8 processors 16 GB RAM AWE is enabled CLR is enabled Restart of SQL doesn't help Server was upgreaded from SQL 2000 SP3a Thanks in advance for any help Artek
From: John Bell on 16 Sep 2006 10:24 Hi I assume you have rebooted the server? John "artek" wrote: > Hello, > when I try to create an assembly: > Create assembly LibSql > FROM 'c:\SQLNET\LIBSQL\LIBSQL.dll' > WITH PERMISSION_SET = External_Access > I got the following error > > Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with > HRESULT 0x80131522. You need to restart SQL server to use CLR integration > features. > > > select @@version outputs: > > Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 > Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows > NT 5.2 (Build 3790: Service Pack 1) > > Server configuration 8 processors 16 GB RAM > AWE is enabled > CLR is enabled > > Restart of SQL doesn't help > > Server was upgreaded from SQL 2000 SP3a > > Thanks in advance for any help > > Artek >
From: artek on 18 Sep 2006 06:51 Yes, I restarted the server, and it didn't help artek "John Bell" wrote: > Hi > > I assume you have rebooted the server? > > John > > "artek" wrote: > > > Hello, > > when I try to create an assembly: > > Create assembly LibSql > > FROM 'c:\SQLNET\LIBSQL\LIBSQL.dll' > > WITH PERMISSION_SET = External_Access > > I got the following error > > > > Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with > > HRESULT 0x80131522. You need to restart SQL server to use CLR integration > > features. > > > > > > select @@version outputs: > > > > Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 > > Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows > > NT 5.2 (Build 3790: Service Pack 1) > > > > Server configuration 8 processors 16 GB RAM > > AWE is enabled > > CLR is enabled > > > > Restart of SQL doesn't help > > > > Server was upgreaded from SQL 2000 SP3a > > > > Thanks in advance for any help > > > > Artek > >
From: Dinesh.T.K. on 18 Sep 2006 06:59 Hello Artek, Can you check what is the database compatibility level? It should be 90 in order to recognize the new features of SQL2005. Please refer "sp_dbcmptlevel" in BooksOnLine Cheers! Dinesh "artek" <artek(a)discussions.microsoft.com> wrote in message news:72004815-797C-4EEB-B609-51856DD27F69(a)microsoft.com... > Yes, I restarted the server, and it didn't help > > artek > > "John Bell" wrote: > >> Hi >> >> I assume you have rebooted the server? >> >> John >> >> "artek" wrote: >> >> > Hello, >> > when I try to create an assembly: >> > Create assembly LibSql >> > FROM 'c:\SQLNET\LIBSQL\LIBSQL.dll' >> > WITH PERMISSION_SET = External_Access >> > I got the following error >> > >> > Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with >> > HRESULT 0x80131522. You need to restart SQL server to use CLR >> > integration >> > features. >> > >> > >> > select @@version outputs: >> > >> > Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 >> > 01:12:25 >> > Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on >> > Windows >> > NT 5.2 (Build 3790: Service Pack 1) >> > >> > Server configuration 8 processors 16 GB RAM >> > AWE is enabled >> > CLR is enabled >> > >> > Restart of SQL doesn't help >> > >> > Server was upgreaded from SQL 2000 SP3a >> > >> > Thanks in advance for any help >> > >> > Artek >> >
From: artek on 19 Sep 2006 05:29
I've checked the database compatybility level and it is setup to 9.0. I wonder if AWE may have something to do with that? Artek "Dinesh.T.K." wrote: > Hello Artek, > > Can you check what is the database compatibility level? It should be 90 in > order to recognize the new features of SQL2005. Please refer > "sp_dbcmptlevel" in BooksOnLine > > Cheers! > Dinesh > > "artek" <artek(a)discussions.microsoft.com> wrote in message > news:72004815-797C-4EEB-B609-51856DD27F69(a)microsoft.com... > > Yes, I restarted the server, and it didn't help > > > > artek > > > > "John Bell" wrote: > > > >> Hi > >> > >> I assume you have rebooted the server? > >> > >> John > >> > >> "artek" wrote: > >> > >> > Hello, > >> > when I try to create an assembly: > >> > Create assembly LibSql > >> > FROM 'c:\SQLNET\LIBSQL\LIBSQL.dll' > >> > WITH PERMISSION_SET = External_Access > >> > I got the following error > >> > > >> > Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with > >> > HRESULT 0x80131522. You need to restart SQL server to use CLR > >> > integration > >> > features. > >> > > >> > > >> > select @@version outputs: > >> > > >> > Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 > >> > 01:12:25 > >> > Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on > >> > Windows > >> > NT 5.2 (Build 3790: Service Pack 1) > >> > > >> > Server configuration 8 processors 16 GB RAM > >> > AWE is enabled > >> > CLR is enabled > >> > > >> > Restart of SQL doesn't help > >> > > >> > Server was upgreaded from SQL 2000 SP3a > >> > > >> > Thanks in advance for any help > >> > > >> > Artek > >> > > > > |