Create a ASP.NET Membership Security Database

Create a ASP.NET Membership Security Database
==========================================

Use System.Security namespace for create/delete/update user, user roles etc. of membership instance we have to create Table, procedure, views. I will explain how to add ASP.NET 2.0/3.5 or later Membership Security tables, stored procedures, views to existing SQL Server database.

suggestion: create a test database first to test this, don’t do directly on production database!

Prerequisites:

Visual Studio 2005/2008 installed

SQL Server 2005/08 installed (with a current database and your windows account with dbo/admin rights)

1. Locate your SQL Database – make sure you have rights to it
2. Locate the Visual Studio Command Prompt (All Programs; Microsoft Visual Studio 2005; Visual Studio Tools; Visual Studio 2005 Command Prompt)

run the following Command: aspnet_regsql -S (local) -E -d TestDatabseName -A all

Here, Instead of (local) we can use serverName.


For More details write aspnet_regsql /? on Visual Studio Command prompt.