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:
Post a Comment