ASP.NET v2.0 login control issue with SQL Server 2000

[RedEye]

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

 

[Weston Weems]

Yep... you made sure you ran aspnet_regsql from the frameworks folder?

You've got several framework specific storedprocs and tables.
read here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/SecFeatNT2.asp

Weston Weems

 

[RedEye]

Oh yes, I made sure to do that before I started. Any other ideas?

Thanks

 

[Robert Smith]

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.

 

[MEC]

No answer but wondering if you solved this isse as I'm having the exact
problem as well?

 

[Juan T. Llibre]

Take a look at :

Writing a Custom Membership Provider
http://www.15seconds.com/issue/050216.htm

Installing the Database using aspnet_regsql.exe
http://msdn2.microsoft.com/library/x28wfk74(en-us,vs.80).aspx

Working own provider
http://forums.asp.net/899888/ShowPost.aspx

You should be able to cobble the pieces from those examples,
to get your own provider working.