Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 UDF in Managed code throws Permission Exception

Author  Topic 

shibkumar
Starting Member

1 Post

Posted - 2009-07-17 : 03:11:56
Hi
I have a database project that implements RSA Encryption/Decryption functions in c#. After deploying the dll to SAL database, I got two UDF's(Encryption/Decryption) in the database. Now if run those functions from Query Analyser, It throws framework exception -

System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.KeyContainerPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

1. The dll is signed and deployed in GAC -
2. As suggested in other blog, Created new App_Code under .net 2.0 configuration and given the dll as Full Trust permission -
-- still giving same error...

Any help is anticipated.
Shib



Shib Kumar Thakur
   

- Advertisement -