Add/Create ASP.NET Membership tables/view/sp with aspnet

Add/Create ASP.NET Membership tables/view/sp with aspnet_regsql

To install the membership database, log on to your server with an account that has authority to administrate SQL Server (such as the Administrator account). If you want to add membership tables to existing DB then use that DB in example else create new DB, here I’m creating new DB with Name Test_Membership as below(and will use this DB throughout this example):

Fig.1 Create New DB wizard

Fig.2 Give DB name and click OK to create DB

Now DB is created, next step is create Membership tables to your DB, here we goes:

If you love to work with command prompt then follow these two simple steps:

1. Start a Visual Studio command prompt by going to Start -> All Programs -> Visual Studio 2010 -> Visual Studio Tools -> Visual Studio Command Prompt.

2. Run the following command, using the your Test_Membership database settings to fill in the values in brackets: aspnet_regsql.exe -S [Host] -d [Name] -U [Username] -P [Password] -A all

And your Membership tables/view/sp are added to your DB.

Else if you love to work with designer and want to add membership details to your DB through designer, then follow these simple steps.

1. Run C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql.exe.

2. Click on Next

3. Select “Configure SQL Server for application services” and click on Next.

4. Select “Windows Authentication” and then select Database and hit Next.

While accessing DB through Windows Authentication some may face error : failed to query a list of database names,

if there is no error then go to next step, but if you face such error then simply select SQL server Authentication and enter username and password and then select your DB as: