Request for the permission of type 'System.Data.SqlClient.SqlClientPermission failed

来源：互联网发布：加盟淘宝诈骗立案判刑编辑：程序博客网时间：2024/06/01 10:17

在MOSS中增加一个aspx页面，aspx页面中有访问另一个sql server数据库，在相应端口的web.config中加入connectionstring后，打开页面报错：

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

Fix:
1.Open wss_mediumtrust.config & wss_minimaltrust.config usually (C:\Program Files\Common files\Microsoft Shared\Web Server Extensions\12\config\) look in your web.config file for the exact
path.

2.Find in wss_mediumtrust.config: <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

Copy and paste it into the <SecurityClasses> node of wss_minimaltrust.config.

3.In the PermissionSet section of this configuration file, add the following:
Find in wss_mediumtrust.config:

<IPermission class="SqlClientPermission" version="1" Unrestricted="true"/>
Copy and paste it into the <PermissionSet> node of wss_minimaltrust.config.

解法：

1. 找到wss_mediumtrust.config 和wss_minimaltrust.config 两个文件，正常在 C:\Program Files\Common files\Microsoft Shared\Web Server Extensions\12\config\ 中

2. 复制wss_mediumtrust.config文件中的

<SecurityClass Name="SqlClientPermission"  Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

到 wss_minimaltrust.config 中相应位置，在<SecurityClasses> 节点下

3. 复制wss_mediumtrust.config文件中的

<IPermission class="SqlClientPermission" version="1" Unrestricted="true"/>

到 wss_minimaltrust.config 中相应位置，在<PermissionSet> 节点下

参考：

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/e3e73552-6328-4434-b144-b267b9fa5860/