webparts & sqlclientpermission

[António Pinho]

Hi,

I have a big problem with an webpart/assembly. i'm trying to connect to sql
server but i get the error "Request for the permission of type
System.Data.Sql Client.SqlClien tPermission, System.Data, Version=1.0.500 0.0,
Culture=neutral , PublicKeyToken= b77a5c561934e08 9 failed.". i've searched for
it and can't find a clear answer. but one thing i'm sure: permissions. if i
change the trust level in the web.config of the sharepoint portal that i
created to full, everything works fine.

can someone help me?

TIA


code of the assembly, web.config, wss_minimaltrus t_Custom.config

webpart/assembly

protected override void RenderWebPart(H tmlTextWriter output)
{
String strConn =
"server=myserve r;database=mydb ;uid=myuser;pas sword=mypwd;";
SqlClientPermis sion permission = new
SqlClientPermis sion(Permission State.Unrestric ted);

try
{
permission.Dema nd();
permission.Asse rt();

SqlConnection Conn = new SqlConnection(s trConn);
Conn.Open();
Conn.Close();
Conn.Dispose();
}
catch (Exception ex)
{
output.Write(ex .Message);
}
finally
{
output.Write(" the end");
};
}


web.config

<configuratio n>
<configSections >
<sectionGroup name="SharePoin t">
<section name="SafeContr ols"
type="Microsoft .SharePoint.App licationRuntime .SafeControlsCo nfigurationHand l
er, Microsoft.Share Point, Version=11.0.0. 0, Culture=neutral ,
PublicKeyToken= 71e9bce111e9429 c" />
<section name="RuntimeFi lter"
type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
<section name="WebPartLi mits"
type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
<section name="WebPartCa che"
type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
<section name="WebPartWo rkItem"
type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
<section name="WebPartCo ntrols"
type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
<section name="SafeMode"
type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
<section name="OnlineLib rary"
type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
</sectionGroup>
</configSections>
<SharePoint>
<SafeMode MaxControls="50 " CallStack="fals e" />
<WebPartLimit s MaxZoneParts="5 0" PropertySize="1 048576" />
<WebPartCache Storage="CacheO bject" />
<WebPartWorkIte m Timeout="7000" />
<WebPartControl s
DatasheetContro lGuid="65BCBEE4-7728-41a0-97BE-14E1CAE36AAE" />
<!--
SafeControl Attributes:
Assembly="[Assembly]" - The .NET assembly in which the control is
contained. This attribute can also contain version, culture, and public key
token information.
Namespace="[Namespace]" - The .NET namespace in which the control
is defined.
TypeName="[Typename]" - The .NET class name of the control. You
can type an asterisk (*) wildcard character to indicate all TypeNames in a
Namespace.
Safe="[True|False]" - Specifies whether a Web Part or Web Form
Control is safe and can be displayed on a Web Parts Page. This attribute is
True by default.
-->
<SafeControls >
<SafeControl Assembly="Syste m.Web, Version=1.0.500 0.0,
Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
Namespace="Syst em.Web.UI.WebCo ntrols" TypeName="*" Safe="True" />
<SafeControl Assembly="Syste m.Web, Version=1.0.500 0.0,
Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
Namespace="Syst em.Web.UI.HtmlC ontrols" TypeName="*" Safe="True" />
<SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t" TypeName="*" Safe="True" />
<SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t.WebPartPages" TypeName="*" Safe="True" />
<SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t.WebControls" TypeName="*" Safe="True" />
<SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t.ApplicationPa ges" TypeName="*" Safe="True"
/>
<SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t.SoapServer" TypeName="*" Safe="True" />
<SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t.Meetings" TypeName="*" Safe="True" />
<SafeControl Assembly="Micro soft.SharePoint .Portal, Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t.Portal.WebCon trols" TypeName="*" />
<SafeControl Assembly="Micro soft.SharePoint .Portal, Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Namespace="Micr osoft.SharePoin t.Portal.WebCon trols.Alerts" TypeName="*" />
<SafeControl Assembly="WebPa rtLibrary1, Version=1.0.0.0 ,
Culture=neutral , PublicKeyToken= 819bece51b5870e 7"
Namespace="WebP artLibrary1" TypeName="*" Safe="True" />
</SafeControls>
<!--<OnlineLibrar y Url="http://r.office.micros oft.com/r/hlidAwsGallery"
/>-->
<RuntimeFilte r Assembly="Micro soft.SharePoint .Portal, Version=11.0.0. 0,
Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
Class="Microsof t.SharePoint.Po rtal.Audience.A udienceManager"
BuilderURL="aud ience_chooser.a spx" />
</SharePoint>
<system.web>
<securityPolicy >
<trustLevel name="WSS_Mediu m" policyFile="C:\ Program Files\Common
Files\Microsoft Shared\Web Server
Extensions\60\c onfig\wss_mediu mtrust.config" />
<trustLevel name="WSS_Minim al" policyFile="C:\ Program Files\Common
Files\Microsoft Shared\Web Server
Extensions\60\c onfig\wss_minim altrust.config" />
<trustLevel name="WSS_Minim al_Custom" policyFile="C:\ Program
Files\Common Files\Microsoft Shared\Web Server
Extensions\60\c onfig\wss_minim altrust_Custom. config" />
</securityPolicy>
<httpHandlers >
<add verb="*" path="/_vti_bin/*.aspx"
type="System.We b.UI.PageHandle rFactory, System.Web, Version=1.0.500 0.0,
Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a" />
<add verb="*" path="*.aspx"
type="Microsoft .SharePoint.App licationRuntime .SharePointHand lerFactory,
Microsoft.Share Point, Version=11.0.0. 0, Culture=neutral ,
PublicKeyToken= 71e9bce111e9429 c" />
</httpHandlers>
<customErrors mode="On" />
<httpRuntime maxRequestLengt h="51200" />
<authenticati on mode="Windows" />
<authorizatio n>
<allow users="*" />
</authorization>



wss_minimaltrus t_Custom.config

<configuratio n>
<mscorlib>
<security>
<policy>
<PolicyLevel version="1">
<SecurityClasse s>
<SecurityClas s Name="AllMember shipCondition"
Description="Sy stem.Security.P olicy.AllMember shipCondition, mscorlib,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="AspNetHos tingPermission"
Description="Sy stem.Web.AspNet HostingPermissi on, System, Version=1.0.500 0.0,
Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="FirstMatc hCodeGroup"
Description="Sy stem.Security.P olicy.FirstMatc hCodeGroup, mscorlib,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="NamedPerm issionSet"
Description="Sy stem.Security.N amedPermissionS et"/>
<SecurityClas s Name="SecurityP ermission"
Description="Sy stem.Security.P ermissions.Secu rityPermission, mscorlib,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="StrongNam eMembershipCond ition"
Description="Sy stem.Security.P olicy.StrongNam eMembershipCond ition, mscorlib,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="UnionCode Group"
Description="Sy stem.Security.P olicy.UnionCode Group, mscorlib,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="UrlMember shipCondition"
Description="Sy stem.Security.P olicy.UrlMember shipCondition, mscorlib,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="WebPartPe rmission"
Description="Mi crosoft.SharePo int.Security.We bPartPermission ,
Microsoft.Share Point.Security, Version=11.0.0. 0, Culture=neutral ,
PublicKeyToken= 71e9bce111e9429 c"/>
<SecurityClas s Name="ZoneMembe rshipCondition"
Description="Sy stem.Security.P olicy.ZoneMembe rshipCondition, mscorlib,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
<SecurityClas s Name="SqlClient Permission"
Description="Sy stem.Data.SqlCl ient.SqlClientP ermission, System.Data,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
</SecurityClasses >
<NamedPermissio nSets>
<PermissionSe t
class="NamedPer missionSet"
version="1"
Unrestricted="t rue"
Name="FullTrust "
Description="Al lows full access to all
resources"
/>
<PermissionSe t
class="NamedPer missionSet"
version="1"
Name="Nothing"
Description="De nies all resources, including
the right to execute"
/>
<PermissionSe t
class="NamedPer missionSet"
version="1"
Name="ASP.Net">
<IPermission
class="AspNetHo stingPermission "
version="1"
Level="Minimal"
/>
<IPermission
class="Security Permission"
version="1"
Flags="Executio n"
/>
<IPermission class="WebPartP ermission"
version="1"
Connections="Tr ue"
/>
</PermissionSet>
<PermissionSe t class="NamedPer missionSet"
version="1" Name="WebPartLi brary1Permissio nSet">
<IPermission class="AspNetHo stingPermission " version="1" Level="Medium"
/>
<IPermission class="Security Permission" version="1" Flags="Assertio n,
Execution, ControlThread, ControlPrincipa l, RemotingConfigu ration,
UnmanagedCode" />
<IPermission class="WebPartP ermission" version="1" Connections="Tr ue" />
<IPermission class="SqlClien tPermission" version="1"
AllowBlankPassw ord="False" />
</PermissionSet>
</NamedPermission Sets>
<CodeGroup
class="FirstMat chCodeGroup"
version="1"
PermissionSetNa me="Nothing">
<IMembershipCon dition
class="AllMembe rshipCondition"
version="1"
/>
<CodeGroup
class="UnionCod eGroup" version="1"
PermissionSetNa me="WebPartLibr ary1PermissionS et">
<IMembershipCon dition
class="StrongNa meMembershipCon dition"
version="1"

PublicKeyBlob=" 002400000480000 094000000060200 000024000052534 131000400000100 0
100B791C96EBFCD 6E192C8998945A6 28B4E3F466EC49B FA4C812BCE256F6 CB8BB734D2EAC64 F
6D0C3CFC52135C3 21B21C124765123 69A0D5BCAD0ED80 587C2655A34C681 1D353219C680E95 5
E47871281302233 AFF8A0D4009F592 99B3867DF61823E 36FEAA55A5DB0AB DEE2EC39745068C 5
8BF32E13F2709EC 147890FD33B847D 5" />
</CodeGroup>
<CodeGroup
class="UnionCod eGroup"
version="1"
PermissionSetNa me="ASP.Net">
<IMembershipCon dition
class="UrlMembe rshipCondition"
version="1"
Url="$AppDirUrl $/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCod eGroup"
version="1"
PermissionSetNa me="FullTrust" >
<IMembershipCon dition
class="UrlMembe rshipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCod eGroup"
version="1"
PermissionSetNa me="FullTrust" >
<IMembershipCon dition
class="UrlMembe rshipCondition"
Url="$Gac$/*"
version="1"
/>
</CodeGroup>
<CodeGroup class="UnionCod eGroup" version="1"
PermissionSetNa me="Nothing">
<IMembershipCon dition
class="ZoneMemb ershipCondition "
version="1"
Zone="MyCompute r" />
<CodeGroup
class="UnionCod eGroup"
version="1"
PermissionSetNa me="FullTrust"
Name="Microsoft _Strong_Name"
Description="Th is code group grants code
signed with the Microsoft strong name full trust. ">
<IMembershipCon dition

class="StrongNa meMembershipCon dition"
version="1"

PublicKeyBlob=" 002400000480000 094000000060200 000024000052534 131000400000100 0
10007D1FA57C4AE D9F0A32E84AA0FA EFD0DE9E8FD6AEC 8F87FB03766C834 C99921EB23BE79A D
9D5DCC1DD9AD236 132102900B723CF 980957FC4E17710 8FC607774F29E83 20E92EA05ECE4E8 2
1C0A5EFE8F1645C 4C0C93C1AB99285 D622CAA652C1DFA D63D745D6F2DE5F 17E5EAF0FC4963D 2
61C8A1243651820 6DC093344D5AD29 3"
/>
</CodeGroup>
<CodeGroup
class="UnionCod eGroup"
version="1"
PermissionSetNa me="FullTrust"
Name="Ecma_Stro ng_Name"
Description="Th is code group grants code
signed with the ECMA strong name full trust. ">
<IMembershipCon dition

class="StrongNa meMembershipCon dition"
version="1"

PublicKeyBlob=" 000000000000000 004000000000000 00"
/>
</CodeGroup>
</CodeGroup>
</CodeGroup>
</PolicyLevel>
</policy>
</security>
</mscorlib>
</configuration>

[Mihai Durcau]

Re: webparts &amp; sqlclientpermis sion

Try to add in web.config the SQL Assembly in the SAFE section:

<SafeControls >
<SafeControl Assembly="Syste m.Data.SqlClien t, Version=1.0.500 0.0,
Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
Namespace="Syst em.Web.UI.WebCo ntrols" TypeName="*" Safe="True" />
of course IISReset - don't forget where you are :-)
MD

"António Pinho" <ajlpinho@hotma il.com> wrote in message
news:OLduq$jIEH A.3720@tk2msftn gp13.phx.gbl...[color=blue]
> Hi,
>
> I have a big problem with an webpart/assembly. i'm trying to connect to[/color]
sql[color=blue]
> server but i get the error "Request for the permission of type
> System.Data.Sql Client.SqlClien tPermission, System.Data,[/color]
Version=1.0.500 0.0,[color=blue]
> Culture=neutral , PublicKeyToken= b77a5c561934e08 9 failed.". i've searched[/color]
for[color=blue]
> it and can't find a clear answer. but one thing i'm sure: permissions. if[/color]
i[color=blue]
> change the trust level in the web.config of the sharepoint portal that i
> created to full, everything works fine.
>
> can someone help me?
>
> TIA
>
>
> code of the assembly, web.config, wss_minimaltrus t_Custom.config
>
> webpart/assembly
>
> protected override void RenderWebPart(H tmlTextWriter output)
> {
> String strConn =
> "server=myserve r;database=mydb ;uid=myuser;pas sword=mypwd;";
> SqlClientPermis sion permission = new
> SqlClientPermis sion(Permission State.Unrestric ted);
>
> try
> {
> permission.Dema nd();
> permission.Asse rt();
>
> SqlConnection Conn = new SqlConnection(s trConn);
> Conn.Open();
> Conn.Close();
> Conn.Dispose();
> }
> catch (Exception ex)
> {
> output.Write(ex .Message);
> }
> finally
> {
> output.Write(" the end");
> };
> }
>
>
> web.config
>
> <configuratio n>
> <configSections >
> <sectionGroup name="SharePoin t">
> <section name="SafeContr ols"
>[/color]
type="Microsoft .SharePoint.App licationRuntime .SafeControlsCo nfigurationHand l[color=blue]
> er, Microsoft.Share Point, Version=11.0.0. 0, Culture=neutral ,
> PublicKeyToken= 71e9bce111e9429 c" />
> <section name="RuntimeFi lter"
> type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> <section name="WebPartLi mits"
> type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> <section name="WebPartCa che"
> type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> <section name="WebPartWo rkItem"
> type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> <section name="WebPartCo ntrols"
> type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> <section name="SafeMode"
> type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> <section name="OnlineLib rary"
> type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> </sectionGroup>
> </configSections>
> <SharePoint>
> <SafeMode MaxControls="50 " CallStack="fals e" />
> <WebPartLimit s MaxZoneParts="5 0" PropertySize="1 048576" />
> <WebPartCache Storage="CacheO bject" />
> <WebPartWorkIte m Timeout="7000" />
> <WebPartControl s
> DatasheetContro lGuid="65BCBEE4-7728-41a0-97BE-14E1CAE36AAE" />
> <!--
> SafeControl Attributes:
> Assembly="[Assembly]" - The .NET assembly in which the control[/color]
is[color=blue]
> contained. This attribute can also contain version, culture, and public[/color]
key[color=blue]
> token information.
> Namespace="[Namespace]" - The .NET namespace in which the[/color]
control[color=blue]
> is defined.
> TypeName="[Typename]" - The .NET class name of the control. You
> can type an asterisk (*) wildcard character to indicate all TypeNames in a
> Namespace.
> Safe="[True|False]" - Specifies whether a Web Part or Web Form
> Control is safe and can be displayed on a Web Parts Page. This attribute[/color]
is[color=blue]
> True by default.
> -->
> <SafeControls >
> <SafeControl Assembly="Syste m.Web, Version=1.0.500 0.0,
> Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
> Namespace="Syst em.Web.UI.WebCo ntrols" TypeName="*" Safe="True" />
> <SafeControl Assembly="Syste m.Web, Version=1.0.500 0.0,
> Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
> Namespace="Syst em.Web.UI.HtmlC ontrols" TypeName="*" Safe="True" />
> <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t" TypeName="*" Safe="True" />
> <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t.WebPartPages" TypeName="*" Safe="True" />
> <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t.WebControls" TypeName="*" Safe="True" />
> <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t.ApplicationPa ges" TypeName="*" Safe="True"
> />
> <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t.SoapServer" TypeName="*" Safe="True" />
> <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t.Meetings" TypeName="*" Safe="True" />
> <SafeControl Assembly="Micro soft.SharePoint .Portal,[/color]
Version=11.0.0. 0,[color=blue]
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t.Portal.WebCon trols" TypeName="*" />
> <SafeControl Assembly="Micro soft.SharePoint .Portal,[/color]
Version=11.0.0. 0,[color=blue]
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Namespace="Micr osoft.SharePoin t.Portal.WebCon trols.Alerts" TypeName="*" />
> <SafeControl Assembly="WebPa rtLibrary1, Version=1.0.0.0 ,
> Culture=neutral , PublicKeyToken= 819bece51b5870e 7"
> Namespace="WebP artLibrary1" TypeName="*" Safe="True" />
> </SafeControls>
> <!--<OnlineLibrar y[/color]
Url="http://r.office.micros oft.com/r/hlidAwsGallery"[color=blue]
> />-->
> <RuntimeFilte r Assembly="Micro soft.SharePoint .Portal,[/color]
Version=11.0.0. 0,[color=blue]
> Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> Class="Microsof t.SharePoint.Po rtal.Audience.A udienceManager"
> BuilderURL="aud ience_chooser.a spx" />
> </SharePoint>
> <system.web>
> <securityPolicy >
> <trustLevel name="WSS_Mediu m" policyFile="C:\ Program Files\Common
> Files\Microsoft Shared\Web Server
> Extensions\60\c onfig\wss_mediu mtrust.config" />
> <trustLevel name="WSS_Minim al" policyFile="C:\ Program Files\Common
> Files\Microsoft Shared\Web Server
> Extensions\60\c onfig\wss_minim altrust.config" />
> <trustLevel name="WSS_Minim al_Custom" policyFile="C:\ Program
> Files\Common Files\Microsoft Shared\Web Server
> Extensions\60\c onfig\wss_minim altrust_Custom. config" />
> </securityPolicy>
> <httpHandlers >
> <add verb="*" path="/_vti_bin/*.aspx"
> type="System.We b.UI.PageHandle rFactory, System.Web, Version=1.0.500 0.0,
> Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a" />
> <add verb="*" path="*.aspx"
> type="Microsoft .SharePoint.App licationRuntime .SharePointHand lerFactory,
> Microsoft.Share Point, Version=11.0.0. 0, Culture=neutral ,
> PublicKeyToken= 71e9bce111e9429 c" />
> </httpHandlers>
> <customErrors mode="On" />
> <httpRuntime maxRequestLengt h="51200" />
> <authenticati on mode="Windows" />
> <authorizatio n>
> <allow users="*" />
> </authorization>
>
>
>
> wss_minimaltrus t_Custom.config
>
> <configuratio n>
> <mscorlib>
> <security>
> <policy>
> <PolicyLevel version="1">
> <SecurityClasse s>
> <SecurityClas s Name="AllMember shipCondition"
> Description="Sy stem.Security.P olicy.AllMember shipCondition, mscorlib,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s Name="AspNetHos tingPermission"
> Description="Sy stem.Web.AspNet HostingPermissi on, System,[/color]
Version=1.0.500 0.0,[color=blue]
> Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s Name="FirstMatc hCodeGroup"
> Description="Sy stem.Security.P olicy.FirstMatc hCodeGroup, mscorlib,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s Name="NamedPerm issionSet"
> Description="Sy stem.Security.N amedPermissionS et"/>
> <SecurityClas s Name="SecurityP ermission"
> Description="Sy stem.Security.P ermissions.Secu rityPermission, mscorlib,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s[/color]
Name="StrongNam eMembershipCond ition"[color=blue]
> Description="Sy stem.Security.P olicy.StrongNam eMembershipCond ition,[/color]
mscorlib,[color=blue]
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s Name="UnionCode Group"
> Description="Sy stem.Security.P olicy.UnionCode Group, mscorlib,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s Name="UrlMember shipCondition"
> Description="Sy stem.Security.P olicy.UrlMember shipCondition, mscorlib,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s Name="WebPartPe rmission"
> Description="Mi crosoft.SharePo int.Security.We bPartPermission ,
> Microsoft.Share Point.Security, Version=11.0.0. 0, Culture=neutral ,
> PublicKeyToken= 71e9bce111e9429 c"/>
> <SecurityClas s Name="ZoneMembe rshipCondition"
> Description="Sy stem.Security.P olicy.ZoneMembe rshipCondition, mscorlib,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> <SecurityClas s Name="SqlClient Permission"
> Description="Sy stem.Data.SqlCl ient.SqlClientP ermission, System.Data,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> </SecurityClasses >
> <NamedPermissio nSets>
> <PermissionSe t
> class="NamedPer missionSet"
> version="1"
> Unrestricted="t rue"
> Name="FullTrust "
> Description="Al lows full access to all
> resources"
> />
> <PermissionSe t
> class="NamedPer missionSet"
> version="1"
> Name="Nothing"
> Description="De nies all resources,[/color]
including[color=blue]
> the right to execute"
> />
> <PermissionSe t
> class="NamedPer missionSet"
> version="1"
> Name="ASP.Net">
> <IPermission
> class="AspNetHo stingPermission "
> version="1"
> Level="Minimal"
> />
> <IPermission
> class="Security Permission"
> version="1"
> Flags="Executio n"
> />
> <IPermission class="WebPartP ermission"
> version="1"
> Connections="Tr ue"
> />
> </PermissionSet>
> <PermissionSe t class="NamedPer missionSet"
> version="1" Name="WebPartLi brary1Permissio nSet">
> <IPermission class="AspNetHo stingPermission " version="1"[/color]
Level="Medium"[color=blue]
> />
> <IPermission class="Security Permission" version="1" Flags="Assertio n,
> Execution, ControlThread, ControlPrincipa l, RemotingConfigu ration,
> UnmanagedCode" />
> <IPermission class="WebPartP ermission" version="1" Connections="Tr ue"[/color]
/>[color=blue]
> <IPermission class="SqlClien tPermission" version="1"
> AllowBlankPassw ord="False" />
> </PermissionSet>
> </NamedPermission Sets>
> <CodeGroup
> class="FirstMat chCodeGroup"
> version="1"
> PermissionSetNa me="Nothing">
> <IMembershipCon dition
> class="AllMembe rshipCondition"
> version="1"
> />
> <CodeGroup
> class="UnionCod eGroup" version="1"
> PermissionSetNa me="WebPartLibr ary1PermissionS et">
> <IMembershipCon dition
> class="StrongNa meMembershipCon dition"
> version="1"
>
>[/color]
PublicKeyBlob=" 002400000480000 094000000060200 000024000052534 131000400000100 0[color=blue]
>[/color]
100B791C96EBFCD 6E192C8998945A6 28B4E3F466EC49B FA4C812BCE256F6 CB8BB734D2EAC64 F[color=blue]
>[/color]
6D0C3CFC52135C3 21B21C124765123 69A0D5BCAD0ED80 587C2655A34C681 1D353219C680E95 5[color=blue]
>[/color]
E47871281302233 AFF8A0D4009F592 99B3867DF61823E 36FEAA55A5DB0AB DEE2EC39745068C 5[color=blue]
> 8BF32E13F2709EC 147890FD33B847D 5" />
> </CodeGroup>
> <CodeGroup
> class="UnionCod eGroup"
> version="1"
> PermissionSetNa me="ASP.Net">
> <IMembershipCon dition
> class="UrlMembe rshipCondition"
> version="1"
> Url="$AppDirUrl $/*"
> />
> </CodeGroup>
> <CodeGroup
> class="UnionCod eGroup"
> version="1"
> PermissionSetNa me="FullTrust" >
> <IMembershipCon dition
> class="UrlMembe rshipCondition"
> version="1"
> Url="$CodeGen$/*"
> />
> </CodeGroup>
> <CodeGroup
> class="UnionCod eGroup"
> version="1"
> PermissionSetNa me="FullTrust" >
> <IMembershipCon dition
> class="UrlMembe rshipCondition"
> Url="$Gac$/*"
> version="1"
> />
> </CodeGroup>
> <CodeGroup class="UnionCod eGroup" version="1"
> PermissionSetNa me="Nothing">
> <IMembershipCon dition
> class="ZoneMemb ershipCondition "
> version="1"
> Zone="MyCompute r" />
> <CodeGroup
> class="UnionCod eGroup"
> version="1"
> PermissionSetNa me="FullTrust"
> Name="Microsoft _Strong_Name"
> Description="Th is code group grants[/color]
code[color=blue]
> signed with the Microsoft strong name full trust. ">
> <IMembershipCon dition
>
> class="StrongNa meMembershipCon dition"
> version="1"
>
>[/color]
PublicKeyBlob=" 002400000480000 094000000060200 000024000052534 131000400000100 0[color=blue]
>[/color]
10007D1FA57C4AE D9F0A32E84AA0FA EFD0DE9E8FD6AEC 8F87FB03766C834 C99921EB23BE79A D[color=blue]
>[/color]
9D5DCC1DD9AD236 132102900B723CF 980957FC4E17710 8FC607774F29E83 20E92EA05ECE4E8 2[color=blue]
>[/color]
1C0A5EFE8F1645C 4C0C93C1AB99285 D622CAA652C1DFA D63D745D6F2DE5F 17E5EAF0FC4963D 2[color=blue]
> 61C8A1243651820 6DC093344D5AD29 3"
> />
> </CodeGroup>
> <CodeGroup
> class="UnionCod eGroup"
> version="1"
> PermissionSetNa me="FullTrust"
> Name="Ecma_Stro ng_Name"
> Description="Th is code group grants[/color]
code[color=blue]
> signed with the ECMA strong name full trust. ">
> <IMembershipCon dition
>
> class="StrongNa meMembershipCon dition"
> version="1"
>
> PublicKeyBlob=" 000000000000000 004000000000000 00"
> />
> </CodeGroup>
> </CodeGroup>
> </CodeGroup>
> </PolicyLevel>
> </policy>
> </security>
> </mscorlib>
> </configuration>
>
>
>
>
>[/color]

[António Pinho]

Re: webparts &amp; sqlclientpermis sion

Hi Mihai,

Thanks for your reply, but it didn't work. The error message is still there.
This is a default sharepoint installation, and a portal with just one site
(a blank site) on it. Any other suggestion?

Isn't there anyone that uses webparts with sql server, without raising the
trust level to full?



TIA




"Mihai Durcau" <mdurcau@mdsi.c a> wrote in message
news:e%23z$87wI EHA.3376@TK2MSF TNGP09.phx.gbl. ..[color=blue]
> Try to add in web.config the SQL Assembly in the SAFE section:
>
> <SafeControls >
> <SafeControl Assembly="Syste m.Data.SqlClien t, Version=1.0.500 0.0,
> Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
> Namespace="Syst em.Web.UI.WebCo ntrols" TypeName="*" Safe="True" />
> of course IISReset - don't forget where you are :-)
> MD
>
> "António Pinho" <ajlpinho@hotma il.com> wrote in message
> news:OLduq$jIEH A.3720@tk2msftn gp13.phx.gbl...[color=green]
> > Hi,
> >
> > I have a big problem with an webpart/assembly. i'm trying to connect to[/color]
> sql[color=green]
> > server but i get the error "Request for the permission of type
> > System.Data.Sql Client.SqlClien tPermission, System.Data,[/color]
> Version=1.0.500 0.0,[color=green]
> > Culture=neutral , PublicKeyToken= b77a5c561934e08 9 failed.". i've searched[/color]
> for[color=green]
> > it and can't find a clear answer. but one thing i'm sure: permissions.[/color][/color]
if[color=blue]
> i[color=green]
> > change the trust level in the web.config of the sharepoint portal that i
> > created to full, everything works fine.
> >
> > can someone help me?
> >
> > TIA
> >
> >
> > code of the assembly, web.config, wss_minimaltrus t_Custom.config
> >
> > webpart/assembly
> >
> > protected override void RenderWebPart(H tmlTextWriter output)
> > {
> > String strConn =
> > "server=myserve r;database=mydb ;uid=myuser;pas sword=mypwd;";
> > SqlClientPermis sion permission = new
> > SqlClientPermis sion(Permission State.Unrestric ted);
> >
> > try
> > {
> > permission.Dema nd();
> > permission.Asse rt();
> >
> > SqlConnection Conn = new SqlConnection(s trConn);
> > Conn.Open();
> > Conn.Close();
> > Conn.Dispose();
> > }
> > catch (Exception ex)
> > {
> > output.Write(ex .Message);
> > }
> > finally
> > {
> > output.Write(" the end");
> > };
> > }
> >
> >
> > web.config
> >
> > <configuratio n>
> > <configSections >
> > <sectionGroup name="SharePoin t">
> > <section name="SafeContr ols"
> >[/color]
>[/color]
type="Microsoft .SharePoint.App licationRuntime .SafeControlsCo nfigurationHand l[color=blue][color=green]
> > er, Microsoft.Share Point, Version=11.0.0. 0, Culture=neutral ,
> > PublicKeyToken= 71e9bce111e9429 c" />
> > <section name="RuntimeFi lter"
> > type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> > <section name="WebPartLi mits"
> > type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> > <section name="WebPartCa che"
> > type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> > <section name="WebPartWo rkItem"
> > type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> > <section name="WebPartCo ntrols"
> > type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> > <section name="SafeMode"
> > type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> > <section name="OnlineLib rary"
> > type="System.Co nfiguration.Sin gleTagSectionHa ndler, System,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9" />
> > </sectionGroup>
> > </configSections>
> > <SharePoint>
> > <SafeMode MaxControls="50 " CallStack="fals e" />
> > <WebPartLimit s MaxZoneParts="5 0" PropertySize="1 048576" />
> > <WebPartCache Storage="CacheO bject" />
> > <WebPartWorkIte m Timeout="7000" />
> > <WebPartControl s
> > DatasheetContro lGuid="65BCBEE4-7728-41a0-97BE-14E1CAE36AAE" />
> > <!--
> > SafeControl Attributes:
> > Assembly="[Assembly]" - The .NET assembly in which the control[/color]
> is[color=green]
> > contained. This attribute can also contain version, culture, and public[/color]
> key[color=green]
> > token information.
> > Namespace="[Namespace]" - The .NET namespace in which the[/color]
> control[color=green]
> > is defined.
> > TypeName="[Typename]" - The .NET class name of the control.[/color][/color]
You[color=blue][color=green]
> > can type an asterisk (*) wildcard character to indicate all TypeNames in[/color][/color]
a[color=blue][color=green]
> > Namespace.
> > Safe="[True|False]" - Specifies whether a Web Part or Web Form
> > Control is safe and can be displayed on a Web Parts Page. This attribute[/color]
> is[color=green]
> > True by default.
> > -->
> > <SafeControls >
> > <SafeControl Assembly="Syste m.Web, Version=1.0.500 0.0,
> > Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
> > Namespace="Syst em.Web.UI.WebCo ntrols" TypeName="*" Safe="True" />
> > <SafeControl Assembly="Syste m.Web, Version=1.0.500 0.0,
> > Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
> > Namespace="Syst em.Web.UI.HtmlC ontrols" TypeName="*" Safe="True" />
> > <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t" TypeName="*" Safe="True" />
> > <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t.WebPartPages" TypeName="*" Safe="True"[/color][/color]
/>[color=blue][color=green]
> > <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t.WebControls" TypeName="*" Safe="True" />
> > <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t.ApplicationPa ges" TypeName="*"[/color][/color]
Safe="True"[color=blue][color=green]
> > />
> > <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t.SoapServer" TypeName="*" Safe="True" />
> > <SafeControl Assembly="Micro soft.SharePoint , Version=11.0.0. 0,
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t.Meetings" TypeName="*" Safe="True" />
> > <SafeControl Assembly="Micro soft.SharePoint .Portal,[/color]
> Version=11.0.0. 0,[color=green]
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t.Portal.WebCon trols" TypeName="*" />
> > <SafeControl Assembly="Micro soft.SharePoint .Portal,[/color]
> Version=11.0.0. 0,[color=green]
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Namespace="Micr osoft.SharePoin t.Portal.WebCon trols.Alerts" TypeName="*"[/color][/color]
/>[color=blue][color=green]
> > <SafeControl Assembly="WebPa rtLibrary1, Version=1.0.0.0 ,
> > Culture=neutral , PublicKeyToken= 819bece51b5870e 7"
> > Namespace="WebP artLibrary1" TypeName="*" Safe="True" />
> > </SafeControls>
> > <!--<OnlineLibrar y[/color]
> Url="http://r.office.micros oft.com/r/hlidAwsGallery"[color=green]
> > />-->
> > <RuntimeFilte r Assembly="Micro soft.SharePoint .Portal,[/color]
> Version=11.0.0. 0,[color=green]
> > Culture=neutral , PublicKeyToken= 71e9bce111e9429 c"
> > Class="Microsof t.SharePoint.Po rtal.Audience.A udienceManager"
> > BuilderURL="aud ience_chooser.a spx" />
> > </SharePoint>
> > <system.web>
> > <securityPolicy >
> > <trustLevel name="WSS_Mediu m" policyFile="C:\ Program Files\Common
> > Files\Microsoft Shared\Web Server
> > Extensions\60\c onfig\wss_mediu mtrust.config" />
> > <trustLevel name="WSS_Minim al" policyFile="C:\ Program Files\Common
> > Files\Microsoft Shared\Web Server
> > Extensions\60\c onfig\wss_minim altrust.config" />
> > <trustLevel name="WSS_Minim al_Custom" policyFile="C:\ Program
> > Files\Common Files\Microsoft Shared\Web Server
> > Extensions\60\c onfig\wss_minim altrust_Custom. config" />
> > </securityPolicy>
> > <httpHandlers >
> > <add verb="*" path="/_vti_bin/*.aspx"
> > type="System.We b.UI.PageHandle rFactory, System.Web, Version=1.0.500 0.0,
> > Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a" />
> > <add verb="*" path="*.aspx"
> > type="Microsoft .SharePoint.App licationRuntime .SharePointHand lerFactory,
> > Microsoft.Share Point, Version=11.0.0. 0, Culture=neutral ,
> > PublicKeyToken= 71e9bce111e9429 c" />
> > </httpHandlers>
> > <customErrors mode="On" />
> > <httpRuntime maxRequestLengt h="51200" />
> > <authenticati on mode="Windows" />
> > <authorizatio n>
> > <allow users="*" />
> > </authorization>
> >
> >
> >
> > wss_minimaltrus t_Custom.config
> >
> > <configuratio n>
> > <mscorlib>
> > <security>
> > <policy>
> > <PolicyLevel version="1">
> > <SecurityClasse s>
> > <SecurityClas s Name="AllMember shipCondition"
> > Description="Sy stem.Security.P olicy.AllMember shipCondition, mscorlib,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s Name="AspNetHos tingPermission"
> > Description="Sy stem.Web.AspNet HostingPermissi on, System,[/color]
> Version=1.0.500 0.0,[color=green]
> > Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s Name="FirstMatc hCodeGroup"
> > Description="Sy stem.Security.P olicy.FirstMatc hCodeGroup, mscorlib,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s Name="NamedPerm issionSet"
> > Description="Sy stem.Security.N amedPermissionS et"/>
> > <SecurityClas s Name="SecurityP ermission"
> > Description="Sy stem.Security.P ermissions.Secu rityPermission, mscorlib,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s[/color]
> Name="StrongNam eMembershipCond ition"[color=green]
> > Description="Sy stem.Security.P olicy.StrongNam eMembershipCond ition,[/color]
> mscorlib,[color=green]
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s Name="UnionCode Group"
> > Description="Sy stem.Security.P olicy.UnionCode Group, mscorlib,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s Name="UrlMember shipCondition"
> > Description="Sy stem.Security.P olicy.UrlMember shipCondition, mscorlib,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s Name="WebPartPe rmission"
> > Description="Mi crosoft.SharePo int.Security.We bPartPermission ,
> > Microsoft.Share Point.Security, Version=11.0.0. 0, Culture=neutral ,
> > PublicKeyToken= 71e9bce111e9429 c"/>
> > <SecurityClas s Name="ZoneMembe rshipCondition"
> > Description="Sy stem.Security.P olicy.ZoneMembe rshipCondition, mscorlib,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > <SecurityClas s Name="SqlClient Permission"
> > Description="Sy stem.Data.SqlCl ient.SqlClientP ermission, System.Data,
> > Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"/>
> > </SecurityClasses >
> > <NamedPermissio nSets>
> > <PermissionSe t
> > class="NamedPer missionSet"
> > version="1"
> > Unrestricted="t rue"
> > Name="FullTrust "
> > Description="Al lows full access to all
> > resources"
> > />
> > <PermissionSe t
> > class="NamedPer missionSet"
> > version="1"
> > Name="Nothing"
> > Description="De nies all resources,[/color]
> including[color=green]
> > the right to execute"
> > />
> > <PermissionSe t
> > class="NamedPer missionSet"
> > version="1"
> > Name="ASP.Net">
> > <IPermission
> > class="AspNetHo stingPermission "
> > version="1"
> > Level="Minimal"
> > />
> > <IPermission
> > class="Security Permission"
> > version="1"
> > Flags="Executio n"
> > />
> > <IPermission class="WebPartP ermission"
> > version="1"
> > Connections="Tr ue"
> > />
> > </PermissionSet>
> > <PermissionSe t class="NamedPer missionSet"
> > version="1" Name="WebPartLi brary1Permissio nSet">
> > <IPermission class="AspNetHo stingPermission " version="1"[/color]
> Level="Medium"[color=green]
> > />
> > <IPermission class="Security Permission" version="1"[/color][/color]
Flags="Assertio n,[color=blue][color=green]
> > Execution, ControlThread, ControlPrincipa l, RemotingConfigu ration,
> > UnmanagedCode" />
> > <IPermission class="WebPartP ermission" version="1"[/color][/color]
Connections="Tr ue"[color=blue]
> />[color=green]
> > <IPermission class="SqlClien tPermission" version="1"
> > AllowBlankPassw ord="False" />
> > </PermissionSet>
> > </NamedPermission Sets>
> > <CodeGroup
> > class="FirstMat chCodeGroup"
> > version="1"
> > PermissionSetNa me="Nothing">
> > <IMembershipCon dition
> > class="AllMembe rshipCondition"
> > version="1"
> > />
> > <CodeGroup
> > class="UnionCod eGroup" version="1"
> > PermissionSetNa me="WebPartLibr ary1PermissionS et">
> > <IMembershipCon dition
> > class="StrongNa meMembershipCon dition"
> > version="1"
> >
> >[/color]
>[/color]
PublicKeyBlob=" 002400000480000 094000000060200 000024000052534 131000400000100 0[color=blue][color=green]
> >[/color]
>[/color]
100B791C96EBFCD 6E192C8998945A6 28B4E3F466EC49B FA4C812BCE256F6 CB8BB734D2EAC64 F[color=blue][color=green]
> >[/color]
>[/color]
6D0C3CFC52135C3 21B21C124765123 69A0D5BCAD0ED80 587C2655A34C681 1D353219C680E95 5[color=blue][color=green]
> >[/color]
>[/color]
E47871281302233 AFF8A0D4009F592 99B3867DF61823E 36FEAA55A5DB0AB DEE2EC39745068C 5[color=blue][color=green]
> > 8BF32E13F2709EC 147890FD33B847D 5" />
> > </CodeGroup>
> > <CodeGroup
> > class="UnionCod eGroup"
> > version="1"
> > PermissionSetNa me="ASP.Net">
> > <IMembershipCon dition
> > class="UrlMembe rshipCondition"
> > version="1"
> > Url="$AppDirUrl $/*"
> > />
> > </CodeGroup>
> > <CodeGroup
> > class="UnionCod eGroup"
> > version="1"
> > PermissionSetNa me="FullTrust" >
> > <IMembershipCon dition
> > class="UrlMembe rshipCondition"
> > version="1"
> > Url="$CodeGen$/*"
> > />
> > </CodeGroup>
> > <CodeGroup
> > class="UnionCod eGroup"
> > version="1"
> > PermissionSetNa me="FullTrust" >
> > <IMembershipCon dition
> > class="UrlMembe rshipCondition"
> > Url="$Gac$/*"
> > version="1"
> > />
> > </CodeGroup>
> > <CodeGroup class="UnionCod eGroup" version="1"
> > PermissionSetNa me="Nothing">
> > <IMembershipCon dition
> > class="ZoneMemb ershipCondition "
> > version="1"
> > Zone="MyCompute r" />
> > <CodeGroup
> > class="UnionCod eGroup"
> > version="1"
> > PermissionSetNa me="FullTrust"
> > Name="Microsoft _Strong_Name"
> > Description="Th is code group grants[/color]
> code[color=green]
> > signed with the Microsoft strong name full trust. ">
> > <IMembershipCon dition
> >
> > class="StrongNa meMembershipCon dition"
> > version="1"
> >
> >[/color]
>[/color]
PublicKeyBlob=" 002400000480000 094000000060200 000024000052534 131000400000100 0[color=blue][color=green]
> >[/color]
>[/color]
10007D1FA57C4AE D9F0A32E84AA0FA EFD0DE9E8FD6AEC 8F87FB03766C834 C99921EB23BE79A D[color=blue][color=green]
> >[/color]
>[/color]
9D5DCC1DD9AD236 132102900B723CF 980957FC4E17710 8FC607774F29E83 20E92EA05ECE4E8 2[color=blue][color=green]
> >[/color]
>[/color]
1C0A5EFE8F1645C 4C0C93C1AB99285 D622CAA652C1DFA D63D745D6F2DE5F 17E5EAF0FC4963D 2[color=blue][color=green]
> > 61C8A1243651820 6DC093344D5AD29 3"
> > />
> > </CodeGroup>
> > <CodeGroup
> > class="UnionCod eGroup"
> > version="1"
> > PermissionSetNa me="FullTrust"
> > Name="Ecma_Stro ng_Name"
> > Description="Th is code group grants[/color]
> code[color=green]
> > signed with the ECMA strong name full trust. ">
> > <IMembershipCon dition
> >
> > class="StrongNa meMembershipCon dition"
> > version="1"
> >
> > PublicKeyBlob=" 000000000000000 004000000000000 00"
> > />
> > </CodeGroup>
> > </CodeGroup>
> > </CodeGroup>
> > </PolicyLevel>
> > </policy>
> > </security>
> > </mscorlib>
> > </configuration>
> >
> >
> >
> >
> >[/color]
>
>[/color]

[John]

Re: webparts &amp; sqlclientpermis sion

"António Pinho" <ajlpinho@hotma il.com> wrote in message news:<Ood3KU5IE HA.3432@tk2msft ngp13.phx.gbl>. ..[color=blue]
> Hi Mihai,
>
> Thanks for your reply, but it didn't work. The error message is still there.
> This is a default sharepoint installation, and a portal with just one site
> (a blank site) on it. Any other suggestion?
>
> Isn't there anyone that uses webparts with sql server, without raising the
> trust level to full?
>[/color]

You need to edit the wss_minimaltrus t.config file.

Add:

<SecurityClas s Name="SqlClient Permission"
Description="Sy stem.Data.SqlCl ient.SqlClientP ermission, System.Data,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"
/>

to the SecurityClasses section and

<IPermission class="SqlClien tPermission" version="1"
Unrestricted="t rue" />

to the PermissionSet section with the attribute Name="ASP.Net"

If you're still having trouble, look through the
wss_mediumtrust .config for the SqlClientPermis sions entries and try to
add them to wss_minimaltrus t.config.

Be forewarned that it's possible that later patches to SPS2003 may
blow out your changes. There's a way to use a different file other
than wss_minimaltrus t.config but I haven't looked for it yet.

uber1024

[António Pinho]

Re: webparts &amp; sqlclientpermis sion



Working nice and smooth. Thanks do everyone.



"John" <djemonk@hotmai l.com> wrote in message
news:d0c756d5.0 404161136.4887f 017@posting.goo gle.com...[color=blue]
> "António Pinho" <ajlpinho@hotma il.com> wrote in message[/color]
news:<Ood3KU5IE HA.3432@tk2msft ngp13.phx.gbl>. ..[color=blue][color=green]
> > Hi Mihai,
> >
> > Thanks for your reply, but it didn't work. The error message is still[/color][/color]
there.[color=blue][color=green]
> > This is a default sharepoint installation, and a portal with just one[/color][/color]
site[color=blue][color=green]
> > (a blank site) on it. Any other suggestion?
> >
> > Isn't there anyone that uses webparts with sql server, without raising[/color][/color]
the[color=blue][color=green]
> > trust level to full?
> >[/color]
>
> You need to edit the wss_minimaltrus t.config file.
>
> Add:
>
> <SecurityClas s Name="SqlClient Permission"
> Description="Sy stem.Data.SqlCl ient.SqlClientP ermission, System.Data,
> Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9"
> />
>
> to the SecurityClasses section and
>
> <IPermission class="SqlClien tPermission" version="1"
> Unrestricted="t rue" />
>
> to the PermissionSet section with the attribute Name="ASP.Net"
>
> If you're still having trouble, look through the
> wss_mediumtrust .config for the SqlClientPermis sions entries and try to
> add them to wss_minimaltrus t.config.
>
> Be forewarned that it's possible that later patches to SPS2003 may
> blow out your changes. There's a way to use a different file other
> than wss_minimaltrus t.config but I haven't looked for it yet.
>
> uber1024[/color]