Hi Imar it's me again. Thanks to the excellent blogs of you and ScottGu I got the site deployed and working! I am running a VWD2005 app and SQL 2K Server backend through Go Daddy and have it working now except for a couple of problems. Since I cannot use the web site administrator feature of VWD on a SQL 2K box, I've developed customized Admin pages for Adding/Editing/Deleting Roles (which does add and/or delete roles by populating the appropriate roles table)as well as other site maintenance pages, and still working on a page to edit users and their roles. In any event, my site map trimming is not working correctly. I have "Admin" pages and "Member" pages identified as such in the website map. When I create a new user I have the Create User Wizard assigning a value for their role of " Member " . When the new user signs up and logs in he sees all pages, including the " Admin " pages. I for the life of me cannot figure out where the error is. I am including code snippets from the CreateUser Wizard code, the section of the web sitemap that is not working and the web config to illustrate the connection strings. Any suggestions as to why this is not putting the user in the correct role so the navigation trimming will work would sure be appreciated.
1. The event code to add the member role via the CreateUser Wizard is as follows:
// CREATE USER METHOD USING CREATE USER WIZARD
public partial class SitePages_CreateAccount : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
Roles.AddUserToRole(CreateUserWizard1.UserName, "Member");
}
}//END CREATE USER
2. Web site map section that is not working properly. You will note in the web config that follows that security trimming is enabled.
<siteMapNode url="~/MemberPages/ComputerTraining/ComputerTraining.aspx" title="Computer Class" description="Computer Class Materials" roles="Member"/>
<siteMapNode url="~/MemberPages/ChangePassword.aspx" title="Change Password" description="Change my password" roles="Member"/>
<siteMapNode url="~/AdminPages/MaintainSite.aspx" title="Maintain Site" description="Maintain Site Data" roles="Admin"/>
3. The customized connection strings used in the web config look like this:
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<add name="ASPNETDBConnectionString" connectionString="
Server=****************secureserver.net;
Database=*******;
User ID=*********;
Password=********;
Trusted_Connection=False " providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="
****************.secureserver.net;
Database=*******;
User ID=*********;
Password=**********;
Trusted_Connection=False " providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<roleManager enabled="true" defaultProvider="CustomizedRoleProvider">
<providers>
<add name="CustomizedRoleProvider" type="System.Web.Security.SqlRoleProvider"
connectionStringName="LocalSqlServer"/>
</providers>
</roleManager>
<authentication mode="Forms"/>
<compilation debug="false"/>
<membership defaultProvider ="CustomizedProvider">
<providers>
<remove name="AspNetSqlMembershipProvider" />
<add name="CustomizedProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="LocalSqlServer"
minRequiredPasswordLength="5"
minRequiredNonalphanumericCharacters="0"
passwordStrengthRegularExpression=""/>
</providers>
</membership>
<!-SITE MAP TRIMMING ENABLES TO SUPPORT USER ROLES-->
<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
<providers>
<add name="XmlSiteMapProvider"
description="Default SiteMap provider."
type="System.Web.XmlSiteMapProvider "
siteMapFile="Web.sitemap"
securityTrimmingEnabled="true" />
</providers>
</siteMap>
<customErrors mode="RemoteOnly" defaultRedirect="customError.aspx">
<error statusCode="404" redirect="missingPage.aspx"/>
</customErrors>
</system.web>
<system.net>
<mailSettings>
<smtp from="***************">
<network host="smtpout.secureserver.net"
userName="******"
password="**********" />
</smtp>
</mailSettings>
</system.net>
</configuration>
