forms authentication with sql server 2008 database questions

Question

Hello I been trying to figure out how to set up ASP.Net forms authentication with sql database I have been trying to figure out how to set up my forms authentication with my sql database. So when I update my admin table it also updates the admin list in the forms authentication.

Any ideas would help thank you!

IrishChieftain · Accepted Answer · 2012-03-28 06:10:44Z

3

Just run the aspnet_regsql.exe tool and the membership database will be created for you. If you run it without any parameters, it will present you with a wizard to guide you through the database creation process.

Here's an example of what you need to add to your Web.Config:

<roleManager enabled="true"/>
<authentication mode="Forms">
    <forms timeout="50000000"/>
</authentication>
<membership defaultProvider="SqlProvider">
    <providers>
    <clear/>
    <add connectionStringName="LocalSqlServer" 
        applicationName="/" 
        enablePasswordRetrieval="false" 
        enablePasswordReset="true" 
        requiresQuestionAndAnswer="false" 
        requiresUniqueEmail="false" 
        passwordFormat="Hashed" 
        minRequiredPasswordLength="6" 
        minRequiredNonalphanumericCharacters="0" 
        name="SqlProvider" 
        type="System.Web.Security.SqlMembershipProvider"/>
    </providers>
</membership>

Also note that you can perform all configuration (except the provider) using the ASP.NET WAT (Web Site Administration Tool) from withing Visual Studio.

Here's a walk-through of the entire process:

Walkthrough: Creating a Web Site with Membership and User Login

edited Mar 28, 2012 at 6:10

answered Mar 28, 2012 at 6:04

IrishChieftain

15.2k8 gold badges55 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user996502 Over a year ago

thank you however i was wondering how would you add new member in sql database with out using asp.net confi would you do it in ado?

IrishChieftain Over a year ago

Use the WAT tool icon at the top right of solution explorer in VS :) Then it's GUI driven for this - you can further tweak setting in the secure folder Web.Config file(s) it generates.

user996502 Over a year ago

thank you! question i have a databse of username and password how would i use the asp.net forms register page to add admin instead of adding each admin one at a time thank you.

IrishChieftain Over a year ago

Do something like this (though I do not advise it unless you have a lot of admins) forums.asp.net/t/1259172.aspx/1

Collectives™ on Stack Overflow

forms authentication with sql server 2008 database questions

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related