RE: SQL CLR permissions needed after deployment to target server (not

Hi,

Thank you for posting here!

I notice that you have posted the same question in our
microsoft.public.sqlserver. programming newsgroup, which I have already
responded. So please check my answer there and if you need any further
assistance on this particular issue, please reply to me in that thread so I
can follow up with you in time.

For your convenience, I have included my reply as follows:

------------------
I understand that you encounter the permission issue when you run your CLR
assemblies on your server side.
If I have misunderstood, please let me know.

It seemed that EXTERNAL_ACCESS was not granted to your assembly. I
recommend that you try setting your database to trustworthy and then
elevate the PERMISSION_SET of your assembly to EXTERNAL_ACCESS, such as:
ALTER DATABASE YourDatabaseName SET TRUSTWORTHY ON
Go
ALTER ASSEMBLY YourAssemblyName WITH PERMISSION_SET = EXTERNAL_ACCESS
Go

Also I would like to let you know that the current assembly
System.Data.SqlClient is not a supported assembly for SQL Server. Please
carefully test it to see if there is any issue after you deploy it. You may
refer to this KB article:
Support policy for untested .NET Framework assemblies in the SQL Server
2005 CLR-hosted environment
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922672


Hope this helps. Please feel free to let me know if you have any other
questions or concerns.
------------------

Thank you and have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

.

Relevant Pages

  • RE: SQL CLR permissions needed after deployment to target server (
    ... it covers both programming and security. ... Support policy for untested .NET Framework assemblies in the SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: To GAC or not?
    ... Does no one fully read posts before responding? ... publishing server that then replicates out to the production farm. ... Sharing assemblies is all fine and dandy, but no one has answered my ... question about sharing user defined controls, ...
    (microsoft.public.dotnet.general)
  • Re: Reg-Free COM Error
    ... and contact customer support if I can't figure it out. ... assemblies when I use Reg-Free COM. ... modify my manifest file before it compiles as a resource, ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.interop)
  • SQLClientPermission problem
    ... The database is on Machine 1. ... Both machines have SQL Server 2005 Express installed. ... assemblies on my local intranet signed with my strong name. ...
    (microsoft.public.dotnet.security)
  • RE: Settings inaccessible due to its protection level
    ... this problem with accessibility to the Settings class went ... For more information about ASP.NET compilation model, ... This add-in includes a tool to merge the assemblies ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.aspnet)