| Author |
Create assembly problem on SQL2005
|
|
|
| Hello,
when I try to create an assembly:
Create assembly LibSql
FROM 'c:\SQLNET\LIBSQL\LI
BSQL.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
| |
| John Bell 2006-10-24, 6:28 pm |
| 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\LI
BSQL.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
>
| |
|
| Yes, I restarted the server, and it didn't help
artek
"John Bell" wrote:
[color=darkred]
> Hi
>
> I assume you have rebooted the server?
>
> John
>
> "artek" wrote:
>
| |
| Dinesh.T.K. 2006-10-24, 6:28 pm |
| 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@discussions.microsoft.com> wrote in message
news:72004815-797C-4EEB-B609- 51856DD27F69@microso
ft.com...[color=darkred]
> Yes, I restarted the server, and it didn't help
>
> artek
>
> "John Bell" wrote:
>
| |
|
| 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@discussions.microsoft.com> wrote in message
> news:72004815-797C-4EEB-B609- 51856DD27F69@microso
ft.com...
>
>
>
| |
| John Bell 2006-10-24, 6:29 pm |
| Hi
I would be doubtful regarding AWE, but you may want to try creating this
assembly on another server.
John
"artek" wrote:
[color=darkred]
> 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:
>
| |
|
| Well,
I finally managed to create this assembly. I think the reason was
compatybility level for master db which was 8.0 after server upgrade form sql
2000.
Once I changed it to 9.0 I was able to create this assembly.
Yet, database for which I was getting the error had compatybility level set
to 9.0, but i looks like master should have had it also.
Thanks for Your help
Artek
"John Bell" wrote:
[color=darkred]
> Hi
>
> I would be doubtful regarding AWE, but you may want to try creating this
> assembly on another server.
>
> John
>
> "artek" wrote:
>
|
|
|
|