|
-
Dec 25th, 2006, 02:40 PM
#1
Thread Starter
Addicted Member
error while deploying clr from visualstudio2005
clr error while deploing from studio
--------------------------------------------------------------------------------
When I deploye by myself clr into database compiling command prompt and adding assembly and creating stored procedute for it, it works fine .
But when I do it form visual studio2005 it deploys fine but while executing the stored procedure it gives me following error.
Msg 6522, Level 16, State 1, Procedure SendPreBirthdayMessage, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'SendPreBirthdayMessage':
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Employee.SqlServerProject.PreBirthdayMessage.SendPreBirthdayMessage()
How to solve this
(Rate)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|