Calling stored procedure in CRM Plugin

(0) Share

Report

Posted on by Community Member

I am trying to access a stored procedure in CRM database by creating a linq to sql data class in CRM Plugin.

I keep getting below error.

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.Detail

Please help.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

Hi Montek,

Check this post..

blogs.msdn.com/.../accessing-a-sql-database-from-a-microsoft-dynamics-crm-plug-in.aspx

This post showing how to access database from CRM plugin.

Also check

community.dynamics.com/.../154936

Best option to call database from plugin is create webservice and in web service call database.. and call this web service into plugin.. then you will not get this kid of error.

as you are not directly accessing database from plugin.

Hope this will help..

Was this reply helpful? Yes No
Suggested answer

Mamatha Swamy 5,426 on at

Like (0)

Report

Check if these help

https://social.microsoft.com/Forums/en-US/36384ad4-3d6a-47c1-8d62-bbcb27325d50/receiving-error-on-plugin-request-for-the-permission-of-type?forum=crmdevelopment

http://stackoverflow.com/questions/20325304/how-can-i-fix-a-missing-permission-for-an-outside-resource-in-a-crm2011-custom-w

Was this reply helpful? Yes No
Suggested answer

Abed Haniyah 4,287 on at

Like (0)

Report

Dear Montek,

Please note that accessing CRM database directly from plugin is not supported, you can use web service.

Regards,

Abed.

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report

Montek,

Creating Store Proc in the CRM Database is unsupported.

If you want to call store procedure outside CRM DB then it's fine.

It seems your user doesn't have permission to access the SQL Object.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You can also get around this error by registering the plugin outside of the sandbox - in the plugin assembly, within the CRMPackage there should be a registerfile.crmregister - if you change the IsolationMode="Sandbox" to IsolationMode="None" then this fixed the problem for me. However this depends whether or not sandbox registration is essential for your plugin or not

Was this reply helpful? Yes No
Suggested answer

Hamzeh Zawahreh 3,674 on at

Like (0)

Report

hi Montek

you can the code in this link:

http://blogs.msdn.com/b/crm/archive/2008/07/08/accessing-a-sql-database-from-a-microsoft-dynamics-crm-plug-in.aspx

but you have to put your stored procedure instead of the command text

goo luck.

Was this reply helpful? Yes No
Suggested answer

Hamzeh Zawahreh 3,674 on at

Like (0)

Report

hello,

back again

you can create a web service. It can be a WCF service or classic ASMX service.

then put your code in it(calling SP in you custom code) then deploy it.

then you can create a button in the CRM form and call the service using JavaScript. You should be able to configure your service so that it can be invoked by passing any arguments in the URL parameters.

Was this reply helpful? Yes No