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

在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/