Adding sql membership in Asp.Net mvc project

How to add sql membership in Asp.Net mvc project using command line tool.


Posted: February 19, 2017. | By: mustafa

How to add sql membership in Asp.Net mvc project

Steps to follow

  1. Create membership db
  2. Add configuration in web.config
  3. Add membership users & roles


1. Create membership db

We are going to create membership tables in our database using command line tool.
First of all open command prompt.
Navigate to directory %WINDOWS%\Microsoft.NET\Framework\v4.0.30319\ in your local file system.
Now lets run command -
aspnet_regsql.exe -S <server> -U <login id> -P <password> -d <database> -A all

Add database credentials like: database server, username and password & database name.
aspnet_regsql.exe -S .\SqlExpress -U sa -P ****** -d testDB -A all
The -A all installs all membership features to install specific like membership and roles use -A mr for most common cases.
command parameters include -
m - membership
p - profile
r - roles
all - include all above features

This will install db schema for membership & roles.


aspnet_regsql.exe -S .\SqlExpress -U sa -P ****** -d testDB -A mr.


2. Add configuration in web.config

Necessary part is to add configuration settings in web.config.
So lets open web.config file and add defaultconnection in connection string.

<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=ServerName;Initial Catalog=dbName;Integrated Security=False;User ID=sa;Password=*****" /></connectionStrings>

Now add profile, membership & roles.

<profile defaultProvider="SqlProfileProvider" enabled="true">
 <add name="SqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="DefaultConnection" applicationName="App v1.0" />
 <membership defaultProvider="SqlMembershipProvider">
 <add name="SqlMembershipProvider" connectionStringName="DefaultConnection" enablePasswordRetrieval="false"
 enablePasswordReset="true" requiresQuestionAndAnswer="false"
 requiresUniqueEmail="true" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6"
 applicationName="App v1.0" type="System.Web.Security.SqlMembershipProvider" />
 <roleManager enabled="true" defaultProvider="SqlRoleProvider">
 <add connectionStringName="DefaultConnection" applicationName="App v1.0"
 name="SqlRoleProvider" type="System.Web.Security.SqlRoleProvider" />


 3. Add membership users & roles

After we have added membership configuration select project in Visual studio solution explorer.
We can go to project menu and select Asp.Net Configuration – This will open Web Administration tool in Web browser.
Which will give you a panel to create user roles and login.


web-administraion.png, undefined, SQL,

related posts

Back to top