Sunday, August 10, 2008

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, ... failed (CLR Procedure)

Solution:

1) ALTER DATABASE [Database Name] SET TRUSTWORTHY ON

2) Change the Permission Set of the CLR Code to External (Visual Studio's Project Properties)
 a) Properties > Database > Permissions Level
 b) Set to external

No comments: