"SriSamp" <ssampath@sct.co.in> wrote in message
news:uRwZrXGXGHA.1084@TK2MSFTNGP04.phx.gbl...
> This help topic in BOL should help you out:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/a2bc503d-b6b2-4963-8beb-c11c323f18e0.htm.
> --
> HTH,
> SriSamp
> Email: srisamp@gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
>
> "Russell Mangel" <russell@tymer.net> wrote in message
> news:%23WtP%23KGXGHA.3848@TK2MSFTNGP05.phx.gbl...
>>I am trying to get a VS2005 C# assembly created for SQL Server 2005, I am
>>unable to do so because of the security errors.
>>
>> My Question:
>> How do I register and UNSAFE assembly? I would like to be able to create
>> new Assemblies without using the impossibly complicated strong
>> certificate signing.
>>
>> I have enabled the database with SET TRUSTWORTHY ON . But I am unable to
>> figure out how to add the UNSAFE ASSEMBLY permission to the database
>> owner. Where do I set this?
>>
>> I would really like to disable these security checks for the entire SQL
>> Server, if possible.
>>
>> // Environment.MachineName is what needs more security.
>> public partial class UserDefinedFunctions
>> {
>> [Microsoft.SqlServer.Server.SqlFunction]
>> public static SqlString GetMachineName()
>> {
>> SqlString s = Environment.MachineName;
>> return s;
>> }
>> }
>>
>> // The Error message when I try to deploy the project from VS2005 C#
>> Project
>> Error 1 CREATE ASSEMBLY for assembly 'SqlServerProject1' failed because
>> assembly 'SqlServerProject1' is not authorized for PERMISSION_SET =
>> UNSAFE. The assembly is authorized when either of the following is true:
>> the database owner (DBO) has UNSAFE ASSEMBLY permission and the database
>> has the TRUSTWORTHY database property on; or the assembly is signed with
>> a certificate or an asymmetric key that has a corresponding login with
>> UNSAFE ASSEMBLY permission. SqlServerProject1
>>
>
>

"Russell Mangel" <russell@tymer.net> wrote in message
news:u71MZfGXGHA.1192@TK2MSFTNGP03.phx.gbl...
> The Link doesn't work...
>
> "SriSamp" <ssampath@sct.co.in> wrote in message
> news:uRwZrXGXGHA.1084@TK2MSFTNGP04.phx.gbl...
>> This help topic in BOL should help you out:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/a2bc503d-b6b2-4963-8beb-c11c323f18e0.htm.
>> --
>> HTH,
>> SriSamp
>> Email: srisamp@gmail.com
>> Blog: http://blogs.sqlxml.org/srinivassampath
>> URL: http://www32.brinkster.com/srisamp
>>
>> "Russell Mangel" <russell@tymer.net> wrote in message
>> news:%23WtP%23KGXGHA.3848@TK2MSFTNGP05.phx.gbl...
>>>I am trying to get a VS2005 C# assembly created for SQL Server 2005, I am
>>>unable to do so because of the security errors.
>>>
>>> My Question:
>>> How do I register and UNSAFE assembly? I would like to be able to create
>>> new Assemblies without using the impossibly complicated strong
>>> certificate signing.
>>>
>>> I have enabled the database with SET TRUSTWORTHY ON . But I am unable to
>>> figure out how to add the UNSAFE ASSEMBLY permission to the database
>>> owner. Where do I set this?
>>>
>>> I would really like to disable these security checks for the entire SQL
>>> Server, if possible.
>>>
>>> // Environment.MachineName is what needs more security.
>>> public partial class UserDefinedFunctions
>>> {
>>> [Microsoft.SqlServer.Server.SqlFunction]
>>> public static SqlString GetMachineName()
>>> {
>>> SqlString s = Environment.MachineName;
>>> return s;
>>> }
>>> }
>>>
>>> // The Error message when I try to deploy the project from VS2005 C#
>>> Project
>>> Error 1 CREATE ASSEMBLY for assembly 'SqlServerProject1' failed because
>>> assembly 'SqlServerProject1' is not authorized for PERMISSION_SET =
>>> UNSAFE. The assembly is authorized when either of the following is true:
>>> the database owner (DBO) has UNSAFE ASSEMBLY permission and the database
>>> has the TRUSTWORTHY database property on; or the assembly is signed with
>>> a certificate or an asymmetric key that has a corresponding login with
>>> UNSAFE ASSEMBLY permission. SqlServerProject1
>>>
>>
>>
>
>

"Russell Mangel" <russell@tymer.net> wrote in message
news:%23WtP%23KGXGHA.3848@TK2MSFTNGP05.phx.gbl...
>I am trying to get a VS2005 C# assembly created for SQL Server 2005, I am
>unable to do so because of the security errors.
>
> My Question:
> How do I register and UNSAFE assembly? I would like to be able to create
> new Assemblies without using the impossibly complicated strong certificate
> signing.
>
> I have enabled the database with SET TRUSTWORTHY ON . But I am unable to
> figure out how to add the UNSAFE ASSEMBLY permission to the database
> owner. Where do I set this?
>
> I would really like to disable these security checks for the entire SQL
> Server, if possible.
>
> // Environment.MachineName is what needs more security.
> public partial class UserDefinedFunctions
> {
> [Microsoft.SqlServer.Server.SqlFunction]
> public static SqlString GetMachineName()
> {
> SqlString s = Environment.MachineName;
> return s;
> }
> }
>
> // The Error message when I try to deploy the project from VS2005 C#
> Project
> Error 1 CREATE ASSEMBLY for assembly 'SqlServerProject1' failed because
> assembly 'SqlServerProject1' is not authorized for PERMISSION_SET =
> UNSAFE. The assembly is authorized when either of the following is true:
> the database owner (DBO) has UNSAFE ASSEMBLY permission and the database
> has the TRUSTWORTHY database property on; or the assembly is signed with a
> certificate or an asymmetric key that has a corresponding login with
> UNSAFE ASSEMBLY permission. SqlServerProject1
>

> I am trying to get a VS2005 C# assembly created for SQL Server 2005, I
> am unable to do so because of the security errors.
>
> My Question:
> How do I register and UNSAFE assembly? I would like to be able to
> create new Assemblies without using the impossibly complicated strong
> certificate signing.
>
> I have enabled the database with SET TRUSTWORTHY ON . But I am unable
> to figure out how to add the UNSAFE ASSEMBLY permission to the
> database owner. Where do I set this?
>

> From master you run:
> GRANT UNSAFE ASSEMBLY TO [db_owner]