Installation with Sharepoint gives ‘Request for the permission of type..’ error

If installing Perfectforms in an environment with Sharepoint, the installation will go smoothly, but upon access the application, you may run into this error:

‘Request for the permission of type ‘System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′ failed.’

The application will stop working all together.

Cause: The problem itself comes from the application assemblies being run under a low level of trust by the web server. The default installation of the web server assumes a full trust level for all web applications. This is, however, overridden by Sharepoint. Thus, the problem is susceptible of occurring on all machines where Sharepoint is installed.

Solution: Resolution The trust level for the application must be manually added in the ‘web.config’ files of the /services and /API folders of the installed application. Setting the trust level to “Full” solves the problem always but may upset the web server administrators, who may chose to allow PerfectForms a lower trust level. The modification is to be brought in the respective ‘web.config’ files, under the <system.web> entry by adding a like like this:

<trust level=”Full” originUrl=””/>

Of course, the trust level must be modified as seen fit by the web server administrator. Here is an introduction on trust levels for IIS:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true