Welcome

Welcome to CMS n Web. Learn & Study completely Free Articles\Training about Web Designing\Development and CMS.

Search This Web

Tuesday, July 16, 2013

SQL Membership Provider and aspnet_regsql.exe Utility

(How to add User Management Tables in Our Database or in SQL server)

The aspnet_regsql.exe runs the ASP.NET SQL Server Setup Wizard which allows you to create or configure a SQL Server database to store information for membership, profiles, role management, personalization, and SQL Web event provider. Once created, you may use forms authentication and the login controls to access these tables.
In the Microsoft.NET/Framework/... directory as shown below, find the aspnet_regsql.exe.
Execute the aspnet_regsql.exe file to begin the ASP.NET SQL Server Setup Wizard to create the SQL Server database or add tables to an existing database:
Select to Configure SQL Server for application services:
Select a Server name for Windows authentication and then select an existing database name or use the default. Choosing the default will name the database "aspnetdb."
If you want to use an existing database, simply select the database:
The wizard will now summarize, run and create the database.
After completion, you may use the Database Explorer to view your tables:
When done creating the database, you would setup your web config file with the connection string to the aspnetdb.mdf. You would also make sure your authentication mode is set to forms: authentication mode="Forms" (see below).
Once you've completed the connection string, you will want to setup a user in your tables. To do this, you may use the ASP.NET Configuration under the Website menu item.
You may use the Security tab to add and edit users.
Select the Create User link to create a user. Select the "Administrators" checkbox if you wish this to be an administrative account. Once your Admin account is created, others may use the CreateUserWizard in your application in order to create accounts.
To add Log in and User Creation to your website, use the Login Controls.
Using the Login and CreateUserWizard controls will automatically create the code and forms as shown below:
Log In
Sign Up for Your New Account