SQL CLR execution error

Question

I am using visual studio 2012 and MS SQL Server 2012. I created SQL CLR project and followed the steps according to the following link http://blogs.interfacett.com/how-create-net-stored-procedure-sql-server

Now when I insert data in the table with which I attached a trigger, the data is inserted, but I get the following error. "Request for the permission of type 'System.Net.WebPermission, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."

Can anyone tell me, how I can fix it?

Thanks in advance.

Change the permission set of the registered assembly to "Unrestricted" and check the result. — Rikki
– Rikki, Commented Jan 30, 2013 at 10:36
Why?! By which user you logged into the SQL? Also give me the error details please. — Rikki
– Rikki, Commented Jan 30, 2013 at 10:41
Alter Database NotificationSystem Set Trustworthy On; Execute this, then alter the assembly permission set. The reason of this is that you should tell the server to trust this database first, then you can have some unrestricted assemblies inside your database. — Rikki
– Rikki, Commented Jan 30, 2013 at 10:50

Remus Rusanu · Accepted Answer · 2013-01-30 10:40:48Z

6

Do not make web calls from triggers. Use a queue do decouple the transactional data operation from the non-transactional HTTP call. Do not make web calls from inside SQL CLR. Use an external process that makes the HTTP call.

Follow the permission requirements for code access as described in CLR Integration Code Access Security:

EXTERNAL_ACCESS assemblies also have the following permissions and values:
...
WebPermission Connect: Outbound connections to web resources are allowed.

answered Jan 30, 2013 at 10:40

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jasim Khan Afridi Over a year ago

oh God, I am making web calls from here.

Collectives™ on Stack Overflow

SQL CLR execution error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related