Prev: ddl statement is not allowed
Next: error 904 Database %ld cannot be autostarted during server shutdown or startup.
From: John Bell on 19 Sep 2006 07:38
Hi

I would be doubtful regarding AWE, but you may want to try creating this
assembly on another server.

John

"artek" 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(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 08:54
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:

> Hi
>
> I would be doubtful regarding AWE, but you may want to try creating this
> assembly on another server.
>
> John
>
> "artek" 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(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
> > > >> >
> > >
> > >
> > >
First  |  Prev  | 
Pages: 1 2
Prev: ddl statement is not allowed
Next: error 904 Database %ld cannot be autostarted during server shutdown or startup.