Hello,
I am working on a test site to explore the new login controls and membership
features of ASP.NET v2.0. I have tested the controls using SQL Express and
have now decided to try using a central SQL Server 2000 database. When I use
the all of the included controls with SQL Express everything works great but
when I use it against SQL Server 2000 I can't get past the login page.
When in Visual Studio IDE and open the web admin page I can add users and
roles and the entrys are present in the SQL Server 2000 database. With that
said why am I having issues with the login process? There is no code for the
control so the only issue could be in the web.config file.
Here is me config file.
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<add name="MyDB" connectionString="Connection String to Server"/>
</connectionStrings>
<system.web>
<!-- Set a site wide theme -->
<pages theme="Default"/>
<compilation debug="true"/>
<authentication mode="Forms">
<forms loginUrl="login.aspx" name=".ASPXFORMSAUTH"/>
</authentication>
<authorization>
<deny users="?"/>
</authorization>
<!-- Define the roles management provider -->
<roleManager enabled="true" defaultProvider="RolesSqlProvider">
<providers>
<add name="RolesSqlProvider" type="System.Web.Security.SqlRoleProvider,
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="MyDB"
applicationName="/"/>
</providers>
</roleManager>
<!-- Define the membership management provider -->
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20">
<providers>
<remove name="AspNetSqlProvider"/>
<add connectionStringName="MyDB"
enablePasswordRetrieval="false"
requiresUniqueEmail="true"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
passwordFormat="Hashed"
applicationName="/"
name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider"/>
</providers>
</membership>
<!-- Difine the Profiles managment provider -->
<profile enabled="true" defaultProvider="ProfileSqlProvider">
<providers>
<add name="ProfileSqlProvider"
type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.3600.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="MyDB" applicationName="/"/>
</providers>
<properties>
<add name="FirstName" type="System.String"/>
<add name="LastName" type="System.String"/>
<add name="LastVisit" type="System.DateTime"/>
<add name="UserId"/>
</properties>
</profile>
</system.web>
</configuration>
Any help would be appriciated.
Thanks,
RedEye
